Introduction to SQL The wildcard in a WHERE clause is useful when? An exact match is necessary in a CREATE statement. An exact match is necessary in a SELECT statement. An exact match is not possible in a SELECT statement. An exact match is not possible in a CREATE statement. An exact match is necessary in a CREATE statement. An exact match is necessary in a SELECT statement. An exact match is not possible in a SELECT statement. An exact match is not possible in a CREATE statement. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement that queries or reads data from a table is ________ . QUERY SELECT None of these READ QUERY SELECT None of these READ ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to remove rows from a table 'CUSTOMER' is: UPDATE FROM CUSTOMER ... REMOVE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... DROP FROM CUSTOMER ... UPDATE FROM CUSTOMER ... REMOVE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... DROP FROM CUSTOMER ... ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that: all records meeting the full criteria are to be returned. None of these all columns of the table are to be returned. all records with even partial criteria met are to be returned. all records meeting the full criteria are to be returned. None of these all columns of the table are to be returned. all records with even partial criteria met are to be returned. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL You can add a row using SQL in a database with which of the following? ADD MAKE CREATE INSERT ADD MAKE CREATE INSERT 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 all sailors 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 at least one sailor who have reserved red boats but not green boats None of These Find the sailor IDs of all sailors 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 at least one sailor who have reserved red boats but not green boats None of These ANSWER DOWNLOAD EXAMIANS APP