SQL Server Interview Questions - 32 | Snaprecruit.com

SQL Server Interview Questions - 32 | Snaprecruit.com

SQL Server interview questions part 32

SQL Server interview questions part 32

Take as many assements as you can to improve your validate your skill rating

Total Questions: 20

1. Which of the following system database occupies more space and memory?

Correct Answer is : Master

2. The _________ database stores basic configuration information for the server.

Correct Answer is : Master

3. The INSERT, UPDATE, or DELETE statement fails if the OLE DB provider used to access the linked server does not support the _________ interface.

Correct Answer is : ITransactionJoin

4. Point out the correct statement :

Correct Answer is : COMMIT WORK syntax, with or without specifying the optional keyword WORK, is compatible with SQL-92

5. __________ marks the end of a successful implicit or explicit transaction.

Correct Answer is : COMMIT TRANSACTION

6. ____________ rolls back a user-specified transaction to the beginning of the transaction.

Correct Answer is : ROLLBACK WORK

7. In _______ transaction we include the DML statements that need to be execute as a unit.

Correct Answer is : Explicit

8. _________ permissions default to any valid user.

Correct Answer is : ROLLBACK WORK

9. If @@TRANCOUNT is 1, ________ makes all data modifications performed since the start of the transaction a permanent part of the database.

Correct Answer is : COMMIT TRANSACTION

10. Which of the following argument is ignored by database engine in COMMIT TRANSACTION?

Correct Answer is : @tran_name_variable

11. Point out the correct statement :

Correct Answer is : Issuing a COMMIT TRANSACTION when @@TRANCOUNT is 0 results in an error

12. ____________ is the preferred statement for indicating errors in the transaction.

Correct Answer is : RAISERROR

13. Point out the wrong statement :

Correct Answer is : The Database Engine increments the transaction count within a statement only when the transaction count is 1 at the start of the statement

14. A ROLLBACK TRANSACTION statement specifying a savepoint_name releases any locks that are acquired beyond the savepoint, with the exception of:.

Correct Answer is : escalations

15. What is the fundamental difference between COMMIT and COMMIT WORK ?

Correct Answer is : COMMIT TRANSACTION accepts a user-defined transaction name

16. Implicit transactions are maintained by SQL Server for :

Correct Answer is : All of the mentioned

17. ROLLBACK WORK always rolls back to the outermost BEGIN TRANSACTION statement for ___________ transactions.

Correct Answer is : Nested

18. Which of the following condition will ignore the request to enable delayed durability ?

Correct Answer is : DELAYED_DURABILITY = FORCED

19. Which of the following wizard provides creation logins on the destination server?

Correct Answer is : Copy Database

20. Point out the correct statement :

Correct Answer is : The Copy Database Wizard cannot be used to copy System databases

Similar Interview Questions

    Search for latest jobs

    Icon
    Icon