SQL Server interview questions part 23
SQL Server interview questions part 23
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. How many types of recovery model is provided by SQL Server ?
Correct Answer is : 3
2. No log backups is a feature of __________ recovery model.
Correct Answer is : Simple
3. Point out the wrong statement :
Correct Answer is : Managing databases with simple recovery model is much easier
4. Which the following feature cannot be used in simple recovery mode ?
Correct Answer is : All of the mentioned
5. Which of the following recovery models requires log backups ?
Correct Answer is : Full
6. How many type of backups you can run when the data is in the “Full” recovery model ?
Correct Answer is : 6
7. The _______ recovery model is a special-purpose model that works in a similar manner to the full recovery model.
Correct Answer is : bulk-logged
8. Which of the following statement is used for changing Recovery Model with T-SQL ?
Correct Answer is : ALTER DATABASE
9. ___________ is a set of technologies for copying and distributing data and database objects from one database to another.
Correct Answer is : Replication
10. Point out the correct statement :
Correct Answer is : Transactional replication is typically used in server-to-server
11. How many types of replication is provided by SQL Server?
Correct Answer is : 3
12. Replication in SQL Server is used to overcome :
Correct Answer is : All of the mentioned
13. Point out the wrong statement :
Correct Answer is : Replication is object level low availability feature
14. Which of the following is disadvantage of replication?
Correct Answer is : None of the mentioned
15. Which of the following stored procedure provide replication support for AlwaysOn?
Correct Answer is : sp_validate_replica_hosts_as_publishers
16. How many types of replication components are present in SQL Server?
Correct Answer is : 8
17. Which of the following makes data available for replication?
Correct Answer is : Publisher
18. Two types of subscriptions present for replication is :
Correct Answer is : push and pull
19. Which of the following tool requires Reporting Services in SharePoint mode?
Correct Answer is : Power View
20. Point out the correct statement :
Correct Answer is : SQL Server Reporting Services contains a set of graphical and scripting tools that support the development and use of rich reports in a managed environment
