Introduction to SQL Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return more than 10 rows None of these less than 10 rows exactly 10 rows more than 10 rows None of these less than 10 rows exactly 10 rows ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is the full form of SQL? Simple Query Language None of these Structured Query Language Structured Query List Simple Query Language None of these Structured Query Language Structured Query List ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL There is an equivalent join expression that can be substituted for all subquery expressions. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? AVG LEFT JOIN LEN AVG LEFT JOIN LEN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? All of these SUM MAX COUNT All of these SUM MAX COUNT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ............. joins two or more tables based on a specified column value not equaling a specified column value in another table. OUTER JOIN NON-EQUIJOIN EQUIJOIN NATURAL JOIN OUTER JOIN NON-EQUIJOIN EQUIJOIN NATURAL JOIN ANSWER DOWNLOAD EXAMIANS APP