Question
a.
DBCC SHRINK
b.
SHRINKDATABASE
c.
DBCC SHRINKDATABASE
d.
DBCC SHRINKDB
Posted under Data Definition Language SQL Server
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Command used to shrink the size of the database is _____________
Similar Questions
Discover Related MCQs
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
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!
