Point out the correct statement.(a) When a database is dropped, the master database should be backed up(b) You can drop a database currently being used(c) Dropping a database snapshot does not delete the database snapshot from an instance of SQL Server(d) None of the mentionedI got this question during an interview for a job.This intriguing question originated from Data Definition Language in chapter Creating the Physical Database Schema of SQL Server

Point out the correct statement.(a) When a database is dropped, the ma

1.	Point out the correct statement.(a) When a database is dropped, the master database should be backed up(b) You can drop a database currently being used(c) Dropping a database snapshot does not delete the database snapshot from an instance of SQL Server(d) None of the mentionedI got this question during an interview for a job.This intriguing question originated from Data Definition Language in chapter Creating the Physical Database Schema of SQL Server
Answer» The correct answer is (a) When a DATABASE is dropped, the MASTER database should be backed up Explanation: Master database records all of the system LEVEL INFORMATION for a SQL Server.

Discussion

No Comment Found

Related InterviewSolutions

Which of the following statement drops the synonym?(a) DELETE SYNONYM(b) DROP SYNONYM(c) REMOVE SYNONYM(d) None of the mentionedThis question was posed to me during an interview.Enquiry is from Data Definition Language topic in portion Creating the Physical Database Schema of SQL Server
DDL statements not used for Synonym is __________(a) CREATE SYNONYM(b) DROP SYNONYM(c) ALTER SYNONYM(d) None of the mentionedI have been asked this question in a national level competition.This key question is from Data Definition Language topic in section Creating the Physical Database Schema of SQL Server
Purpose of ALTER CERTIFICATE is __________(a) Adds a private key to a certificate(b) Changes the public key of a certificate(c) Removes the certificate from the database(d) None of the mentionedI have been asked this question in semester exam.The doubt is from Data Definition Language topic in chapter Creating the Physical Database Schema of SQL Server
Command used to modify the schema is __________(a) ALTER SCHEMA(b) ALTER STRUCTURE(c) ALTER VIEW(d) DBCC SHRINKDBI had been asked this question in an international level competition.My question is from Data Definition Language in chapter Creating the Physical Database Schema of SQL Server
Creation ofnew database role in the current database is made by __________(a) CREATE APPLICATION ROLE(b) CREATE ROLE(c) CREATE USER(d) CREATE LOGINThe question was posed to me in an interview for job.My query is from Data Definition Language topic in chapter Creating the Physical Database Schema of SQL Server
Statement used to remove a user from the current database is ____________(a) DROP ROLE(b) DROP USER(c) DROP LOGIN(d) None of the mentionedI got this question in examination.Query is from Data Definition Language in chapter Creating the Physical Database Schema of SQL Server
Which of the following creates a new Microsoft Windows or SQL Server login account?(a) CREATE LOGIN(b) DROP LOGIN(c) UPDATE LOGIN(d) REMOVE LOGINI got this question in homework.This question is from Data Definition Language in section Creating the Physical Database Schema of SQL Server
Which is a new DDL statement?(a) DROP ROLES(b) CREATE APPLICATION ROLE(c) CREATE USERS(d) None of the mentionedThis question was posed to me by my college professor while I was bunking the class.I would like to ask this question from Data Definition Language in division Creating the Physical Database Schema of SQL Server
Which of the following adds MOVE TO clause?(a) DROP INDEX(b) ALTER INDEX(c) UPDATE INDEX(d) CREATE INDEXThe question was posed to me by my college professor while I was bunking the class.Origin of the question is Data Definition Language in chapter Creating the Physical Database Schema of SQL Server
Which of the following statement modifies view index?(a) ALTER INDEX(b) ALTER VIEW INDEX(c) ALTER INDEX_VIEW(d) None of the mentionedI had been asked this question during an interview.Query is from Data Definition Language topic in division Creating the Physical Database Schema of SQL Server

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment