Introduction to SQL Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ............. joins two or more tables based on a specified column value not equaling a specified column value in another table. EQUIJOIN NATURAL JOIN NON-EQUIJOIN OUTER JOIN EQUIJOIN NATURAL JOIN NON-EQUIJOIN OUTER JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? MODIFY UPDATE SAVE AS SAVE MODIFY UPDATE SAVE AS SAVE 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 columns of the table are to be returned. all records meeting the full criteria are to be returned. all records with even partial criteria met are to be returned. None of these all columns of the table are to be returned. all records meeting the full criteria are to be returned. all records with even partial criteria met are to be returned. None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query finds the names of the sailors who have reserved at least one boat? SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; None of These SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; None of These SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS