Introduction to SQL Which of the following is valid SQL for an Index? CREATE INDEX ID; CHANGE INDEX ID; REMOVE INDEX ID; ADD INDEX ID; CREATE INDEX ID; CHANGE INDEX ID; REMOVE INDEX ID; ADD INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To define what columns should be displayed in an SQL SELECT statement: use FROM 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 SELECT. use USING to name the source table(s) and list the columns to be shown after WHER use SELECT to name the source table(s) and list the columns to be shown after USING. use FROM 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 SELECT. use USING to name the source table(s) and list the columns to be shown after WHER 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 command to eliminate a table from a database is: DROP TABLE CUSTOMER; UPDATE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DELETE TABLE CUSTOMER; DROP TABLE CUSTOMER; UPDATE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DELETE TABLE CUSTOMER; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL There is an equivalent join expression that can be substituted for all subquery expressions. 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 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 Find the sailor IDs of at least one sailor who have reserved red boats but not green boats ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ON UPDATE CASCADE ensures which of the following? Data Integrity Normalization All of these Materialized Views Data Integrity Normalization All of these Materialized Views ANSWER DOWNLOAD EXAMIANS APP