Introduction to SQL What operator tests column for the absence of data? EXISTS operator NOT operator None of these IS NULL operator EXISTS operator NOT operator None of these IS NULL operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return None of these exactly 10 rows less than 10 rows more than 10 rows None of these exactly 10 rows less than 10 rows more than 10 rows ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs Hi Nothing TRUE FLASE Hi Nothing TRUE FLASE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: None of these ORDER BY. SORT BY. GROUP BY. None of these ORDER BY. SORT BY. GROUP BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that: None of these all records meeting the full criteria are to be returned. all records with even partial criteria met are to be returned. all columns of the table are to be returned. None of these all records meeting the full criteria are to be returned. all records with even partial criteria met are to be returned. all columns of the table are to be returned. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? TRUNCATE DELETE COMMIT ROLLBACK TRUNCATE DELETE COMMIT ROLLBACK ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS