Explore topic-wise MCQs in Mongodb.

This section includes 76 Mcqs, each offering curated multiple-choice questions to sharpen your Mongodb knowledge and support exam preparation. Choose a topic below to get started.

1.

_____ is a command-line tool for monitoring network use.

A. bwm-ng
B. bwm-g
C. bwm-n
D. bwm-ngs
Answer» B. bwm-g
Discussion
2.

The TCP keepalive on the Azure load balancer is ______ seconds by default.

A. 100
B. 200
C. 240
D. None of the mentioned
Answer» B. 200
Discussion
3.

Which of the following is especially important in Sharded Clusters?

A. NSS
B. STP
C. NTP
D. SSD
Answer» B. STP
Discussion
4.

With the WiredTiger storage engine, use of _______ is strongly recommended to avoid performance issues.

A. XFS
B. SSD
C. SST
D. All of the mentioned
Answer» B. SSD
Discussion
5.

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
Discussion
6.

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
Discussion
7.

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 mentioned
Answer» E.
Discussion
8.

Point out the wrong statement related to the use of Copy database wizard.

A. Pick a source and destination server
B. System stored procedures
C. Schedule when to move or copy the databases
D. None of the mentioned
Answer» C. Schedule when to move or copy the databases
Discussion
9.

How many types of backups are provided by SQL Server?

A. 5
B. 6
C. 7
D. 8
Answer» E.
Discussion
10.

How many types of recovery model is provided by SQL Server?

A. 2
B. 3
C. 4
D. 5
Answer» C. 4
Discussion
11.

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 mentioned
Answer» C. members of the sysadministraion
Discussion
12.

Which of the following column is a part of syspolicy_policies result?

A. name
B. root_condition_id
C. date_created
D. all of the mentioned
Answer» E.
Discussion
13.

How many types of execution mode are present in syspolicy_policies?

A. 2
B. 3
C. 4
D. 5
Answer» D. 5
Discussion
14.

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
Discussion
15.

Point out the wrong statement related to master database.

A. They are used to provide details of an backup plans
B. Master records the information for SQL Server temporarily
C. Master records the initialization information for SQL Server
D. None of the mentioned
Answer» C. Master records the initialization information for SQL Server
Discussion
16.

Database mirroring operates in how many modes?

A. 2
B. 3
C. 4
D. 5
Answer» C. 4
Discussion
17.

Which of the following modes writes the data on the principal and mirror databases synchronously?

A. High safety with automatic cluster
B. High safety
C. High safety with automatic failover
D. High performance
Answer» B. High safety
Discussion
18.

Which of the following script will backup the database requires for database mirroring?

A. USE master
B. USE master
C. USE master
D. All of the mentioned
Answer» B. USE master
Discussion
19.

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 mentioned
Answer» C. Switch back to high performance (sync)
Discussion
20.

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.
Discussion
21.

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 mentioned
Answer» E.
Discussion
22.

SQL Server can notify operators of alerts through ____________

A. E-mail
B. Net send
C. Pager
D. All of the mentioned
Answer» E.
Discussion
23.

SQL Agent Job definitions are specified in which database?

A. msdb
B. master
C. tempdb
D. all of the mentioned
Answer» B. master
Discussion
24.

Which of the code is valid for attaching the database?

A. USE master;
B. USE master;
C. USE master;
D. None of the mentioned
Answer» B. USE master;
Discussion
25.

Which of the following code snippet will detach AdventureWorks2012 database?

A. USE master;
B. USE master;
C. USE master;
D. USE master;
Answer» B. USE master;
Discussion
26.

Which of the following scenario prefers not to use database snapshots?

A. Database Snapshots should be seen as high availability option
B. Database Snapshots should not be seen as an alternative to regular backups of your data
C. Snapshots can be created very quickly
D. All of the mentioned
Answer» C. Snapshots can be created very quickly
Discussion
27.

Which of the syntax is used for creating database snapshot in SQL Server?

A. CREATE Snapshot database_snapshot_name
B. CREATE DATABASESNAPSHOT database_snapshot_name
C. CREATE DATABASE database_snapshot_name
D. None of the mentioned
Answer» D. None of the mentioned
Discussion
28.

Which of the following code will DROP an existing snapshot before creating new?

A. IF NOT EXISTS(
B. IF EXISTS(
C. IF NOT EXISTS(
D. None of the mentioned
Answer» B. IF EXISTS(
Discussion
29.

What should be done to check to see if data still exists in the Snapshot?

A. Run Delete on Database Snapshot
B. Run Update on Database Snapshot
C. Run Select on Database Snapshot
D. Run Insert on Database Snapshot
Answer» D. Run Insert on Database Snapshot
Discussion
30.

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];
Discussion
31.

To revert the database, which of the following Transact-SQL statement is used?

A. RESTORE Snapshot <database_name> FROM DATABASE_SNAPSHOT = <database_snapshot_name>
B. RESTORE DATABASE <database_name> FROM DATABASE_SNAPSHOT = <database_snapshot_name>
C. REST DATABASE <database_name> FROM DATABASE_SNAPSHOT = <database_snapshot_name>
D. None of the mentioned
Answer» C. REST DATABASE <database_name> FROM DATABASE_SNAPSHOT = <database_snapshot_name>
Discussion
32.

Which of the following code will throw error?

A. CREATE DATABASE AWDB_Snapshot_20080522 ON (
B. CREATE DATABASE AWDB_Snapshot_2008 ON (
C. CREATE DATABASE AWDB_Snapshot_20080 ON (
D. CREATE DATABASE Snapshot_20080522 ON (
Answer» B. CREATE DATABASE AWDB_Snapshot_2008 ON (
Discussion
33.

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 INDEXDEFRAG
Answer» E.
Discussion
34.

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 mentioned
Answer» C. Performing SQL Server Maintenance with Scrip Maintenance Window
Discussion
35.

Which of the following is used to Validate the database objects?

A. DBCC SHOWCONTIG
B. DBCC CHECKDB
C. DBCC CATALOG
D. None of the mentioned
Answer» C. DBCC CATALOG
Discussion
36.

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 mentioned
Answer» B. DBCC CHECKDB
Discussion
37.

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.
Discussion
38.

Generally, a good practice is to 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
Discussion
39.

_________ 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
Discussion
40.

Which of the following backups contain transaction logs?

A. copy-only backup
B. database backup
C. data backup
D. none of the mentioned
Answer» E.
Discussion
41.

____________ 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
Discussion
42.

_____________ 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
Discussion
43.

Which of the following is not a type of backup?

A. database backup
B. data backup
C. table backup
D. all of the mentioned
Answer» D. all of the mentioned
Discussion
44.

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 mentioned
Answer» E.
Discussion
45.

Which of the following is correct syntax for sp_add_log_shipping_secondary_primary?

A. sp_add_log_shipping_secondary_primary
B. sp_add_log_shipping_secondary_primary
C. xp_add_log_shipping_secondary_primary
D. All of the mentioned
Answer» B. sp_add_log_shipping_secondary_primary
Discussion
46.

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 mentioned
Answer» D. None of the mentioned
Discussion
47.

In which of the following modes, the database is read-only?

A. Stand by
B. Read only
C. Restore mode
D. All of the mentioned
Answer» B. Read only
Discussion
48.

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 server
Answer» E.
Discussion
49.

Which of the following operation requires to run SQL Server Setup on the node?

A. Add
B. Remove
C. Update
D. All of the mentioned
Answer» E.
Discussion
50.

____________ 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.
Discussion