Which of the following statement is used for changing Recovery Model with T-SQL?(a) ALTER DATABASE(b) ALTER TABLE(c) ALTER COLUMN(d) None of the mentionedThis question was addressed to me in an interview for job.This intriguing question originated from Recovery in chapter Enterprise Data Management of SQL Server

Which of the following statement is used for changing Recovery Model w

1.	Which of the following statement is used for changing Recovery Model with T-SQL?(a) ALTER DATABASE(b) ALTER TABLE(c) ALTER COLUMN(d) None of the mentionedThis question was addressed to me in an interview for job.This intriguing question originated from Recovery in chapter Enterprise Data Management of SQL Server
Answer» Correct answer is (a) ALTER DATABASE Explanation: You can use ALTER DATABASE command with the SET RECOVERY option to CHANGE the recovery MODEL of a database.

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