Introduction to SQL A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL You can add a row using SQL in a database with which of the following? ADD CREATE INSERT MAKE ADD CREATE INSERT MAKE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? ADD UPDATE APPEND INSERT ADD UPDATE APPEND INSERT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following are the five built-in functions provided by SQL? COUNT, SUM, AVG, MAX, MIN SUM, AVG, MIN, MAX, MULT SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, NAME COUNT, SUM, AVG, MAX, MIN SUM, AVG, MIN, MAX, MULT SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, NAME ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to sort the result-set? SORT SORT BY ORDER BY ORDER SORT SORT BY ORDER BY ORDER ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS