Introduction to SQL In SQL, which of the following is not a data definition language commands? RENAME REVOKE UPDATE GRANT RENAME REVOKE UPDATE GRANT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? Self-Join Equijoin None of these Non-Equijoin Self-Join Equijoin None of these Non-Equijoin ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? SAVE AS MODIFY UPDATE SAVE SAVE AS MODIFY UPDATE SAVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What does the following query find?(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'red')MINUS(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'green') None of These Find the sailor IDs of at least one sailor who have reserved red boats but not green boats Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats Find the sailor IDs of all sailors who have reserved red boats but not green boats None of These Find the sailor IDs of at least one sailor who have reserved red boats but not green boats Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats Find the sailor IDs of all sailors who have reserved red boats but not green boats 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 10 9 5 0 10 9 5 0 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS