Introduction to SQL What is the meaning of LIKE '%0%0%' Feature ends with two 0's Feature has more than two 0's Feature has two 0's in it, at any position Feature begins with two 0's Feature ends with two 0's Feature has more than two 0's Feature has two 0's in it, at any position Feature begins with two 0's ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which one of the following sorts rows in SQL? SORT BY ALIGN BY ORDER BY GROUP BY SORT BY ALIGN BY ORDER BY GROUP BY 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, reserves 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 s, reserves r WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors, reserves 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 s, reserves r WHERE s.sid = r.sid; 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. NON-EQUIJOIN NATURAL JOIN EQUIJOIN OUTER JOIN NON-EQUIJOIN NATURAL JOIN EQUIJOIN OUTER JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. SINGLE ONLY UNIQUE DISTINCT SINGLE ONLY UNIQUE DISTINCT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements. True False True False ANSWER DOWNLOAD EXAMIANS APP