Introduction to SQL Which operator performs pattern matching? None of these LIKE operator BETWEEN operator EXISTS operator None of these LIKE operator BETWEEN operator EXISTS operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints bc gh 23 ab bc gh 23 ab ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The rows of the result relation produced by a SELECT statement can be sorted, but only by one column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The HAVING clause does which of the following? Acts like a WHERE clause but is used for groups rather than rows. Acts like a WHERE clause but is used for rows rather than columns. Acts EXACTLY like a WHERE clause. Acts like a WHERE clause but is used for columns rather than groups. Acts like a WHERE clause but is used for groups rather than rows. Acts like a WHERE clause but is used for rows rather than columns. Acts EXACTLY like a WHERE clause. Acts like a WHERE clause but is used for columns rather than groups. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the original purpose of SQL? All of these To specify the syntax and semantics of SQL manipulation language To define the data structures To specify the syntax and semantics of SQL data definition language All of these To specify the syntax and semantics of SQL manipulation language To define the data structures To specify the syntax and semantics of SQL data definition language ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to sort the result-set? ORDER SORT BY ORDER BY SORT ORDER SORT BY ORDER BY SORT ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS