Question Bank

3705 approved questions from the community

What does the query `db.books.find().sort({x:1})` do?

MEDIUM
SINGLE CHOICE
30s
Mongo
by Mohamed

What does the query `db.books.find({'name': /abc/})` do?

MEDIUM
SINGLE CHOICE
30s
Mongo
by Mohamed

What is an aggregator in MongoDB?

MEDIUM
SINGLE CHOICE
30s
Mongo
by Mohamed

When comparing embedded documents vs referenced documents in MongoDB, which is better?

HARD
SINGLE CHOICE
35s
Mongo
by Mohamed

What is the difference between find() and find_one() in MongoDB?

EASY
SINGLE CHOICE
30s
Mongo
by Mohamed

How can you export data from MongoDB? (Select all that apply)

EASY
MULTIPLE CHOICE
30s
Mongo
by Mohamed

What are the advantages of MongoDB? (Select all that apply)

MEDIUM
MULTIPLE CHOICE
40s
Mongo
by Mohamed

In what scenarios would you prefer NoSQL/Mongo over SQL? (Select all that apply)

MEDIUM
MULTIPLE CHOICE
40s
Mongo
by Mohamed

What are ways to optimize data retrieval in MongoDB? (Select all that apply)

MEDIUM
MULTIPLE CHOICE
40s
Mongo
by Mohamed

What is a document in MongoDB?

EASY
SINGLE CHOICE
30s
Mongo
by Mohamed

What does the 'find()' method do in MongoDB?

EASY
SINGLE CHOICE
25s
Mongo
by Mohamed

What advantage do referenced documents have over embedded documents?

HARD
SINGLE CHOICE
35s
Mongo
by Mohamed

What is a collection in MongoDB?

EASY
SINGLE CHOICE
25s
Mongo
by Mohamed

What does the WHERE clause do in a SQL query?

EASY
SINGLE CHOICE
25s
SQL
by Mohamed

What is the purpose of the GROUP BY clause?

MEDIUM
SINGLE CHOICE
30s
SQL
by Mohamed

What advantage does NoSQL have over SQL regarding data types?

MEDIUM
SINGLE CHOICE
35s
SQL
by Mohamed

SQL databases store data in tables with rows and columns.

EASY
TRUE FALSE
20s
SQL
by Mohamed

What does ACID stand for in database context?

EASY
SINGLE CHOICE
30s
SQL
by Mohamed

In SQL, using functions on columns in WHERE clauses (like YEAR(date_column)) is just as efficient as comparing the column directly.

MEDIUM
TRUE FALSE
30s
SQL
by Mohamed

How would you display which customer ordered which items?

HARD
SINGLE CHOICE
40s
SQL
by Mohamed
PreviousPage 43 of 186Next