Interview question based on skill :
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. Which of the following is biggest disadvantage of change tracking ?
Correct Answer is : Triggers are fired for each change that has been made to a row
2. Point out the wrong statement :
Correct Answer is : Change tracking is used for one way synchronization applications only
3. Which of the following code snippet returns a version integer that is associated with the last committed transaction that was tracked by change tracking ?
Correct Answer is : SELECT @sync_new_received_anchor = change_tracking_current_version()
4. _____________ obtains tracking information for all changes to a table that have occurred since a specific version.
Correct Answer is : CHANGETABLE
5. Which of the following is catalog view used for change tracking ?
Correct Answer is : sys.change_tracking_tables
6. Which of the following feature distinguishes change data capture from change tracking ?
Correct Answer is : Historical data
7. Which of the following is not a class of constraint in SQL Server ?
Correct Answer is :
8. Point out the correct statement :
Correct Answer is : All of the mentioned
9. Which of the following constraint does not enforce uniqueness ?
Correct Answer is : Foreign key
10. Constraints can be applied on :
Correct Answer is : All of the mentioned
11. Point out the wrong statement :
Correct Answer is : Primary keys allow for NULL as one of the unique values
12. Purpose of foreign key constraint in SQL Server is :
Correct Answer is : FOREIGN KEY constraints identify and enforce the relationships between tables
13. Which of the following is not a foreign key constraint ?
Correct Answer is : CASCADE
14. Which of the following foreign key constraint specifies that the deletion fails with an error ?
Correct Answer is : NO ACTION
15. How many types of constraints are present in SQL Server ?
Correct Answer is : 6
16. Which of the constraint can be enforced one per table ?
Correct Answer is : Primary key constraint
17. Life cycle of typical cursor involves ______ steps in SQL Server.
Correct Answer is : 5
18. Point out the correct statement :
Correct Answer is : All of the mentioned
19. How many type of cursor is present in SQL Server ?
Correct Answer is : 4
20. Various alternatives to cursor in SQL Server are :
Correct Answer is : WHILE
