Parag Patel’s Post

Quiz Time # 519 | 31-Oct-2024 | MS SQL DBA     The state error 5 when executing DBCC Check db denotes 1. An assert or access violation was detected 2. An unknown error occurred that terminated dbcc command 3. Corruption in metadata that terminated dbcc command 4. A failure occurred during emergency mode database repair 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 # 286 | 12-Mar-2024 | MS SQL DBA     Which among the below command replaces Dbcc log info              1.          sys.dm_db_log_info              2.          sys.dm_log_info              3.          sys.dm_loginfo              4.          sys.dm_info 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 #database #microsoft #australia

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 # 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 # 543 | 24-Nov-2024 | MS SQL DBA   Which among the below is followed for physical level security 1.                  Using locked rooms with restricted access to db server 2.                  Limit access to backup media in a secured location 3.                  Strictly limit access to physical and hardware components 4.                  All 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   

Quiz Time # 543 | 24-Nov-2024 | MS SQL DBA   Which among the below is followed for physical level security 1.                  Using locked rooms with restricted access to db server 2.                  Limit access to backup media in a secured location 3.                  Strictly limit access to physical and hardware components 4.                  All 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 

Quiz Time # 515 | 27-Oct-2024 | MS SQL DBA     For data integrity issue occurring on memory optimized tables , which is used to fix 1.                  Restore from last known good backup 2.                  Restore with Dbcc repair 3.                  Restore with Dbcc checkdb 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 

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 # 289 | 15-Mar-2024 | MS SQL DBA   Dbcc show_statistics is similar to which among the below DMV   1.                  sys.dm_db_stats_histogram 2.                  sys.dm_db_log_stats 3.                  sys.dm_db_stats 4.                  sys.dm_db_statistics 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 #database #microsoft #australia

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