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
