Introduction to SQL SQL data definition commands make up a(n) ________ . XML DML DDL HTML XML DML DDL HTML ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ON UPDATE CASCADE ensures which of the following? All of these Materialized Views Data Integrity Normalization All of these Materialized Views Data Integrity Normalization ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL -92 wildcards are ____ and ____ . underscore(_); question mark (?) question mark (?); asterisk (*) percent sign (%); underscore (_) asterisk (*); percent sign (%) underscore(_); question mark (?) question mark (?); asterisk (*) percent sign (%); underscore (_) asterisk (*); percent sign (%) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function. True False True False 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. True False True False ANSWER DOWNLOAD EXAMIANS APP