Introduction to SQL Which one of the following sorts rows in SQL? ALIGN BY SORT BY ORDER BY GROUP BY ALIGN BY SORT BY ORDER BY GROUP BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve a maximum value? TOP UPPER MAX MOST TOP UPPER MAX MOST ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SUM, AVG, MIN, and MAX can only be used with numeric columns. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL You can add a row using SQL in a database with which of the following? CREATE INSERT ADD MAKE CREATE INSERT ADD MAKE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL -92 wildcards are ____ and ____ . question mark (?); asterisk (*) underscore(_); question mark (?) percent sign (%); underscore (_) asterisk (*); percent sign (%) question mark (?); asterisk (*) underscore(_); question mark (?) percent sign (%); underscore (_) asterisk (*); percent sign (%) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? COMMIT ROLLBACK DELETE TRUNCATE COMMIT ROLLBACK DELETE TRUNCATE ANSWER DOWNLOAD EXAMIANS APP