MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 424 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 201. |
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 mentioned |
| Answer» B. No Majority: Read Only | |
| 202. |
Which of the following pair of technology is supported in SQL Server ? |
| A. | Mirroring and Replication |
| B. | Mirroring and Clustering |
| C. | Mirroring and Log Shipping |
| D. | All of the mentioned |
| Answer» E. | |
| 203. |
Which of the following is 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 mentioned |
| Answer» C. Switch back to high performance (sync) | |
| 204. |
_________ maps primary databases to secondary databases in log shipping. |
| A. | sp_change_log_shipping_primary_database |
| B. | log_shipping_primary_databases |
| C. | log_shipping_primary_secondaries |
| D. | sp_help_log_shipping_primary_database |
| Answer» D. sp_help_log_shipping_primary_database | |
| 205. |
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 mentioned |
| Answer» D. None of the mentioned | |
| 206. |
_____ 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 mentioned |
| Answer» D. None of the mentioned | |
| 207. |
Execute sp_add_jobschedule to add a schedule for the backup job on _________ server |
| A. | primary |
| B. | secondary |
| C. | primary and secondary |
| D. | None of the mentioned |
| Answer» B. secondary | |
| 208. |
Which of the following stored procedure is used to add a primary database on primary server ? |
| A. | sp_add_log_shipping_primary_database |
| B. | sp_add_primary_database |
| C. | sp_add_log_shipping |
| D. | sp_add_log_shipping_primary |
| Answer» B. sp_add_primary_database | |
| 209. |
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 mentioned |
| Answer» B. DELETE DATABASE [snapshottest]; | |
| 210. |
What should be done to check to see if data still exists in Snapshot ? |
| A. | Run Delete on Database Snapshot |
| B. | Run Update on Database Snapshot |
| C. | Run Update on Database Snapshot |
| D. | Run Insert on Database Snapshot |
| Answer» D. Run Insert on Database Snapshot | |
| 211. |
Which of the following message comes when you try to update or delete the data snapshot? |
| A. | Row Deletion |
| B. | The row was committed |
| C. | Row has been updated |
| D. | Failed to update the database |
| Answer» D. Failed to update the database | |
| 212. |
To revert the database, use the following Transact-SQL statement: |
| A. | RESTORE Snapshot FROM DATABASE_SNAPSHOT = |
| B. | RESTORE DATABASE FROM DATABASE_SNAPSHOT = |
| C. | REST DATABASE FROM DATABASE_SNAPSHOT = |
| D. | None of the mentioned |
| Answer» C. REST DATABASE FROM DATABASE_SNAPSHOT = | |
| 213. |
How many ways are provided by SQL Server to copy a database ? |
| A. | 2 |
| B. | 3 |
| C. | 4 |
| D. | 5 |
| Answer» C. 4 | |
| 214. |
All of the mentioned |
| A. | members of the systemadmin |
| B. | members of the sysadmin |
| C. | members of the sysadministraion |
| D. | None of the mentioned |
| Answer» C. members of the sysadministraion | |
| 215. |
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 mentioned |
| Answer» D. All of the mentioned | |
| 216. |
SQL Server can notify operators of alerts through : |
| A. | |
| B. | Net send |
| C. | Pager |
| D. | All of the mentioned |
| Answer» E. | |
| 217. |
________start and stop the SQL Server Agent Service . |
| A. | SSMS |
| B. | Windows Services console |
| C. | QL Server Service Manager |
| D. | All of the mentioned |
| Answer» E. | |
| 218. |
________ 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 mentioned |
| Answer» D. None of the mentioned | |
| 219. |
Create a Database Maintenance Plan that creates a ________ backup within SQL Server. |
| A. | Partial |
| B. | Snapshot |
| C. | Full |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 220. |
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 mentioned |
| Answer» E. | |
| 221. |
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 mentioned |
| Answer» B. Rebuilds only one index for a table in the specified database | |
| 222. |
____________ runs UPDATE STATISTICS against all user-defined tables in the current database. |
| A. | sp_updatestats |
| B. | DBCC CHECKDB |
| C. | DBCC CATALOG |
| D. | DBCC INDEXDEFRAG |
| Answer» B. DBCC CHECKDB | |
| 223. |
___________ contains data from only some of the filegroups in a database. |
| A. | copy-only backup |
| B. | database backup |
| C. | data backup |
| D. | partial |
| Answer» E. | |
| 224. |
______ 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 mentioned |
| Answer» C. data backup | |
| 225. |
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 mentioned |
| Answer» B. ALTER TABLE | |
| 226. |
The _______ recovery model is a special-purpose model that works in a similar manner to the full recovery model. |
| A. | Simple |
| B. | Full |
| C. | bulk-logged |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 227. |
How many type of backups you can run when the data is in the “Full” recovery model ? |
| A. | 5 |
| B. | 6 |
| C. | 7 |
| D. | All of the mentioned |
| Answer» C. 7 | |
| 228. |
Purpose of syspolicy_system_health_state in policy based management is : |
| A. | Displays one row for each Policy-Based Management policy |
| B. | Organize policies when you have many policies |
| C. | Displays the time when policies were executed, the result of each execution, and details about errors if any occurred |
| D. | None of the mentioned |
| Answer» B. Organize policies when you have many policies | |
| 229. |
________ displays the condition expressions that were executed, |
| A. | syspolicy_policy_execution |
| B. | syspolicy_policy_execution_history_details |
| C. | syspolicy_policy_execution_history |
| D. | syspolicy_policy_group_subscriptions |
| Answer» C. syspolicy_policy_execution_history | |
| 230. |
Creation of a Derived Hierarchy requires permission to |
| A. | System Administration |
| B. | DQS |
| C. | syschema |
| D. | None of the mentioned |
| Answer» B. DQS | |
| 231. |
Users need _________ permission to create collection model object in MDS. |
| A. | Delete |
| B. | Create |
| C. | Update |
| D. | Read |
| Answer» D. Read | |
| 232. |
_______ shows information about Access databases that have been added to the project. |
| A. | SQL Server Metadata Explorer |
| B. | Access Metadata Explorer |
| C. | Access Metadata Expl |
| D. | None of the mentioned |
| Answer» C. Access Metadata Expl | |
| 233. |
Which of the following network protocol should be selected to enable IP address ? |
| A. | Udp |
| B. | Named pipes |
| C. | Tcp |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 234. |
________ is a tool for migrating databases from Microsoft Access versions 97 through 2010 to Microsoft SQL Server 2005 |
| A. | SSAM |
| B. | SSMA |
| C. | SSMS |
| D. | SSAS |
| Answer» C. SSMS | |
| 235. |
Which of the following evaluation operation is provided in SSIS ? |
| A. | A constraint that uses only the execution result of the precedence executable to determine whether the constrained executable runs |
| B. | An expression that is evaluated to determine whether the constrained executable runs |
| C. | An expression and a constraint that combines the requirements of execution results of the precedence executable |
| D. | All of the mentioned |
| Answer» E. | |
| 236. |
A basic package in SSIS includes the following elements |
| A. | T-SQL flow elements |
| B. | Control flow elements |
| C. | DataSet flow statements |
| D. | None of the mentioned |
| Answer» C. DataSet flow statements | |
| 237. |
Purpose of SQLISPackage_12546 event in SQLIS package is to : |
| A. | Indicate that a package started |
| B. | Indicate that a task or other executable in a package has finished its work |
| C. | Indicate that a warning message was raised in a package |
| D. | All of the mentioned |
| Answer» C. Indicate that a warning message was raised in a package | |
| 238. |
To increase this Rows / sec calculation in SSIS, you can do the following: |
| A. | Improve drivers and driver configurations |
| B. | Start single connections |
| C. | Use single NIC cards |
| D. | None of the mentioned |
| Answer» B. Start single connections | |
| 239. |
_________ represents how many network transfers per second are occurring. |
| A. | Network Bytes |
| B. | Network Transfers |
| C. | Memory reads |
| D. | None of the mentioned |
| Answer» C. Memory reads | |
| 240. |
________ represents to total memory pressure on the system in SSIS. |
| A. | Page sec |
| B. | Page Reads |
| C. | Memory reads |
| D. | All of the mentioned |
| Answer» E. | |
| 241. |
The following Network perfmon counters can help you tune your topology : |
| A. | Total Bandwidth |
| B. | Current Bandwidth |
| C. | Bandwidth bound |
| D. | All of the mentioned |
| Answer» C. Bandwidth bound | |
| 242. |
Which of the following makes data available for replication? |
| A. | Article |
| B. | Publisher |
| C. | Distributor |
| D. | Subscription |
| Answer» C. Distributor | |
| 243. |
Two types of subscriptions present for replication is : |
| A. | push and pull |
| B. | throw and pull |
| C. | push and throw |
| D. | none of the mentioned |
| Answer» B. throw and pull | |
| 244. |
Which of the utility is used for reporting issue in Service Broker ? |
| A. | diagnose |
| B. | ssiagnose |
| C. | ssbdiagnose |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 245. |
_______ is a set of technologies for copying and distributing data and database objects from one database to another. |
| A. | Replication |
| B. | Database Mirroring |
| C. | Log Shipping |
| D. | None of the mentioned |
| Answer» B. Database Mirroring | |
| 246. |
Which of the following is a Service Broker Related Dynamic Management View ? |
| A. | sys.dm_broker_activated |
| B. | sys.dm_broker_activated_tasks |
| C. | sys.dm_broker_tasks |
| D. | dm_broker_activated_tasks |
| Answer» C. sys.dm_broker_tasks | |
| 247. |
Service broker was added to SQL Server ______ |
| A. | 2000 |
| B. | 2005 |
| C. | 2008 |
| D. | 2012 |
| Answer» C. 2008 | |
| 248. |
Which of the following method is used to delete records in LINQ ? |
| A. | DeleteOn |
| B. | Delete |
| C. | DeleteOnSubmit |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 249. |
LINQ to SQL in SQL Server fully supports : |
| A. | Transactions |
| B. | Functions |
| C. | Stored Procedures |
| D. | All of the mentioned |
| Answer» E. | |
| 250. |
LINQ to SQL is considered to be one of Microsoft’s _______ products. |
| A. | ORM |
| B. | ODBC |
| C. | JDBC |
| D. | SQLLIB |
| Answer» B. ODBC | |