Introduction to SQL A dynamic view is one whose contents materialize when referenced. False True False True 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 Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? None Data Definition Language(DDL) Both of above Data Manipulation Language(DML) None Data Definition Language(DDL) Both of above Data Manipulation Language(DML) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL COUNT(field_name) tallies only those rows that contain a value; it ignores all null values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is the meaning of LIKE '%0%0%' Feature ends with two 0's Feature has two 0's in it, at any position Feature begins with two 0's Feature has more than two 0's Feature ends with two 0's Feature has two 0's in it, at any position Feature begins with two 0's Feature has more than two 0's ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? NOT operator IS NULL operator None of these EXISTS operator NOT operator IS NULL operator None of these EXISTS operator ANSWER DOWNLOAD EXAMIANS APP