Introduction to SQL Which of the following group functions ignore NULL values? MAX All of these SUM COUNT MAX All of these SUM 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. NATURAL JOIN EQUIJOIN NON-EQUIJOIN OUTER JOIN NATURAL JOIN EQUIJOIN NON-EQUIJOIN OUTER JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL There is an equivalent join expression that can be substituted for all subquery expressions. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword BETWEEN is used: for ranges. None of these to limit the columns displayed. as a wildcard. for ranges. None of these to limit the columns displayed. as a wildcard. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? Self-Join Non-Equijoin Equijoin None of these Self-Join Non-Equijoin Equijoin None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS