Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? COMMIT TRUNCATE DELETE ROLLBACK COMMIT TRUNCATE DELETE ROLLBACK ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? LEN JOIN LEFT AVG LEN JOIN LEFT AVG ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL -92 wildcards are ____ and ____ . percent sign (%); underscore (_) question mark (?); asterisk (*) asterisk (*); percent sign (%) underscore(_); question mark (?) percent sign (%); underscore (_) question mark (?); asterisk (*) asterisk (*); percent sign (%) underscore(_); question mark (?) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which one of the following sorts rows in SQL? GROUP BY ORDER BY SORT BY ALIGN BY GROUP BY ORDER BY SORT BY ALIGN BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a(n) ________ . table file report form table file report form ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS