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
Introduction to SQL The condition in a WHERE clause can refer to only one value. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ON UPDATE CASCADE ensures which of the following? Materialized Views All of these Data Integrity Normalization Materialized Views All of these Data Integrity Normalization ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To define what columns should be displayed in an SQL SELECT statement: use USING to name the source table(s) and list the columns to be shown after SELECT. use FROM to name the source table(s) and list the columns to be shown after SELECT. use USING to name the source table(s) and list the columns to be shown after WHER use SELECT to name the source table(s) and list the columns to be shown after USING. use USING to name the source table(s) and list the columns to be shown after SELECT. use FROM to name the source table(s) and list the columns to be shown after SELECT. use USING to name the source table(s) and list the columns to be shown after WHER use SELECT to name the source table(s) and list the columns to be shown after USING. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints bc 23 gh ab bc 23 gh ab ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a valid SQL type? FLOAT CHARACTER All of these NUMERIC FLOAT CHARACTER All of these NUMERIC ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS