Introduction to SQL Which of the following is a SQL aggregate function? LEFT LEN AVG JOIN LEFT LEN AVG JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The FROM SQL clause is used to... None of these specify range for search condition specify what table we are selecting or deleting data FROM specify search condition None of these specify range for search condition specify what table we are selecting or deleting data FROM specify search condition ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The rows of the result relation produced by a SELECT statement can be sorted, but only by one column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL You can add a row using SQL in a database with which of the following? INSERT MAKE ADD CREATE INSERT MAKE ADD CREATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL If a query involves NOT, AND, OR with no parenthesis NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. The order of occurrence determines the order of evaluation. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. The order of occurrence determines the order of evaluation. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? APPEND INSERT UPDATE ADD APPEND INSERT UPDATE ADD ANSWER DOWNLOAD EXAMIANS APP