SQL Server Interview Questions - 7

1. Which of the following is biggest disadvantage of change tracking ?

A. Schema changes are required in the server database

B. Triggers are fired for each change that has been made to a row

C. Logic for maintaining the correct row versions and deletions is easy

D. All of the mentioned

Correct Answer is : Triggers are fired for each change that has been made to a row

2. Point out the wrong statement :

A. Change tracking is used for one way synchronization applications only

B. Applications that have to synchronize data with an instance of the SQL Server Database Engine must be able to query for changes

C. Two-way synchronization applications can also be built that use change tracking

D. The two-way synchronization applications must be able to detect conflicts

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 ?

A. SELECT @sync_new_received_anchor = change_tracking_cur_version()

B. SELECT @sync_new_received_anchor = change_tracking_current_ver()

C. SELECT @sync_new_received_anchor = change_tracking_current_version()

D. SELECT @sync_new_received_anchor = change_track_current_version()

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.

A. CHANGETABLE_CONTEXT

B. CHANGETABLE

C. CHANGE_TRACKING_IS_COLUMN_IN_MASK

D. All of the mentioned

Correct Answer is : CHANGETABLE

5. Which of the following is catalog view used for change tracking ?

A. sys.change_tracking_tables

B. sys.change_tracking_views

C. sys.change_tracking_columns

D. None of the mentioned

Correct Answer is : sys.change_tracking_tables

6. Which of the following feature distinguishes change data capture from change tracking ?

A. Historical data

B. DML

C. DML type

D. Whether column was changed

Correct Answer is : Historical data

7. Which of the following is not a class of constraint in SQL Server ?

A. NOT NULL

B. CHECK

C.

D. UNIQUE

Correct Answer is :

8. Point out the correct statement :

A. CHECK constraints enforce domain integrity

B. UNIQUE constraints enforce the uniqueness of the values in a set of columns

C. In a UNIQUE constraint, no two rows in the table can have the same value for the columns

D. All of the mentioned

Correct Answer is : All of the mentioned

9. Which of the following constraint does not enforce uniqueness ?

A. UNIQUE

B. Primary key

C. Foreign key

D. None of the mentioned

Correct Answer is : Foreign key

10. Constraints can be applied on :

A. Column

B. Table

C. Field

D. All of the mentioned

Correct Answer is : All of the mentioned

11. Point out the wrong statement :

A. Table constraints must be used when more than one column must be included in a constraint

B. A column constraint is specified as part of a column definition and applies only to that column

C. A table constraint is declared independently from a column definition and can apply to more than one column in a table

D. Primary keys allow for NULL as one of the unique values

Correct Answer is : Primary keys allow for NULL as one of the unique values

12. Purpose of foreign key constraint in SQL Server is :

A. FOREIGN KEY constraints identify and enforce the relationships between tables

B. A foreign key in one table points to a candidate key in another table

C. You cannot insert a row with a foreign key value, except NULL, if there is no candidate key with that value

D. None of the mentioned

Correct Answer is : FOREIGN KEY constraints identify and enforce the relationships between tables

13. Which of the following is not a foreign key constraint ?

A. NO ACTION

B. CASCADE

C. SET NULL

D. All of the mentioned

Correct Answer is : CASCADE

14. Which of the following foreign key constraint specifies that the deletion fails with an error ?

A. NO ACTION

B. CASCADE

C. SET NULL

D. All of the mentioned

Correct Answer is : NO ACTION

15. How many types of constraints are present in SQL Server ?

A. 4

B. 5

C. 6

D. 7

Correct Answer is : 6

16. Which of the constraint can be enforced one per table ?

A. Primary key constraint

B. Not Null constraint

C. Foreign Key constraint

D. Check constraint

Correct Answer is : Primary key constraint

17. Life cycle of typical cursor involves ______ steps in SQL Server.

A. 2

B. 3

C. 4

D. 5

Correct Answer is : 5

18. Point out the correct statement :

A. A Cursor is opened and populated by executing the SQL statement defined by the cursor

B. After data manipulation, we should close the cursor explicitly

C. A cursor is declared by defining the SQL statement that returns a result set

D. All of the mentioned

Correct Answer is : All of the mentioned

19. How many type of cursor is present in SQL Server ?

A. 3

B. 4

C. 5

D. 6

Correct Answer is : 4

20. Various alternatives to cursor in SQL Server are :

A. FOR

B. IF..ELSE

C. WHILE

D. All of the mentioned

Correct Answer is : WHILE

SQL Server interview questions part 7

SQL Server interview questions part 7

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 ?

2. Point out the wrong statement :

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 ?

4. _____________ obtains tracking information for all changes to a table that have occurred since a specific version.

5. Which of the following is catalog view used for change tracking ?

6. Which of the following feature distinguishes change data capture from change tracking ?

7. Which of the following is not a class of constraint in SQL Server ?

8. Point out the correct statement :

9. Which of the following constraint does not enforce uniqueness ?

10. Constraints can be applied on :

11. Point out the wrong statement :

12. Purpose of foreign key constraint in SQL Server is :

13. Which of the following is not a foreign key constraint ?

14. Which of the following foreign key constraint specifies that the deletion fails with an error ?

15. How many types of constraints are present in SQL Server ?

16. Which of the constraint can be enforced one per table ?

17. Life cycle of typical cursor involves ______ steps in SQL Server.

18. Point out the correct statement :

19. How many type of cursor is present in SQL Server ?

20. Various alternatives to cursor in SQL Server are :

Similar Interview Questions

Search for latest jobs

For Employers

For Partner

For Jobseekers

Help

Follow Us

snaprecruit

Download mobile appsJust Swipe to apply for jobs. Try it out !