SQL Server DBA IQ Test Quiz Instructions:
SQL Server DBA Quiz Test Questions and Options:
For every unique constraint on a column, SQL server will create:
A: clustered index for that column
B: index for that column
C: non-clustered index for that column
D: Does not create any index
An index can be defined for a single column.
What type of user is the default in sql server?
What is a MULTI_USER in sql server?
A: Only the system admin and some members are allowed to access the database.
B: Users that have the appropriate permissions to connect to the database are allowed.
C: Only some members are allowed to access the database.
D: One user at a time is allowed to connect to the database.
In which database state, the database is in single-user mode and may be repaired or restored?
The database could not be exclusively locked to perform the operation.
Which operation, when performed on a database can throw an error?
A: DELETE database
B: DROP database
C: DISABLE database
D: Rename database
How do we delete a login?
A: DELETE LOGIN login_name
B: DISABLE LOGIN login_name
C: A login cannot be deleted but only disabled
D: DROP LOGIN login_name
Can we temporarily disable a login name?
What is the syntax for creating new login on the SQL sevrer?
A: CREATE LOGIN login_id USE password
B: USE LOGIN login_id WITH PASSWORD password
C: CREATE LOGIN login_id WITH USE password
D: CREATE LOGIN login_id WITH PASSWORD password
When SQL server is installed, which of the following databases are created by default?
B: Master and Model
Stored procedures are safe from SQL injection attacks.
What is the difference between adhoc queries from stored procedures?
A: There is no difference as both are fired on the databases.
B: Stored procedures are placed embedded in the business logic code.
D: Adhoc queries are placed embedded in the business logic code.
A candidate key cannot be regarded as a possible primary key.
How many mandatory parameters a CREATE DATABASE has?
Which of the following are valid database states?
Recommended Other Related TopicsSQL Server Online Exams MCQs Quiz Test
Data Interpretation Database Online Exams MCQs Quiz Test
Window Server 2003 Online Exams MCQs Quiz Test
Data-mining Database Online Exams MCQs Quiz Test
Database Online Exams MCQs Quiz Test
My SQL Database Online Exams MCQs Quiz Test
PLSQL Database Online Exams MCQs Quiz Test
Data Warehousing Online Exams MCQs Quiz Test
DBMS Online Exams MCQs Quiz Test
Microsoft Access Online Exams MCQs Quiz Test