Introduction to SQL You can add a row using SQL in a database with which of the following? ADD CREATE MAKE INSERT ADD CREATE MAKE INSERT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; 6789 1234 2345 456789 6789 1234 2345 456789 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SUM, AVG, MIN, and MAX can only be used with numeric columns. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword(s) ________ is used with wildcards. NOT IN only IN and NOT IN IN only LIKE only NOT IN only IN and NOT IN IN only LIKE only ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement. False True False True ANSWER DOWNLOAD EXAMIANS APP