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
Tag: Databases MCQs
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
Which of the following is not a valid aggregate function?
Which of the following is not a valid aggregate function?
COMPUTE
Well Done. Your Answer is Correct Keep it Up!
COUNT
SUM
MAX
Which datatype can store unstructured data in a column?
Which datatype can store unstructured data in a column?
RAW
Well Done. Your Answer is Correct Keep it Up!
CHAR
NUMERIC
VARCHAR
Which of the following is not Constraint in SQL?
Which of the following is not Constraint in SQL?
Union
Well Done. Your Answer is Correct Keep it Up!
Check
Not Null
Primary Key
How many Primary keys can have in a table?
How many Primary keys can have in a table?
Only 1
Well Done. Your Answer is Correct Keep it Up!
Only 2
Depends on no of Columns
Depends on DBA
SQL Views are also known as
SQL Views are also known as
Virtual tables
Well Done. Your Answer is Correct Keep it Up!
Simple tables
Complex tables
Actual Tables