Personal Growth Unlimited’s Post

Quiz Time # 518 | 30-Oct-2024 | MS SQL DBA      DBCC CHECKDB with NOINDEX is used to              1.Reduce the overall time execution              2.Increase the overall time execution              3.Increase the intensity of checking               4.Decrease the intensity of checking comment your answer Follow me and #dbaasservice for more update DBA as a Service: DBA as a Service (DBaaS) is a modern approach to database management where your organization can leverage 1. Dedicated expertise without the need for an in-house DBA. 2. Expand DBA support without increasing headcounts 3. Eliminate DBA recruiting and training cost. #sqldba #quiz #australia #sqlserver #sql #database #azure #microsoft #tips #careergoals 

Quiz Time # 499 | 11-Oct-2024 | MS SQL DBA   Which among the below dynamic view used for currently allocated memory . 1.                  Sys.dm_os_process_memory 2.                  Sys.dm_os_buffer_descriptors 3.                  Sys.dm_db_resource_stats 4.                  Sys.dm_os_memory_nodes comment your answer Follow me and #dbaasservice for more update DBA as a Service: DBA as a Service (DBaaS) is a modern approach to database management where your organization can leverage 1. Dedicated expertise without the need for an in-house DBA. 2. Expand DBA support without increasing headcounts 3. Eliminate DBA recruiting and training cost. #sqldba #quiz #australia #sqlserver #sql #database #azure #microsoft #tips #careergoals   

Quiz Time # 516 | 28-Oct-2024 | MS SQL DBA                                                                                                   Which is command to check database with suppressing info messages              1. DBCC CHECKDB WITH MSG_OFF              2. DBCC CHECKDB WITH INFOMSG_OFF              3. DBCC CHECKDB WITH NO_INFOMSGS              4. DBCC CHECKDB WITH NOINFO comment your answer Follow me and #dbaasservice for more update DBA as a Service: DBA as a Service (DBaaS) is a modern approach to database management where your organization can leverage 1. Dedicated expertise without the need for an in-house DBA. 2. Expand DBA support without increasing headcounts 3. Eliminate DBA recruiting and training cost. #sqldba #quiz #australia #sqlserver #sql #database #azure #microsoft #tips #careergoals 

Quiz Time # 514 | 26-Oct-2024 | MS SQL DBA     DBCC CHECKDB validation occurs only on which among the below which contains memory optimized tables 1.                  Disk based tables 2.                  Ram based tables 3.                  Cache based tables 4.                  None comment your answer Follow me and #dbaasservice for more update DBA as a Service: DBA as a Service (DBaaS) is a modern approach to database management where your organization can leverage 1. Dedicated expertise without the need for an in-house DBA. 2. Expand DBA support without increasing headcounts 3. Eliminate DBA recruiting and training cost. #sqldba #quiz #australia #sqlserver #sql #database #azure #microsoft #tips #careergoals 

Quiz Time # 514 | 26-Oct-2024 | MS SQL DBA     DBCC CHECKDB validation occurs only on which among the below which contains memory optimized tables 1.                  Disk based tables 2.                  Ram based tables 3.                  Cache based tables 4.                  None comment your answer Follow me and #dbaasservice for more update DBA as a Service: DBA as a Service (DBaaS) is a modern approach to database management where your organization can leverage 1. Dedicated expertise without the need for an in-house DBA. 2. Expand DBA support without increasing headcounts 3. Eliminate DBA recruiting and training cost. #sqldba #quiz #australia #sqlserver #sql #database #azure #microsoft #tips #careergoals 

Quiz Time # 468 | 10-Sept-2024 | MS SQL DBA       Recovery model is a database property that controls 1.                  How Transactions are Logged 2.                  How Transactions are committed 3.                  How Transactions are Rollbacked 4.                  How Transactions are Begun comment your answer Follow me and #dbaasservice for more update DBA as a Service: DBA as a Service (DBaaS) is a modern approach to database management where your organization can leverage 1. Dedicated expertise without the need for an in-house DBA. 2. Expand DBA support without increasing headcounts 3. Eliminate DBA recruiting and training cost. #sqldba #quiz #australia #sqlserver #sql #database #azure #microsoft #tips #careergoals 

Quiz Time # 516 | 28-Oct-2024 | MS SQL DBA                                                                                                   Which is command to check database with suppressing info messages              1. DBCC CHECKDB WITH MSG_OFF              2. DBCC CHECKDB WITH INFOMSG_OFF              3. DBCC CHECKDB WITH NO_INFOMSGS              4. DBCC CHECKDB WITH NOINFO comment your answer Follow me and #dbaasservice for more update DBA as a Service: DBA as a Service (DBaaS) is a modern approach to database management where your organization can leverage 1. Dedicated expertise without the need for an in-house DBA. 2. Expand DBA support without increasing headcounts 3. Eliminate DBA recruiting and training cost. #sqldba #quiz #australia #sqlserver #sql #database #azure #microsoft #tips #careergoals 

Quiz Time # 509 | 21-Oct-2024 | MS SQL DBA     What is the maximum parameter can be set in user defined function in sql server 2016 & above              1.          1100              2.          2100              3.          100              4.          50 comment your answer Follow me and #dbaasservice for more update DBA as a Service: DBA as a Service (DBaaS) is a modern approach to database management where your organization can leverage 1. Dedicated expertise without the need for an in-house DBA. 2. Expand DBA support without increasing headcounts 3. Eliminate DBA recruiting and training cost. #sqldba #quiz #australia #sqlserver #sql #database #azure #microsoft #tips #careergoals 

Quiz Time # 529 | 10-Nov-2024 | MS SQL DBA     Which among the below commands are used to check current size and growth parameters of tempdb. 1.                  Tempdb.sys.database_files 2.                  Temp.sysfiles 3.                  Tempdb.sysfiles 4.                  Temp.sys.database_files comment your answer Follow me and #dbaasservice for more update DBA as a Service: DBA as a Service (DBaaS) is a modern approach to database management where your organization can leverage 1. Dedicated expertise without the need for an in-house DBA. 2. Expand DBA support without increasing headcounts 3. Eliminate DBA recruiting and training cost. #sqldba #quiz #australia #sqlserver #sql #database #azure #microsoft #tips #careergoals 

Quiz Time # 545 | 26-Nov-2024 | MS SQL DBA Surface area reduction is a security measure that involves 1.                  Stopping or disabling unused components 2.                  Stopping or disabling used components 3.                  Stopping or disabling all components 4.                  None of the above comment your answer Follow me and #dbaasservice for more update DBA as a Service: DBA as a Service (DBaaS) is a modern approach to database management where your organization can leverage 1. Dedicated expertise without the need for an in-house DBA. 2. Expand DBA support without increasing headcounts 3. Eliminate DBA recruiting and training cost. #sqldba #quiz #australia #sqlserver #sql #database #azure #microsoft #tips #careergoals