Introduction to SQL Which of the following SQL commands can be used to add data to a database table? INSERT APPEND UPDATE ADD INSERT APPEND UPDATE ADD ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL data definition commands make up a(n) ________ . DDL XML DML HTML DDL XML DML HTML ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? DELETE ALTER COLLAPSE REMOVE DELETE ALTER COLLAPSE REMOVE 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 ............. joins two or more tables based on a specified column value not equaling a specified column value in another table. OUTER JOIN EQUIJOIN NATURAL JOIN NON-EQUIJOIN OUTER JOIN EQUIJOIN NATURAL JOIN NON-EQUIJOIN ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS