Which view is used for displaying current status of database?

Question

databases catalog view is used for displaying the present status of the system.

When a database is dropped the master database should be backed up?

Explanation: A database can be dropped regardless of its state: offline, read-only, suspect, and so on. 2. Which of the following database should be backed up regularly? Explanation: When a database is dropped, the master database should be backed up.

Which one of the following is a type of data definition language command?

CREATE, ALTER, DROP, and TRUNCATE are the most often used DDL in SQL queries.

Expert · Answer

Explanation: A database can be dropped regardless of its state: offline, read-only, suspect, and so on. 2. Which of the following database should be backed up regularly? Explanation: When a database is dropped, the master database should be backed up.

Expert · Answer

CREATE, ALTER, DROP, and TRUNCATE are the most often used DDL in SQL queries.

Which view is used for displaying current status of database?

When a database is dropped the master database should be backed up?

Which one of the following is a type of data definition language command?

Related Questions