Introduction to SQL The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement that queries or reads data from a table is ________ . QUERY READ SELECT None of these QUERY READ SELECT None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The keyword BETWEEN can be used in a WHERE clause to refer to a range of values. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the original purpose of SQL? To specify the syntax and semantics of SQL manipulation language All of these To specify the syntax and semantics of SQL data definition language To define the data structures To specify the syntax and semantics of SQL manipulation language All of these To specify the syntax and semantics of SQL data definition language To define the data structures ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL You can add a row using SQL in a database with which of the following? ADD MAKE CREATE INSERT ADD MAKE CREATE INSERT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement: cannot have its results sorted using ORDER BY. can only be used with two tables. can always be duplicated by a join. has a distinct form that cannot be duplicated by a join. cannot have its results sorted using ORDER BY. can only be used with two tables. can always be duplicated by a join. has a distinct form that cannot be duplicated by a join. ANSWER DOWNLOAD EXAMIANS APP