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

View solution

Q. Which is a new DDL statement?

View solution

Q. Which of the following adds MOVE TO clause?

View solution

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

View solution

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

View solution

Q. Which of the following statement modifies view index?

View solution

Q. When does most ALTER DATABASE statements fail?

View solution

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

View solution

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

View solution

Q. Point out the correct statement.

View solution

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

View solution

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

View solution

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

View solution

Q. Point out the wrong statement.

View solution

Q. View used for displaying current status of database is ___________

View solution

Q. Syntax for dropping a database snapshot named “Sushant” would be ____________

View solution

Q. Which of the following statement is used to create database snapshot?

View solution

Q. Which of the following statement removes sales and suppliers database?

View solution

Q. Which is the minimal permission that a user must have to drop the database?

View solution

Q. Point out the correct statement.

View solution