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 Which of the following query finds the names of the sailors who have reserved at least one boat? SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; None of These SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; None of These ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The wildcard in a WHERE clause is useful when? An exact match is not possible in a CREATE statement. An exact match is not possible in a SELECT statement. An exact match is necessary in a SELECT statement. An exact match is necessary in a CREATE statement. An exact match is not possible in a CREATE statement. An exact match is not possible in a SELECT statement. An exact match is necessary in a SELECT statement. An exact match is necessary in a CREATE statement. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? APPEND ADD UPDATE INSERT APPEND ADD UPDATE INSERT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? ROLLBACK TRUNCATE COMMIT DELETE ROLLBACK TRUNCATE COMMIT DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command is used to change a table's storage characteristics? ALTER TABLE None of these MODIFY TABLE CHANGE TABLE ALTER TABLE None of these MODIFY TABLE CHANGE TABLE ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS