Introduction to SQL COUNT(field_name) tallies only those rows that contain a value; it ignores all null values. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return less than 10 rows more than 10 rows None of these exactly 10 rows less than 10 rows more than 10 rows None of these exactly 10 rows ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Most companies keep at least two versions of any database they are using. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. UNIQUE SINGLE ONLY DISTINCT UNIQUE SINGLE ONLY DISTINCT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? None of these Self-Join Equijoin Non-Equijoin None of these Self-Join Equijoin Non-Equijoin ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve a maximum value? MAX UPPER TOP MOST MAX UPPER TOP MOST ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS