Questions Quizzes Daily challenge System design My attempts

Loading questions…

Practice / Questions

Question bank.

Explore 2,015 questions across 22 categories. Choose a subject, format, and difficulty, then learn from each explanation.

Prefer a full quiz? Browse quizzes →

Find a question

Search questions

Category

Topic

Question format

Difficulty

96 questions found

Showing 81–96 of 96 results

SQL and relational databases · Multiple Select
Difficulty: Easy
Consider [WHERE; SUM; DISTINCT; HAVING; ORDER BY; COUNT]. Select all entries that are SQL aggregate function names.
AggregationSet membership
Answer →
SQL and relational databases · Multiple Select
Difficulty: Easy

Consider [FROM; DISTINCT; AVG; HAVING; MAX; COUNT]. Select all entries that are SQL aggregate function names.

AggregationSet membership

SQL and relational databases · Multiple Select

Difficulty: Easy

Consider [AVG; SUM; WHERE; JOIN; ORDER BY; HAVING]. Select all entries that are SQL aggregate function names.

AggregationSet membership

SQL and relational databases · Multiple Select

Difficulty: Easy

Consider [SUM; DISTINCT; COUNT; ORDER BY; MIN; HAVING]. Select all entries that are SQL aggregate function names.

AggregationSet membership

SQL and relational databases · Multiple Select

Difficulty: Easy

Consider [SUM; JOIN; DISTINCT; FROM; WHERE; MAX]. Select all entries that are SQL aggregate function names.

AggregationSet membership

SQL and relational databases · Multiple Select

Difficulty: Easy

Consider [ORDER BY; FROM; GROUP BY; HAVING; CHECK; PRIMARY KEY]. Select all entries that are SQL integrity constraints.

ConstraintsSet membership

SQL and relational databases · Multiple Select

Difficulty: Easy

Consider [CHECK; SELECT; HAVING; FOREIGN KEY; NOT NULL; ORDER BY]. Select all entries that are SQL integrity constraints.

ConstraintsSet membership

SQL and relational databases · Multiple Select

Difficulty: Easy

Consider [FOREIGN KEY; SELECT; ORDER BY; GROUP BY; FROM; UNIQUE]. Select all entries that are SQL integrity constraints.

ConstraintsSet membership

SQL and relational databases · Multiple Select

Difficulty: Easy

Consider [UNIQUE; ORDER BY; CHECK; FROM; NOT NULL; GROUP BY]. Select all entries that are SQL integrity constraints.

ConstraintsSet membership

SQL and relational databases · Multiple Select

Difficulty: Easy

Consider [FOREIGN KEY; PRIMARY KEY; GROUP BY; ORDER BY; SELECT; HAVING]. Select all entries that are SQL integrity constraints.

ConstraintsSet membership

SQL and relational databases · Ordering / Sequencing

Difficulty: Medium

Arrange the dependent steps for this atomic update task. Both the read and the update must occur inside the explicit transaction.

Atomic updateDependencies

SQL and relational databases · True or False

Difficulty: Medium

True or false: The SQL condition value = NULL is the ordinary way to test whether a value is absent.

NullsConcept checks

SQL and relational databases · True or False

Difficulty: Medium

True or false: COUNT(column) ignores rows where that column is null.

AggregationConcept checks

SQL and relational databases · True or False

Difficulty: Medium

True or false: A SELECT query without ORDER BY guarantees primary-key order.

OrderingConcept checks

SQL and relational databases · True or False

Difficulty: Medium

True or false: A rollback discards changes that have not yet been committed in the transaction being rolled back.

TransactionsConcept checks

SQL and relational databases · True or False

Difficulty: Medium

True or false: A left join always removes a left-side row that has no right-side match.

JoinsConcept checks

Showing 81–96 of 96 results