Introduction to SQL A dynamic view is one whose contents materialize when referenced. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve a maximum value? MOST MAX UPPER TOP MOST MAX UPPER TOP ANSWER DOWNLOAD EXAMIANS APP
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 NULL is the same as blank for character not a value the same as 0 for integer the same as 0 for integer and blank for character the same as blank for character not a value the same as 0 for integer the same as 0 for integer and blank for character ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is the meaning of LIKE '%0%0%' Feature has more than two 0's Feature begins with two 0's Feature ends with two 0's Feature has two 0's in it, at any position Feature has more than two 0's Feature begins with two 0's Feature ends with two 0's Feature has two 0's in it, at any position 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. NON-EQUIJOIN NATURAL JOIN EQUIJOIN OUTER JOIN NON-EQUIJOIN NATURAL JOIN EQUIJOIN OUTER JOIN ANSWER DOWNLOAD EXAMIANS APP