SQL MCQ Quiz Hub

1. How do we delete a login?
DELETE LOGIN login_name
DROP LOGIN login_name
Login cannot be deleted but only disabled
DISABLE LOGIN login_name

2. In which database state, the database is in single-user mode and may be repaired or restored.
OFFLINE
SUSPECT
EMERGENCY
All of the above

3. CREATE DATABASE has how many mandatory parameters?
1
2
3
None of These

4. For every unique constraint on a column, SQL server will create
Does not create an index
clustered index for that column
index for that column
non-clustered index for that column

5. Which operation, when performed on a database can throw an error
The database could not be exclusively locked to perform the operation”
DELETE database
DROP database
Rename database

6. What is the syntax for creating a new login on the SQL server?
USE LOGIN login_id WITH PASSWORD password
CREATE LOGIN login_id WITH USE password
CREATE LOGIN login_id USE password
CREATE LOGIN login_id WITH PASSWORD password

7. Why type of user is the default in SQL server?
SINGLE_USER
MULTI_USER
RESTRICTED_USER
ROOT_USER

8. When SQL server is installed, which of the following databases are created by default?
Master
Model
Both a and b
Root

9. Which of the following below are valid database states?
OFFLINE
SUSPECT
EMERGENCY
All of the above

10. What is a MULTI_USER in SQL server?
users that have the appropriate permissions to connect to the database are allowed
One user at a time is allowed to connect to the database
Only some members are allowed to access the database
Only the system admin and some members are allowed to access the database

11. What is the difference between ad-hoc queries from stored procedures?
Ad-hoc queries are placed embedded in the business logic code
Stored procedures are placed embedded in the business logic code
There is no difference as both are fired on the databases
None of above