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 Which of the following is valid SQL for an Index? REMOVE INDEX ID; ADD INDEX ID; CREATE INDEX ID; CHANGE INDEX ID; REMOVE INDEX ID; ADD INDEX ID; CREATE INDEX ID; CHANGE INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The HAVING clause does which of the following? Acts like a WHERE clause but is used for groups rather than rows. Acts like a WHERE clause but is used for columns rather than groups. Acts EXACTLY like a WHERE clause. Acts like a WHERE clause but is used for rows rather than columns. Acts like a WHERE clause but is used for groups rather than rows. Acts like a WHERE clause but is used for columns rather than groups. Acts EXACTLY like a WHERE clause. Acts like a WHERE clause but is used for rows rather than columns. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? NOT operator IS NULL operator None of these EXISTS operator NOT operator IS NULL operator None of these EXISTS operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? DELETE ROLLBACK COMMIT TRUNCATE DELETE ROLLBACK COMMIT TRUNCATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to eliminate a table from a database is: DELETE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DROP TABLE CUSTOMER; UPDATE TABLE CUSTOMER; DELETE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DROP TABLE CUSTOMER; UPDATE TABLE CUSTOMER; ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS