Introduction to SQL You can add a row using SQL in a database with which of the following? MAKE CREATE ADD INSERT MAKE CREATE ADD INSERT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s): IN only. NOT IN only. Both IN and NOT IN. LIKE only. IN only. NOT IN only. Both IN and NOT IN. LIKE only. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters." False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is illegal? SELECT SYSDATE - SYSDATE FROM DUAL; None of these SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; None of these SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL -92 wildcards are ____ and ____ . percent sign (%); underscore (_) underscore(_); question mark (?) question mark (?); asterisk (*) asterisk (*); percent sign (%) percent sign (%); underscore (_) underscore(_); question mark (?) question mark (?); asterisk (*) asterisk (*); percent sign (%) ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS