What can you do with the "ALTER DATABASE ..." T-

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What can you do with the "ALTER DATABASE ..." T-SQL command?

With the "ALTER DATABASE ..." T-SQL command, you can modify, expand or shrink a given database.

(Continued on next question...)

Other Job Interview Questions

• What is the meaning of the following T-SQL command: "GRANT CREATE TABLE TO <username>"
• What is the different between concurrent connections and concurrent user logins?
• What does Default Object refers to in MS SQL Server?
• What is "osql"? What can you do with "osql"?
• What is the fully qualified naming convention to specify a table in a linked Oracle database from MS SQL server?
• What should you do to prepare for MS SQL Server upgrade?
• What is the meaning of the following T-SQL command: DBCC SHRINKDATABASE ( Database, 10%)
• What is the meaning of the following T-SQL command: SELECT TOP 10 * FROM user WHERE last_name = 'Johnson'
• What is the size a Page in MS SQL Server?
• What is the size a Page in MS SQL Server?
• More...