Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 4 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.

1.

WHICH_OF_THE_FOLLOWING_STORED_PROCEDURE_IS_USED_TO_ADD_A_PRIMARY_DATABASE_ON_PRIMARY_SERVER_??$

A. sp_add_log_shipping_primary_database
B. sp_add_primary_database
C. sp_add_log_shipping
D. sp_add_log_shipping_primary
Answer» D. sp_add_log_shipping_primary
Discussion
2.

Execute_sp_add_jobschedule_to_add_a_schedule_for_the_backup_job_on___________server$

A. primary
B. secondary
C. primary and secondary
D. None of the mentioned
Answer» D. None of the mentioned
Discussion
3.

In which of the following modes, the database is read-only ?

A. Stand by
B. Read only
C. Restore mode
D. All of the mentioned
Answer» B. Read only
Discussion
4.

Which of the following is the instance of SQL Server that is your production server in log shipping ?

A. secondary database
B. primary database
C. secondary server
D. primary server
Answer» E.
Discussion