InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
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 |
|
Answer» The correct choice is (a) Node Majority |
|
| 2. |
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 |
|
Answer» Right answer is (d) All of the mentioned |
|
| 3. |
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 |
|
Answer» The correct answer is (c) 16 |
|
| 4. |
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 |
|
Answer» The correct OPTION is (b) SQL Server Binaries |
|
| 5. |
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 |
|
Answer» Correct ANSWER is (b) MICROSOFT LYNC Server 2010 supports clustering for Microsoft SQL Server 2005 only |
|
| 6. |
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 |
|
Answer» RIGHT choice is (d) All of the mentioned To explain I WOULD SAY: You can even run an FCI-hosted database inside an AlwaysOn availability group. |
|
| 7. |
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 |
|
Answer» The correct choice is (c) One file SHARE resource, if the FILESTREAM feature is INSTALLED |
|
| 8. |
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 |
|
Answer» The CORRECT option is (a) The detailed COMPONENT diagnostics makes it possible to configure a more flexible failover policy |
|
| 9. |
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 |
|
Answer» Right answer is (b) HIGH AVAILABILITY |
|
| 10. |
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 |
|
Answer» The correct answer is (b) Perform a rolling UPGRADE |
|
| 11. |
Point out the wrong statement.(a) Mirror database is the copy of the database that is typically fully synchronized with the principal database(b) Redo queue is received transaction log records that are waiting on the disk of a mirror server(c) Database mirroring provides less redundancy of the data(d) All of the mentionedI had been asked this question in my homework.Enquiry is from Database Mirroring in section Enterprise Data Management of SQL Server |
|
Answer» Right choice is (c) Database mirroring PROVIDES less redundancy of the DATA |
|
| 12. |
Database mirroring operates in how many modes?(a) 2(b) 3(c) 4(d) 5The question was asked during a job interview.This interesting question is from Database Mirroring topic in portion Enterprise Data Management of SQL Server |
|
Answer» CORRECT choice is (B) 3 The best explanation: Database MIRRORING operates in three different modes: high-availability mode, high-protection mode, and high-performance mode. |
|
| 13. |
Which of the following benefit is provided by database mirroring?(a) Increases data protection(b) Improves the availability of the production database(c) Increases availability of a database(d) All of the mentionedThe question was posed to me in an interview for internship.This key question is from Database Mirroring in section Enterprise Data Management of SQL Server |
|
Answer» Correct option is (d) All of the mentioned |
|
| 14. |
___________ feature will be removed in a future version of Microsoft SQL Server.(a) Log shipping(b) Database snapshots(c) Database mirroring(d) None of the mentionedThis question was posed to me in an online interview.This intriguing question comes from Database Mirroring topic in chapter Enterprise Data Management of SQL Server |
|
Answer» The correct option is (c) Database mirroring |
|
| 15. |
Point out the correct statement.(a) Database mirroring is a solution for lowering the availability of a SQL Server database(b) Log shipping is a solution for increasing the availability of a SQL Server database(c) Mirroring is implemented on a per-database basis(d) All of the mentionedThe question was posed to me in an interview for job.Question is from Database Mirroring topic in chapter Enterprise Data Management of SQL Server |
|
Answer» The CORRECT CHOICE is (c) Mirroring is implemented on a per-database basis |
|
| 16. |
Which of the following table stores history detail for log shipping jobs?(a) log_shipping_monitor_alert(b) log_shipping_monitor_primary(c) log_shipping_monitor_history_detail(d) none of the mentionedI have been asked this question in a job interview.My question is from Log Shipping topic in division Enterprise Data Management of SQL Server |
|
Answer» CORRECT choice is (c) log_shipping_monitor_history_detail To explain I WOULD SAY: log_shipping_monitor_alert STORES ALERT job ID. |
|
| 17. |
Point out the wrong statement.(a) The principal database in a mirroring session can also act as the primary database in a log shipping(b) Log Shipping is comparatively tougher than database mirroring for setup(c) The database log shipping setup needs to be initiated from the principal server using the SQL Server Management Studio wizard(d) A given database can be mirrored or log shipped; it can also be simultaneously mirrored and log shippedThis question was addressed to me during an interview.Asked question is from Log Shipping topic in section Enterprise Data Management of SQL Server |
|
Answer» Correct choice is (b) LOG Shipping is comparatively tougher than database MIRRORING for setup |
|
| 18. |
Which of the following is the instance of SQL Server that is your production server in log shipping?(a) secondary database(b) primary database(c) secondary server(d) primary serverThe question was asked during an internship interview.The doubt is from Log Shipping topic in portion Enterprise Data Management of SQL Server |
|
Answer» CORRECT option is (d) PRIMARY server The explanation is: Once the monitor server has been configured, it cannot be changed without removing log SHIPPING first. |
|
| 19. |
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]; |
|
| 20. |
Point out the correct statement.(a) After a database has been upgraded, it cannot be downgraded to a previous version(b) The Copy Database Wizard is available in the Express edition(c) The Copy Database Wizard cannot be used to copySystem databases(d) None of the mentionedThis question was posed to me in semester exam.This key question is from Transferring Database in portion Enterprise Data Management of SQL Server |
|
Answer» Right choice is (C) The Copy Database Wizard cannot be used to COPYSYSTEM DATABASES |
|
| 21. |
Which of the following wizard provides creation logins on the destination server?(a) Copy Database(b) Move Database(c) Detach database(d) Attach databaseI have been asked this question in unit test.My question is from Transferring Database topic in portion Enterprise Data Management of SQL Server |
|
Answer» RIGHT choice is (a) COPY Database Explanation: The Copy Database Wizard lets you MOVE or copy databases and their objects EASILY from one server to another. |
|
| 22. |
Which of the following members has access to SQL Server Agent?(a) members of the systemadmin(b) members of the sysadmin(c) members of the sysadministraion(d) none of the mentionedI got this question in final exam.My doubt is from SQL Server Agent topic in section Enterprise Data Management of SQL Server |
|
Answer» Correct answer is (b) members of the SYSADMIN |
|
| 23. |
SQL Server can notify operators of alerts through ____________(a) E-mail(b) Net send(c) Pager(d) All of the mentionedI got this question in my homework.This interesting question is from SQL Server Agent in division Enterprise Data Management of SQL Server |
|
Answer» Right OPTION is (d) All of the mentioned |
|
| 24. |
An alert can respond to one of the following conditions?(a) Whenever SQL Server Agent starts(b) On a recurring schedule(c) SQL Server performance conditions(d) All of the mentionedThis question was addressed to me by my school teacher while I was bunking the class.This intriguing question comes from SQL Server Agent topic in chapter Enterprise Data Management of SQL Server |
|
Answer» The correct answer is (c) SQL Server PERFORMANCE conditions |
|
| 25. |
Which of the following condition is considered for schedule?(a) Whenever SQL Server Agent starts(b) On a recurring schedule(c) SQL Server performance conditions(d) All of the mentionedThe question was posed to me in an internship interview.I'd like to ask this question from SQL Server Agent in portion Enterprise Data Management of SQL Server |
|
Answer» Right ANSWER is (d) All of the mentioned |
|
| 26. |
_________start and stop the SQL Server Agent Service .(a) SSMS(b) Windows Services console(c) QL Server Service Manager(d) All of the mentionedThe question was asked in quiz.This intriguing question originated from SQL Server Agent topic in division Enterprise Data Management of SQL Server |
|
Answer» Right choice is (d) All of the mentioned |
|
| 27. |
SQL Agent Job definitions are specified in which database?(a) msdb(b) master(c) tempdb(d) all of the mentionedThe question was asked in unit test.This intriguing question originated from SQL Server Agent in portion Enterprise Data Management of SQL Server |
|
Answer» The correct CHOICE is (a) msdb |
|
| 28. |
Point out the wrong statement.(a) SQL Server Log shipping allows you to automate a variety of administrative task(b) SQL Server task manager allows you to automate a variety of administrative task(c) SQL Server Agent allows you to automate a variety of administrative task(d) All of the mentionedThis question was posed to me in class test.This key question is from SQL Server Agent in division Enterprise Data Management of SQL Server |
|
Answer» Right choice is (C) SQL SERVER Agent allows you to automate a variety of administrative task |
|
| 29. |
SQL Server Agent consist of _____ component.(a) 2(b) 3(c) 4(d) 5I got this question by my college director while I was bunking the class.I would like to ask this question from SQL Server Agent in portion Enterprise Data Management of SQL Server |
|
Answer» Correct ANSWER is (b) 3 |
|
| 30. |
Create a Database Maintenance Plan that creates a ________ backup within SQL Server.(a) Partial(b) Snapshot(c) Full(d) None of the mentionedThe question was asked in an online quiz.My question is based upon Database Maintenance topic in division Enterprise Data Management of SQL Server |
|
Answer» Correct ANSWER is (C) Full |
|
| 31. |
What types of database maintenance should be executed?(a) Update SQL Server’s usage(b) Validate the database objects and system catalogs are free of corruption(c) Determine the fragmentation for tables and indexes(d) All of the mentionedThe question was asked in an international level competition.My enquiry is from Database Maintenance topic in portion Enterprise Data Management of SQL Server |
|
Answer» Correct OPTION is (d) All of the mentioned |
|
| 32. |
__________ is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs in SQL Server 2014.(a) Log shipping(b) Task(c) Agent(d) None of the mentionedThis question was posed to me in homework.The doubt is from SQL Server Agent in portion Enterprise Data Management of SQL Server |
|
Answer» Right OPTION is (c) Agent |
|
| 33. |
Point out the correct statement.(a) SQL Server Agent uses SQL Server to store job information(b) SQL Server Agent can run a job on a schedule(c) By default, the SQL Server Agent service is disabled when SQL Server 2014 is installed(d) All of the mentionedThe question was asked in an online quiz.This interesting question is from SQL Server Agent in section Enterprise Data Management of SQL Server |
|
Answer» CORRECT answer is (d) All of the mentioned Explanation: SQL Server Agent runs CONTINUOUSLY in the background as a WINDOWS SERVICE. |
|
| 34. |
Which of the following command defragments clustered and secondary indexes of the specified table?(a) DBCC SHOWCONTIG(b) DBCC CHECKDB(c) DBCC CATALOG(d) DBCC INDEXDEFRAGThis question was posed to me in semester exam.Query is from Database Maintenance in division Enterprise Data Management of SQL Server |
|
Answer» CORRECT OPTION is (d) DBCC INDEXDEFRAG To explain I would say: DBCC INDEXDEFRAG is an online operation, so it does not HOLD long-term locks that can block running queries or UPDATES. |
|
| 35. |
______________ runs UPDATE STATISTICS against all user-defined tables in the current database.(a) sp_updatestats(b) DBCC CHECKDB(c) DBCC CATALOG(d) DBCC INDEXDEFRAGI got this question in homework.My question is based upon Database Maintenance topic in section Enterprise Data Management of SQL Server |
|
Answer» Correct option is (a) sp_updatestats |
|
| 36. |
Purpose of DBCC DBREINDEX command is to ____________(a) Rebuilds one or more indexes for a table in the specified database(b) Rebuilds only one index for a table in the specified database(c) Displays fragmentation information for the data and indexes of the specified table(d) All of the mentionedI have been asked this question in exam.My question comes from Database Maintenance topic in section Enterprise Data Management of SQL Server |
|
Answer» RIGHT answer is (a) Rebuilds one or more indexes for a table in the SPECIFIED database Easy explanation: The DBCC DBREINDEX command will not AUTOMATICALLY rebuild all of the indexes on all the tables in a database; it can only WORK on one table at a time. |
|
| 37. |
Point out the wrong statement.(a) The command DBCC CHECKDB checks the logical and physical integrity of all the objects in the specified database(b) The command DBCC CHECK checks the logical and physical integrity of all the objects in the specified database(c) The command CHECKDB checks the logical and physical integrity of all the objects in the specified database(d) None of the mentionedThe question was posed to me in homework.The above asked question is from Database Maintenance topic in portion Enterprise Data Management of SQL Server |
|
Answer» Right OPTION is (a) The command DBCC CHECKDB checks the logical and PHYSICAL integrity of all the objects in the SPECIFIED database |
|
| 38. |
Which of the following is used to Validate the database objects?(a) DBCC SHOWCONTIG(b) DBCC CHECKDB(c) DBCC CATALOG(d) None of the mentionedThe question was asked in an interview.My query is from Database Maintenance in chapter Enterprise Data Management of SQL Server |
|
Answer» Right ANSWER is (b) DBCC CHECKDB |
|
| 39. |
Which of the following is used to determine the fragmentation for tables and indexes?(a) DBCC SHOWCONTIG(b) DBCC CHECKDB(c) DBCC CHECKCATALOG(d) None of the mentionedThis question was addressed to me by my school teacher while I was bunking the class.I'd like to ask this question from Database Maintenance in chapter Enterprise Data Management of SQL Server |
|
Answer» Right CHOICE is (a) DBCC SHOWCONTIG |
|
| 40. |
Point out the correct statement related to database maintenance.(a) Performing SQL Server Maintenance with Maintenance Window(b) Performing SQL Server Maintenance with No Maintenance Window(c) Performing SQL Server Maintenance with Scrip Maintenance Window(d) None of the mentionedThe question was asked by my school principal while I was bunking the class.My question is based upon Database Maintenance in division Enterprise Data Management of SQL Server |
|
Answer» Right ANSWER is (b) PERFORMING SQL Server Maintenance with No Maintenance WINDOW |
|
| 41. |
The SQL Server Maintenance Solution comprises scripts for running __________ maintenance on all editions of Microsoft SQL Server.(a) backups(b) integrity checks(c) index(d) all of the mentionedThe question was posed to me in exam.My doubt is from Database Maintenance in portion Enterprise Data Management of SQL Server |
|
Answer» Correct choice is (d) all of the mentioned |
|
| 42. |
_________ backups represent the whole database at the time the backup finished.(a) copy-only backup(b) database backup(c) data backup(d) all of the mentionedI have been asked this question during an interview for a job.The question is from Backup in section Enterprise Data Management of SQL Server |
|
Answer» Right option is (B) DATABASE backup |
|
| 43. |
____________ contains data from only some of the filegroups in a database.(a) copy-only backup(b) database backup(c) data backup(d) partialThe question was asked in unit test.My question is from Backup in section Enterprise Data Management of SQL Server |
|
Answer» Correct answer is (d) partial |
|
| 44. |
Which of the following is not a type of backup?(a) database backup(b) data backup(c) table backup(d) all of the mentionedThe question was asked in an international level competition.My question is taken from Backup in portion Enterprise Data Management of SQL Server |
|
Answer» CORRECT CHOICE is (c) table backup Easiest explanation: In order to SELECT a proper SQL Server backup type, a SQL Server administrator needs to understand the DIFFERENCE between the MAJOR backup. |
|
| 45. |
Which of the following backups contain transaction logs?(a) copy-only backup(b) database backup(c) data backup(d) none of the mentionedI had been asked this question at a job interview.This is a very interesting question from Backup topic in chapter Enterprise Data Management of SQL Server |
|
Answer» The correct CHOICE is (d) none of the mentioned |
|
| 46. |
Backup can occur while the database is in ___________ state.(a) Online(b) Offline(c) Restoring(d) All of the mentionedI had been asked this question during an online interview.My question comes from Backup topic in division Enterprise Data Management of SQL Server |
|
Answer» Correct ANSWER is (a) Online |
|
| 47. |
Point out the wrong statement.(a) SQL Server 2003 Enterprise and later versions support compressing backups(b) SQL Server 2008 Enterprise and later versions support compressing backups(c) SQL Server 2000 Enterprise and later versions support compressing backups(d) All of the mentionedI got this question in an online quiz.My doubt stems from Backup topic in portion Enterprise Data Management of SQL Server |
|
Answer» Right answer is (b) SQL Server 2008 Enterprise and LATER versions support compressing backups |
|
| 48. |
How many types of backups are provided by SQL Server?(a) 5(b) 6(c) 7(d) 8The question was asked in examination.This question is from Backup topic in section Enterprise Data Management of SQL Server |
|
Answer» The correct option is (d) 8 |
|
| 49. |
Point out the correct statement.(a) Using differential backups can save available space(b) Using full backups can save available space(c) Using partial backups can save available space(d) None of the mentionedI got this question during a job interview.My doubt is from Backup topic in portion Enterprise Data Management of SQL Server |
|
Answer» Right answer is (a) Using DIFFERENTIAL backups can save AVAILABLE space |
|
| 50. |
Features provided by SQL Server backups include ________________(a) Wire compression of data for optimal backup and restore time(b) Supports full and transaction log style backups(c) Backup of MS SQL Server databases without interrupting running MS SQL Server services(d) All of the mentionedI had been asked this question in semester exam.The question is from Backup in section Enterprise Data Management of SQL Server |
|
Answer» The correct option is (d) All of the mentioned |
|