Introduction to SQL Which of the following must be enclosed in double quotes? Dates All of these Column Alias Strings Dates All of these Column Alias Strings ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL There is an equivalent join expression that can be substituted for all subquery expressions. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; 1234 2345 6789 456789 1234 2345 6789 456789 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? MODIFY UPDATE SAVE SAVE AS MODIFY UPDATE SAVE SAVE AS ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS