MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 30 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Maximum number of filegroups specified for each database is ___________ |
| A. | 32, 667 |
| B. | 32, 777 |
| C. | 32, 766 |
| D. | 32, 767 |
| Answer» E. | |
| 2. |
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 |
| Answer» B. Database is in the STORING state | |
| 3. |
DDL statements not used for Synonym is __________ |
| A. | CREATE SYNONYM |
| B. | DROP SYNONYM |
| C. | ALTER SYNONYM |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 4. |
Which of the following statement drops the synonym? |
| A. | DELETE SYNONYM |
| B. | DROP SYNONYM |
| C. | REMOVE SYNONYM |
| D. | None of the mentioned |
| Answer» E. | |
| 5. |
Command used to modify the schema is __________ |
| A. | ALTER SCHEMA |
| B. | ALTER STRUCTURE |
| C. | ALTER VIEW |
| D. | DBCC SHRINKDB |
| Answer» B. ALTER STRUCTURE | |
| 6. |
Creation of new database role in the current database is made by __________ |
| A. | CREATE APPLICATION ROLE |
| B. | CREATE ROLE |
| C. | CREATE USER |
| D. | CREATE LOGIN |
| Answer» C. CREATE USER | |
| 7. |
Command used to shrink the size of the database is _____________ |
| A. | DBCC SHRINK |
| B. | SHRINKDATABASE |
| C. | DBCC SHRINKDATABASE |
| D. | DBCC SHRINKDB |
| Answer» D. DBCC SHRINKDB | |
| 8. |
Which of the following adds MOVE TO clause? |
| A. | DROP INDEX |
| B. | ALTER INDEX |
| C. | UPDATE INDEX |
| D. | CREATE INDEX |
| Answer» B. ALTER INDEX | |
| 9. |
Which of the following statement modifies view index? |
| A. | ALTER INDEX |
| B. | ALTER VIEW INDEX |
| C. | ALTER INDEX_VIEW |
| D. | None of the mentioned |
| Answer» B. ALTER VIEW INDEX | |
| 10. |
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 |
| Answer» C. DROP LOGIN | |
| 11. |
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 |
| Answer» B. DROP LOGIN | |
| 12. |
Which is a new DDL statement? |
| A. | DROP ROLES |
| B. | CREATE APPLICATION ROLE |
| C. | CREATE USERS |
| D. | None of the mentioned |
| Answer» C. CREATE USERS | |
| 13. |
Purpose of ALTER CERTIFICATE is __________ |
| A. | Adds a private key to a certificate |
| B. | Changes the public key of a certificate |
| C. | Removes the certificate from the database |
| D. | None of the mentioned |
| Answer» B. Changes the public key of a certificate | |
| 14. |
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 |
| Answer» E. | |
| 15. |
Which of the following index options are added by the CREATE INDEX statement? |
| A. | XML INDEX |
| B. | INCLUDED (column) |
| C. | PARTITION SCHEME |
| D. | ONLINE |
| Answer» E. | |
| 16. |
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 |
| Answer» B. Modifies file | |
| 17. |
The DROP DATABASE statement must run in ________ mode. |
| A. | Autocommit |
| B. | Commit |
| C. | Readcommit |
| D. | None of the mentioned |
| Answer» B. Commit | |
| 18. |
Which of the following database should be backed up regularly? |
| A. | Adventure Works |
| B. | Pub |
| C. | TEMPDB |
| D. | Master |
| Answer» E. | |
| 19. |
What options did ALTER DATABASE statement add? |
| A. | DATABASE SNAPSHOT syntax |
| B. | ATTACH_REBUILD_LOG clause |
| C. | DB_CHAINING option |
| D. | READ_COMMITTED_SNAPSHOT |
| Answer» E. | |
| 20. |
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 |
| Answer» B. DROP DATABASE SNAP Sushant | |
| 21. |
View used for displaying current status of database is ___________ |
| A. | system.databases |
| B. | current.databases |
| C. | sys.databases |
| D. | status.databases |
| Answer» D. status.databases | |
| 22. |
VIEW_USED_USED_FOR_DISPLAYING_CURRENT_STATUS_OF_DATABASE_IS_:?$ |
| A. | system.databases |
| B. | current.databases |
| C. | sys.databases |
| D. | status.databases |
| Answer» D. status.databases | |
| 23. |
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 |
| Answer» B. DROP DATABASE SNAP Sushant | |
| 24. |
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 |
| Answer» B. CREATE SNAPSHOT | |
| 25. |
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 |
| Answer» C. DROP DATABASE Sales and suppliers | |
| 26. |
Which is the minimal permission that a user must have to drop the database ? |
| A. | READ |
| B. | WRITE |
| C. | VIEW |
| D. | CONTROL |
| Answer» E. | |
| 27. |
Which of the following database cannot be dropped ? |
| A. | TEMPDB |
| B. | Master |
| C. | MSDB |
| D. | All of the mentioned |
| Answer» E. | |
| 28. |
Which of the following statement removes database including its related components ? |
| A. | DROP DATABASE |
| B. | DELETE DATABASE |
| C. | REMOVE DATABASE |
| D. | None of the mentioned |
| Answer» B. DELETE DATABASE | |
| 29. |
Which of the following item is provided by CREATE DATABASE statement ? |
| A. | Service Broker options |
| B. | ALLOW_SNAPSHOT_ISOLATION |
| C. | DB_CHAINING |
| D. | Database mirroring |
| Answer» B. ALLOW_SNAPSHOT_ISOLATION | |
| 30. |
What options did ALTER DATABASE statement add ? |
| A. | DATABASE SNAPSHOT syntax |
| B. | ATTACH_REBUILD_LOG clause |
| C. | DB_CHAINING option |
| D. | READ_COMMITTED_SNAPSHOT |
| Answer» E. | |