Introduction to SQL Which SQL statement is used to delete data FROM a database? COLLAPSE REMOVE ALTER DELETE COLLAPSE REMOVE ALTER DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command(s) is(are) used to change a table's storage characteristics? CHANGE TABLE MODIFY TABLE ALTER TABLE All of these CHANGE TABLE MODIFY TABLE ALTER TABLE All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The condition in a WHERE clause can refer to only one value. True False True False 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 DISTINCT SINGLE ONLY UNIQUE DISTINCT SINGLE ONLY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The FROM SQL clause is used to... specify search condition None of these specify what table we are selecting or deleting data FROM specify range for search condition specify search condition None of these specify what table we are selecting or deleting data FROM specify range for search condition ANSWER DOWNLOAD EXAMIANS APP