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
- How do we delete a login ?
- In which database state, the database is in single-user mode and may be repaired or restored.
- CREATE DATABASE has how many mandatory parameters?
- For every unique constraint on a column, SQL server will create
- Which operation, when performed on a database can throw an error
- What is the syntax for creating new login on the SQL sevrer?
- An index can be defined for a single column
- Why type of user is the default in sql server?
- When SQL server is installed, which of the following databases are created by default?
- Stored procedures are safe from SQL injection attacks
- Which of the following below are valid database states?
- Can we temporarily disable a login name?
- What is a MULTI_USER in sql server?
- What is the difference between adhoc queries from stored procedures?
- A candidate key cannot be regarded as a possible primary key