Introduction to SQL A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? MAX COUNT All of these SUM MAX COUNT All of these SUM ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following must be enclosed in double quotes? Dates Column Alias Strings All of these Dates Column Alias Strings All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ON UPDATE CASCADE ensures which of the following? Normalization Data Integrity All of these Materialized Views Normalization Data Integrity All of these Materialized Views ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? APPEND INSERT ADD UPDATE APPEND INSERT ADD UPDATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS