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 In SQL, which of the following is not a data definition language commands? REVOKE RENAME UPDATE GRANT REVOKE RENAME UPDATE GRANT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that: all columns of the table are to be returned. None of these all records meeting the full criteria are to be returned. all records with even partial criteria met are to be returned. all columns of the table are to be returned. None of these all records meeting the full criteria are to be returned. all records with even partial criteria met are to be returned. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL If a query involves NOT, AND, OR with no parenthesis AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. The order of occurrence determines the order of evaluation. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. The order of occurrence determines the order of evaluation. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? NOT operator None of these EXISTS operator IS NULL operator NOT operator None of these EXISTS operator IS NULL operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The condition in a WHERE clause can refer to only one value. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS