Introduction to SQL Which of the following do you need to consider when you make a table in SQL? Primary keys Default values All of these Data types Primary keys Default values All of these Data types ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column. False True False True 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 atmost one sailor who have reserved red boats but not green boats Find the sailor IDs of at least 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 atmost one sailor who have reserved red boats but not green boats Find the sailor IDs of at least 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 A subquery in an SQL SELECT statement: cannot have its results sorted using ORDER BY. can always be duplicated by a join. has a distinct form that cannot be duplicated by a join. can only be used with two tables. cannot have its results sorted using ORDER BY. can always be duplicated by a join. has a distinct form that cannot be duplicated by a join. can only be used with two tables. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Select the right statement to insert values to the student table. INSERT student VALUES ( INSERT VALUES ( INSERT VALUES INTO student ( INSERT INTO student VALUES ( INSERT student VALUES ( INSERT VALUES ( INSERT VALUES INTO student ( INSERT INTO student VALUES ( ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities whose humidity is 89 SELECT city FROM weather; SELECT city FROM weather WHERE humidity = 89; SELECT city WHERE humidity = 89; SELECT humidity = 89 FROM weather; SELECT city FROM weather; SELECT city FROM weather WHERE humidity = 89; SELECT city WHERE humidity = 89; SELECT humidity = 89 FROM weather; ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS