What options did ALTER DATABASE statement add?(a) DATABASE SNAPSHOT syntax(b) ATTACH_REBUILD_LOG clause(c) DB_CHAINING option(d) READ_COMMITTED_SNAPSHOTI got this question by my college professor while I was bunking the class.The above asked question is from Data Definition Language topic in division Creating the Physical Database Schema of SQL Server

What options did ALTER DATABASE statement add?(a) DATABASE SNAPSHOT sy

1.	What options did ALTER DATABASE statement add?(a) DATABASE SNAPSHOT syntax(b) ATTACH_REBUILD_LOG clause(c) DB_CHAINING option(d) READ_COMMITTED_SNAPSHOTI got this question by my college professor while I was bunking the class.The above asked question is from Data Definition Language topic in division Creating the Physical Database Schema of SQL Server
Answer» RIGHT OPTION is (d) READ_COMMITTED_SNAPSHOT For explanation: ALTER DATABASE is used for INSTANT file initialization when adding or growing DATA files.

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