Introduction to SQL The SQL WHERE clause: Both A and B are correct. limits the column data that are returned. Neither A nor B are correct. limits the row data are returned. Both A and B are correct. limits the column data that are returned. Neither A nor B are correct. limits the row data are returned. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? DELETE TRUNCATE COMMIT ROLLBACK DELETE TRUNCATE COMMIT ROLLBACK 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 5 0 10 9 5 0 10 9 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following must be enclosed in double quotes? Strings All of these Dates Column Alias Strings All of these Dates Column Alias 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 DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; None of These SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; None of These ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ............. joins two or more tables based on a specified column value not equaling a specified column value in another table. EQUIJOIN NATURAL JOIN OUTER JOIN NON-EQUIJOIN EQUIJOIN NATURAL JOIN OUTER JOIN NON-EQUIJOIN ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS