Introduction to SQL You can add a row using SQL in a database with which of the following? ADD MAKE INSERT CREATE ADD MAKE INSERT CREATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to sort the result-set? SORT ORDER BY SORT BY ORDER SORT ORDER BY SORT BY ORDER ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? APPEND UPDATE INSERT ADD APPEND UPDATE INSERT ADD ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints ab gh bc 23 ab gh bc 23 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? DELETE COLLAPSE ALTER REMOVE DELETE COLLAPSE ALTER REMOVE ANSWER DOWNLOAD EXAMIANS APP