adplus-dvertising
frame-decoration

Question

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

Posted under Data Definition Language SQL Server

Answer: (b).A database cannot be dropped regardless of its state

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Point out the wrong statement.
Add Comment

Similar Questions

Discover Related MCQs

Q. Which of the following database should be backed up regularly?

View solution

Q. The DROP DATABASE statement must run in ________ mode.

View solution

Q. Features provided by ALTER DATABASE statement do not include ____________

View solution

Q. Point out the correct statement.

View solution

Q. Command used to shrink the size of the database is _____________

View solution

Q. Maximum number of filegroups specified for each database is ___________

View solution

Q. When does most ALTER DATABASE statements fail?

View solution

Q. Which of the following statement modifies view index?

View solution

Q. Which of the following index options are added by the CREATE INDEX statement?

View solution

Q. Point out the wrong statement with respect to ALTER INDEX statement.

View solution

Q. Which of the following adds MOVE TO clause?

View solution

Q. Which is a new DDL statement?

View solution

Q. Which of the following creates a new Microsoft Windows or SQL Server login account?

View solution

Q. Statement used to remove a user from the current database is ____________

View solution

Q. Command used to modify the schema is __________

View solution

Q. Creation of new database role in the current database is made by __________

View solution

Q. Purpose of ALTER CERTIFICATE is __________

View solution

Q. DDL statements not used for Synonym is __________

View solution

Q. Which of the following statement drops the synonym?

View solution
View All MCQs on Data Definition Language

Suggested Topics

Are you eager to expand your knowledge beyond SQL Server? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Operating System

Dive deep into the core of computers with our Operating System MCQs. Learn about...

Systems Programming

Decode low-level programming with our Systems Programming MCQs. These questions delve...

Digital Communication

Master the basics of electronic communication with our Digital Communication MCQs....

Object Oriented Programming Using C++

Enhance your programming skills with our MCQs on Object Oriented Programming using...

Systems Analysis and Design Methods

Get familiar with the process of designing and improving business systems with our...

Computer Graphics

Step into the visual side of computing with our Computer Graphics MCQs. Cover topics...

R Programming

Unleash the power of statistical computing with our R Programming MCQs. Topics cover...

MS Office

Master the suite of productivity tools with our MS Office MCQs. From Word and Excel...

UNIX

Become proficient with the Unix operating system using our UNIX MCQs. Learn about...