Introduction to SQL To sort the results of a query use: None of these ORDER BY. GROUP BY. SORT BY. None of these ORDER BY. GROUP BY. SORT BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? Data Manipulation Language(DML) Both of above Data Definition Language(DDL) None Data Manipulation Language(DML) Both of above Data Definition Language(DDL) None ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword(s) ________ is used with wildcards. NOT IN only LIKE only IN only IN and NOT IN NOT IN only LIKE only IN only IN and NOT IN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities whose humidity is 89 SELECT humidity = 89 FROM weather; SELECT city WHERE humidity = 89; SELECT city FROM weather; SELECT city FROM weather WHERE humidity = 89; SELECT humidity = 89 FROM weather; SELECT city WHERE humidity = 89; SELECT city FROM weather; SELECT city FROM weather WHERE humidity = 89; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Select the right statement to insert values to the student table. INSERT student VALUES ( INSERT VALUES INTO student ( INSERT INTO student VALUES ( INSERT VALUES ( INSERT student VALUES ( INSERT VALUES INTO student ( INSERT INTO student VALUES ( INSERT VALUES ( ANSWER DOWNLOAD EXAMIANS APP