Introduction to SQL Which of the SQL statements is correct? SELECT Username, Password FROM Users SELECT Username AND Password FROM Users SELECT Username, Password WHERE Username = 'user1' None of these SELECT Username, Password FROM Users SELECT Username AND Password FROM Users SELECT Username, Password WHERE Username = 'user1' None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL -92 wildcards are ____ and ____ . asterisk (*); percent sign (%) percent sign (%); underscore (_) question mark (?); asterisk (*) underscore(_); question mark (?) asterisk (*); percent sign (%) percent sign (%); underscore (_) question mark (?); asterisk (*) underscore(_); question mark (?) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: ORDER BY. SORT BY. GROUP BY. None of these ORDER BY. SORT BY. GROUP BY. None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL There is an equivalent join expression that can be substituted for all subquery expressions. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a(n) ________ . form report file table form report file table ANSWER DOWNLOAD EXAMIANS APP