A CASE SQL statement is ________?
A way to establish an IF-THEN-ELSE in SQL
Well Done. Your Answer is Correct Keep it Up!
A way to establish a loop in SQL.
A way to establish a data definition in SQL
All options are correct
Category: Databases MCQs
Which command is used to change the definition of a table in SQL?
Which command is used to change the definition of a table in SQL?
ALTER
Well Done. Your Answer is Correct Keep it Up!
UPDATE
CREATE
SELECT
Which type of JOIN is used to returns rows that do not have matching values?
Which type of JOIN is used to returns rows that do not have matching values?
Outer JOIN
Well Done. Your Answer is Correct Keep it Up!
EQUI JOIN
Natural JOIN
All options are correct
A command that lets you change one or more field in a table is:
A command that lets you change one or more field in a table is:
MODIFY
Well Done. Your Answer is Correct Keep it Up!
INSERT
LOOK-UP
All options are correct
_______ clause creates temporary relation for the query on which it is defined.
_______ clause creates temporary relation for the query on which it is defined.
FROM
Well Done. Your Answer is Correct Keep it Up!
WITH
WHERE
SELECT
In which of the following cases a DML statement is not executed?
In which of the following cases a DML statement is not executed?
When a table is deleted.
Well Done. Your Answer is Correct Keep it Up!
When existing rows are modified.
When some rows are deleted.
All options are correct
If we have not specified ASC or DESC after a SQL ORDER BY clause, the following is used by default
If we have not specified ASC or DESC after a SQL ORDER BY clause, the following is used by default
ASC
Well Done. Your Answer is Correct Keep it Up!
DESC
There is no default value
None of the options are correct
What operator tests column for absence of data
What operator tests column for absence of data
IS NULL Operator
Well Done. Your Answer is Correct Keep it Up!
Exists Operator
NOT Operator
None of the options are correct
Which operator is used to compare a value to a specified list of values?
Which operator is used to compare a value to a specified list of values?
IN
Well Done. Your Answer is Correct Keep it Up!
ALL
BETWEEN
ANY
Which data manipulation command is used to combines the records from one or more tables?
Which data manipulation command is used to combines the records from one or more tables?
JOIN
Well Done. Your Answer is Correct Keep it Up!
SELECT
PROJECT
PRODUCT