Introduction to SQL Which SQL keyword is used to sort the result-set? ORDER BY SORT BY ORDER SORT ORDER BY SORT BY ORDER SORT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? EXISTS operator BETWEEN operator LIKE operator None of these EXISTS operator BETWEEN operator LIKE operator None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL You can add a row using SQL in a database with which of the following? MAKE ADD CREATE INSERT MAKE ADD CREATE INSERT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is illegal? SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; None of these SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; None of these SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities whose humidity is 89 SELECT city FROM weather; SELECT city WHERE humidity = 89; SELECT humidity = 89 FROM weather; SELECT city FROM weather WHERE humidity = 89; SELECT city FROM weather; SELECT city WHERE humidity = 89; SELECT humidity = 89 FROM weather; SELECT city FROM weather WHERE humidity = 89; 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: None of these all records with even partial criteria met are to be returned. all records meeting the full criteria are to be returned. all columns of the table are to be returned. None of these all records with even partial criteria met are to be returned. all records meeting the full criteria are to be returned. all columns of the table are to be returned. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS