Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
Online Practice Test
>
SQL Server
« Previous
Next »
Which of the following statement is used to make sql server resize the database file to its smallest possible size?
Options
- DBCC SHRINKFILE
- DBCC SHRINKDB
- DBCC SQLPERF SHRINKDB
CORRECT ANSWER : DBCC SHRINKFILE
Discussion Board
DBCC SHRINKFILE
DBCC SHRINKFILE is used to make sql server resize the database file to its smallest possible size. This file shrinks the size of the specified data or log file for the current database, or empties a file by moving the data from the specified file to other files in the same filegroup, allowing the file to be removed from the database. You can shrink a file to a size that is less than the size specified when it was created. This resets the minimum file size to the new value.
Prajakta Pandit 03-6-2017 12:03 AM
geography
awsm
Munmun Das 06-19-2015 07:41 AM
excellant
excellant
gur 09-14-2014 10:55 PM
« Previous
Next »
Write your comments
*
*
Email must be in the form someone@domain.com
*
*
Enter the code shown above:
Please enter the code shown above
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
Related Content
SQL Server (40)
SQL Server (28)
SQL Server (25)
Data Warehousing (10)
Biztalk (15)
SQL Server DBA (15)
Database (30)
Database (28)
DBMS (20)
Advertisement
▲