Introduction to SQL Which of the following SQL commands can be used to add data to a database table? UPDATE APPEND ADD INSERT UPDATE APPEND ADD INSERT 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 The keyword BETWEEN can be used in a WHERE clause to refer to a range of values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? None Data Definition Language(DDL) Data Manipulation Language(DML) Both of above None Data Definition Language(DDL) Data Manipulation Language(DML) Both of above ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL -92 wildcards are ____ and ____ . asterisk (*); percent sign (%) percent sign (%); underscore (_) underscore(_); question mark (?) question mark (?); asterisk (*) asterisk (*); percent sign (%) percent sign (%); underscore (_) underscore(_); question mark (?) question mark (?); asterisk (*) ANSWER DOWNLOAD EXAMIANS APP