Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 15 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.

1.

Every MongoDB mongod and mongos instance (or mongod.exe or mongos.exe on Windows) must have an associated ___________

A. service replica
B. service sets
C. service principal
D. service principle
Answer» D. service principle
2.

MongoDB Enterprise supports proxy authentication through ___________

A. SCRAM-SHA-1
B. LDAP
C. MONGODB-CR
D. None of the mentioned
Answer» C. MONGODB-CR
3.

MongoDB __________ supports authentication using a Kerberos service.

A. Standard
B. Express
C. Enterprise
D. None of the mentioned
Answer» D. None of the mentioned
4.

Which of the following authentication method is used by default by MongoDB?

A. SCRAM-SHA-1
B. LDAP
C. MONGODB-CR
D. None of the mentioned
Answer» B. LDAP
5.

Which of the following method is used for managing user?

A. db.createUser()
B. db.User()
C. db.superuser()
D. none of the mentioned
Answer» B. db.User()
6.

MONGODB_ENTERPRISE_SUPPORTS_PROXY_AUTHENTICATION_THROUGH_:?$

A. SCRAM-SHA-1
B. LDAP
C. MONGODB-CR
D. None of the mentioned
Answer» C. MONGODB-CR
7.

WHICH_OF_THE_FOLLOWING_AUTHENTICATION_MODES_IS_MORE_SECURE_??$

A. SQL Server Authentication
B. Windows Authentication
C. Mixed Mode
D. All of the mentioned
Answer» B. Windows Authentication
8.

Every_MongoDB_mongod_and_mongos_instance_(or_mongod.exe_or_mongos.exe_on_Windows)_must_have_an_associated_:$

A. service replica
B. service sets
C. service principal
D. service principle
Answer» D. service principle
9.

By_using_Windows_Authentication,_Windows_groups_can_be_created_at_the___________level.$

A. Login
B. Domain
C. User
D. None of the mentioned
Answer» C. User
10.

MongoDB supports _________ certificate authentication for use with a secure TLS/SSL connection.

A. x.590
B. x.509
C. x.950
D. All of the mentioned
Answer» C. x.950
11.

Windows Authentication Mode is not available when an instance of SQL Server is running on :

A. Windows 98
B. Windows 7
C. Windows 95
D. All of the mentioned
Answer» C. Windows 95
12.

_________ is a challenge-response mechanism that authenticates users through passwords.

A. SCRAM-SHA-1
B. LDAP
C. MONGODB-CR
D. None of the mentioned
Answer» D. None of the mentioned
13.

Which of the following feature prefers SQL Server authentication mode over windows authentication?

A. Backward compatibility
B. Forward compatibility
C. Security
D. All of the mentioned
Answer» C. Security
14.

Which of the follwing authentication method is used by default by MongoDB ?

A. SCRAM-SHA-1
B. LDAP
C. MONGODB-CR
D. None of the mentioned
Answer» B. LDAP
15.

MongoDB stores user information in the _________ collection.

A. system.allusers
B. system.users
C. system.superusers
D. system.usersnone
Answer» C. system.superusers