SQL Server Interview Questions - 9 | Snaprecruit.com
SQL Server Interview Questions - 9 | Snaprecruit.com
JOBSEEKERS
Login
Sign Up
Jobseeker
Employer
Staffing
Enterprises
SQL Server interview questions part 9
SQL Server interview questions part 9
Back
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. Which is the minimal permission that a user must have to drop the database ?
A. READ
B. WRITE
C. VIEW
D. CONTROL
Show Correct Answer
Correct Answer is :
CONTROL
2. Which of the following statement removes sales and suppliers database ?
A. DROP DATABASE Sales, NewSales
B. DROP DATABASE Sales, suppliers
C. DROP DATABASE Sales and suppliers
D. DROP DATABASE Sales-suppliers
Show Correct Answer
Correct Answer is :
DROP DATABASE Sales, suppliers
3. Which of the following statement is used to create database snapshot ?
A. CREATE DATABASE
B. CREATE SNAPSHOT
C. CREATE SNAPDB
D. None of the mentioned
Show Correct Answer
Correct Answer is :
CREATE DATABASE
4. Syntax for dropping a database snapshot named “Sushant” would be :
A. DROP DATABASE Sushant
B. DROP DATABASE SNAP Sushant
C. DROP SNAPSHOT Sushant
D. None of the mentioned
Show Correct Answer
Correct Answer is :
DROP DATABASE Sushant
5. View used used for displaying current status of database is :
A. system.databases
B. current.databases
C. sys.databases
D. status.databases
Show Correct Answer
Correct Answer is :
sys.databases
6. Point out the wrong statement :
A. You cannot drop a database currently being used
B. A database cannot be dropped regardless of its state
C. Any database snapshots on a database must be dropped before the database can be dropped
D. None of the mentioned
Show Correct Answer
Correct Answer is :
A database cannot be dropped regardless of its state
7. Which of the following database should be backed up regularly ?
A. Adventure Works
B. Pub
C. TEMPDB
D. Master
Show Correct Answer
Correct Answer is :
Master
8. The DROP DATABASE statement must run in ________ mode?
A. Autocommit
B. Commit
C. Readcommit
D. None of the mentioned
Show Correct Answer
Correct Answer is :
Autocommit
9. Features provided by ALTER DATABASE statement do not include :
A. Deletes database
B. Modifies file
C. Changes the attributes of a database
D. Changes the database collation
Show Correct Answer
Correct Answer is :
Deletes database
10. Point out the correct statement:
A. Database snapshots cannot be modified
B. Database snapshots can be modified
C. A collation name can be specified with the FOR ATTACH or FOR ATTACH_REBUILD_LOG clauses
D. None of the mentioned
Show Correct Answer
Correct Answer is :
Database snapshots cannot be modified
11. Command used to shrink the size of database is:
A. DBCC SHRINK
B. SHRINKDATABASE
C. DBCC SHRINKDATABASE
D. DBCC SHRINKDB
Show Correct Answer
Correct Answer is :
DBCC SHRINKDATABASE
12. Maximum number of filegroups specified for each database is :
A. 32, 667
B. 32, 777
C. 32, 766
D. 32, 767
Show Correct Answer
Correct Answer is :
32, 767
13. When does most ALTER DATABASE statements fail ?
A. Database is in the RESTORING state
B. Database is in the STORING state
C. Database is in the RESTORE state
D. None of the mentioned
Show Correct Answer
Correct Answer is :
Database is in the RESTORING state
14. Which of the following statement modifies view index ?
A. ALTER INDEX
B. ALTER VIEW INDEX
C. ALTER INDEX_VIEW
D. None of the mentioned
Show Correct Answer
Correct Answer is :
ALTER INDEX
15. Which of the following index options are added by CREATE INDEX statement ?
A. XML INDEX
B. INCLUDED (column)
C. PARTITION SCHEME
D. ONLINE
Show Correct Answer
Correct Answer is :
ONLINE
16. Point out the wrong statement with respect to ALTER INDEX statement :
A. Adds new format for specifying index and table names
B. Adds the index option:MAXDOP
C. Adds the index option:ONLINE
D. None of the mentioned
Show Correct Answer
Correct Answer is :
None of the mentioned
17. Which of the following adds MOVE TO clause ?
A. DROP INDEX
B. ALTER INDEX
C. UPDATE INDEX
D. CREATE INDEX
Show Correct Answer
Correct Answer is :
DROP INDEX
18. Which is a new DDL statement ?
A. DROP ROLES
B. CREATE APPLICATION ROLE
C. CREATE USERS
D. None of the mentioned
Show Correct Answer
Correct Answer is :
CREATE APPLICATION ROLE
19. Which of the following creates a new Microsoft Windows or SQL Server login account ?
A. CREATE LOGIN
B. DROP LOGIN
C. UPDATE LOGIN
D. REMOVE LOGIN
Show Correct Answer
Correct Answer is :
CREATE LOGIN
20. Statement used to remove a user from the current database is :
A. DROP ROLE
B. DROP USER
C. DROP LOGIN
D. None of the mentioned
Show Correct Answer
Correct Answer is :
DROP USER
Similar Interview Questions
Search for latest jobs
Find Jobs