Introduction to SQL The SQL keyword BETWEEN is used: for ranges. to limit the columns displayed. as a wildcard. None of these for ranges. to limit the columns displayed. as a wildcard. None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? REMOVE DELETE COLLAPSE ALTER REMOVE DELETE COLLAPSE ALTER ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);prints 9 10 0 5 9 10 0 5 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? None of these IS NULL operator NOT operator EXISTS operator None of these IS NULL operator NOT operator EXISTS operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command(s) is(are) used to change a table's storage characteristics? All of these MODIFY TABLE CHANGE TABLE ALTER TABLE All of these MODIFY TABLE CHANGE TABLE ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP