gs gs116 Enterprise Data Management - Log Shipping - Quiz No.1
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Enterprise Data Management. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Which of the following is the instance of SQL Server that is your production server in log shipping?
secondary database
primary database
secondary server
primary server
Question 2: Point out the correct statement.
The restore job can be delayed until all users disconnect themselves
Log shipping cannot be combined with other disaster recovery options such as AlwaysOn Availability Groups
SQL Server log shipping has high cost in human
None of the mentioned
Question 3: In which of the following modes, the database is read-only?
Stand by
Read only
Restore mode
All of the mentioned
Question 4: Which of the following script can check the database recovery model by querying sys.databases for log shipping?
SELECT name, recovery_model_desc FROM sys.databases WHERE name = 'jugal' USE [master] GO UPDATE DATABASE [jugal] SET RECOVERY FULL WITH NO_WAIT GO SELECT name, recovery_model_desc FROM sys.databases WHERE name = 'jugal' USE [master] GO ALTER DATABASE [jugal] SET RECOVERY FULL WITH NO_WAIT GO SELECT name, recovery_model_desc FROM sys.databases WHERE name = 'jugal' USE [master] GO DROP DATABASE [jugal] SET RECOVERY FULL WITH NO_WAIT GO
None of the mentioned
Question 5: Point out the wrong statement.
The principal database in a mirroring session can also act as the primary database in a log shipping
Log Shipping is comparatively tougher than database mirroring for setup
The database log shipping setup needs to be initiated from the principal server using the SQL Server Management Studio wizard
A given database can be mirrored or log shipped; it can also be simultaneously mirrored and log shipped
Question 6: Which of the following stored procedure is used to add a primary database on primary server?
sp_add_log_shipping_primary_database
sp_add_primary_database
sp_add_log_shipping
sp_add_log_shipping_primary
Question 7: Execute sp_add_jobschedule to add a schedule for the backup job on _________ server.
primary
secondary
primary and secondary
none of the mentioned
Question 8: Which of the following is correct syntax for sp_add_log_shipping_secondary_primary?
sp_add_log_shipping_secondary_primary [ @secondary_server = ] 'primary_server', sp_add_log_shipping_secondary_primary [ @primary_server = ] 'primary_server', xp_add_log_shipping_secondary_primary [ @primary_server = ] 'primary_server',
All of the mentioned
Question 9: Which of the following table stores history detail for log shipping jobs?
log_shipping_monitor_alert
log_shipping_monitor_primary
log_shipping_monitor_history_detail
none of the mentioned
Question 10: _____________ maps primary databases to secondary databases in log shipping.
sp_change_log_shipping_primary_database
log_shipping_primary_databases
log_shipping_primary_secondaries
sp_help_log_shipping_primary_database
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
