SQL Server interview questions part 16
SQL Server interview questions part 16
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. Which is not a type of join in T-SQL?
Correct Answer is : Natural join
2. Which of the following resource can be locked in SQL Server ?
Correct Answer is : RID
3. Point out the correct statement :
Correct Answer is : A deadlock occurs when there is a cyclic dependency between two or more threads for some set of resources
4. ______________ allow concurrent transactions to read (SELECT) a resource.
Correct Answer is : Shared locks
5. Which is the most restrictive isolation level in transaction ?
Correct Answer is : SERIALIZABLE
6. Point out the wrong statement :
Correct Answer is : By default, SQL Server transactions times out after a certain time
7. __________ locks allow processes to bulk copy data concurrently into the same table.
Correct Answer is : Bulk update
8. Which of the following locking hint is similar to NOLOCK ?
Correct Answer is : READUNCOMMITTED
9. Which of the following mode indicates the intention of the transaction to read all of the resources lower in the hierarchy ?
Correct Answer is : SIX
10. Which of the following lock is incompatible with all lock modes ?
Correct Answer is : Schema modification
11. Which of the following mode has exclusive range and exclusive resource lock ?
Correct Answer is : RangeX_X
12. Which of the following is the instance of SQL Server that is your production server in log shipping ?
Correct Answer is : primary server
13. Point out the correct statement :
Correct Answer is : The restore job can be delayed until all users disconnect themselves
14. In which of the following modes, the database is read-only ?
Correct Answer is : Stand by
15. Point out the wrong statement :
Correct Answer is : Log Shipping is comparatively tougher than database mirroring for setup
16. Which of the following stored procedure is used to add a primary database on primary server ?
Correct Answer is : sp_add_log_shipping_primary_database
17. Execute sp_add_jobschedule to add a schedule for the backup job on _________ server
Correct Answer is : primary
18. Which of the following table stores history detail for log shipping jobs ?
Correct Answer is : log_shipping_monitor_history_detail
19. _____________ maps primary databases to secondary databases in log shipping.
Correct Answer is : log_shipping_primary_secondaries
20. Management Studio is ________ used for development of SQL Server database.
Correct Answer is : Front end tool
