15 TOP SQL Server DBA Multiple Choice Questions and Answers

List of top 15 most frequently asked SQL Server DBA multiple choice questions and answers pdf download free

SQL Server DBA Multiple Choice Questions and Answers List

  1. How do we delete a login ?
  2. In which database state, the database is in single-user mode and may be repaired or restored.
  3. CREATE DATABASE has how many mandatory parameters?
  4. For every unique constraint on a column, SQL server will create
  5. Which operation, when performed on a database can throw an error
  6. What is the syntax for creating new login on the SQL sevrer?
  7. An index can be defined for a single column
  8. Why type of user is the default in sql server?
  9. When SQL server is installed, which of the following databases are created by default?
  10. Stored procedures are safe from SQL injection attacks
  11. Which of the following below are valid database states?
  12. Can we temporarily disable a login name?
  13. What is a MULTI_USER in sql server?
  14. What is the difference between adhoc queries from stored procedures?
  15. A candidate key cannot be regarded as a possible primary key
This entry was posted in SQL Server DBA MCQs. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *