Introduction to SQL The SQL WHERE clause: limits the row data are returned. Both A and B are correct. limits the column data that are returned. Neither A nor B are correct. limits the row data are returned. Both A and B are correct. limits the column data that are returned. Neither A nor B are correct. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ............. joins two or more tables based on a specified column value not equaling a specified column value in another table. NATURAL JOIN NON-EQUIJOIN EQUIJOIN OUTER JOIN NATURAL JOIN NON-EQUIJOIN EQUIJOIN OUTER JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters." False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ON UPDATE CASCADE ensures which of the following? Materialized Views Normalization Data Integrity All of these Materialized Views Normalization Data Integrity All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement: has a distinct form that cannot be duplicated by a join. cannot have its results sorted using ORDER BY. can always be duplicated by a join. can only be used with two tables. has a distinct form that cannot be duplicated by a join. cannot have its results sorted using ORDER BY. can always be duplicated by a join. can only be used with two tables. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. True False True False ANSWER DOWNLOAD EXAMIANS APP