Syntax for creating database snapshot in SQL Server is _______________(a) DROP DATABASE [snapshottest];(b) DELETE DATABASE [snapshottest];(c) DROP Snapshot [snapshottest];(d) None of the mentionedThe question was asked at a job interview.The doubt is from Database Snapshots topic in division Enterprise Data Management of SQL Server

Syntax for creating database snapshot in SQL Server is _______________

1.	Syntax for creating database snapshot in SQL Server is _______________(a) DROP DATABASE [snapshottest];(b) DELETE DATABASE [snapshottest];(c) DROP Snapshot [snapshottest];(d) None of the mentionedThe question was asked at a job interview.The doubt is from Database Snapshots topic in division Enterprise Data Management of SQL Server
Answer» The correct ANSWER is (a) DROP DATABASE [snapshottest]; The best explanation: We drop the SNAPSHOT database LIKE any other database USING drop database command.

Discussion

No Comment Found

Related InterviewSolutions

Which of the following is a Windows Failover Cluster quorum mode?(a) Node Majority(b) No Majority: Read Only(c) File Read Majority(d) None of the mentionedI had been asked this question during an online exam.The query is from Clustering in portion Enterprise Data Management of SQL Server
Which of the following operation requires to run SQL Server Setup on the node?(a) Add(b) Remove(c) Update(d) All of the mentionedThis question was addressed to me in exam.This key question is from Clustering topic in section Enterprise Data Management of SQL Server
A Windows Failover Cluster can support up to _______ nodes.(a) 12(b) 14(c) 16(d) 18I had been asked this question in final exam.This interesting question is from Clustering in chapter Enterprise Data Management of SQL Server
Which of the following element is installed locally on each node of the FCI?(a) WSFC Resource Group(b) SQL Server Binaries(c) Network Name(d) StorageI have been asked this question in my homework.My question is taken from Clustering in portion Enterprise Data Management of SQL Server
Point out the wrong statement.(a) The System Configuration Checker will verify the system state of your computer before Setup continues(b) Microsoft Lync Server 2010 supports clustering for Microsoft SQL Server 2005 only(c) The System Configuration Checker will run one more set of rules to validate your computer configuration with the SQL Server features you have specified(d) None of the mentionedThe question was asked by my school teacher while I was bunking the class.My doubt stems from Clustering in division Enterprise Data Management of SQL Server
Benefits that SQL Server failover cluster instances provide ____________(a) Protection at the instance level through redundancy(b) Disaster recovery solution using a multi-subnet FCI(c) Zero reconfiguration of applications and clients during failovers(d) All of the mentionedI have been asked this question by my school teacher while I was bunking the class.The doubt is from Clustering topic in chapter Enterprise Data Management of SQL Server
The resources owned by WSFC node include ___________(a) Destination address(b) SQL Server Browser(c) One file share resource, if the FILESTREAM feature is installed(d) None of the mentionedI got this question in homework.My question is taken from Clustering in chapter Enterprise Data Management of SQL Server
Point out the correct statement.(a) The detailed component diagnostics makes it possible to configure a more flexible failover policy(b) The diagnostic information is stored to database(c) The detailed component diagnostics disables better troubleshooting of automatic failovers retroactively(d) All of the mentionedI have been asked this question by my school teacher while I was bunking the class.The above asked question is from Clustering topic in division Enterprise Data Management of SQL Server
Which of the following scenario prefers failover cluster instance over stand alone instance in SQL Server?(a) High Confidentiality(b) High Availability(c) High Integrity(d) None of the mentionedThe question was posed to me in class test.My doubt is from Clustering in section Enterprise Data Management of SQL Server
Which of the following is an upgrade step to database mirroring?(a) Switch to high performance (sync)(b) Perform a rolling upgrade(c) Switch back to high performance (sync)(d) None of the mentionedI had been asked this question in exam.This intriguing question comes from Database Mirroring topic in section Enterprise Data Management of SQL Server

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment