Introduction to SQL Which of the following SQL commands is used to retrieve data? INSERT JOIN SELECT DELETE INSERT JOIN SELECT DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL WHERE clause: Both A and B are correct. Neither A nor B are correct. limits the row data are returned. limits the column data that are returned. Both A and B are correct. Neither A nor B are correct. limits the row data are returned. limits the column data that are returned. 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 NON-EQUIJOIN EQUIJOIN OUTER JOIN NATURAL JOIN NON-EQUIJOIN EQUIJOIN OUTER JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? EXISTS operator IS NULL operator NOT operator None of these EXISTS operator IS NULL operator NOT operator None of these ANSWER DOWNLOAD EXAMIANS APP
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 Most companies keep at least two versions of any database they are using. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS