Introduction to SQL Which of the following do you need to consider when you make a table in SQL? Primary keys All of these Default values Data types Primary keys All of these Default values Data types ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Most companies keep at least two versions of any database they are using. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL is a programming language. 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') Find the sailor IDs of at least one sailor 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 all sailors 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 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 all sailors who have reserved red boats but not green boats ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To define what columns should be displayed in an SQL SELECT statement: use USING to name the source table(s) and list the columns to be shown after SELECT. use USING to name the source table(s) and list the columns to be shown after WHER use FROM to name the source table(s) and list the columns to be shown after SELECT. use SELECT to name the source table(s) and list the columns to be shown after USING. use USING to name the source table(s) and list the columns to be shown after SELECT. use USING to name the source table(s) and list the columns to be shown after WHER use FROM to name the source table(s) and list the columns to be shown after SELECT. use SELECT to name the source table(s) and list the columns to be shown after USING. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword(s) ________ is used with wildcards. IN only IN and NOT IN NOT IN only LIKE only IN only IN and NOT IN NOT IN only LIKE only ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS