Introduction to SQL Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? SUM All of these COUNT MAX SUM All of these COUNT MAX ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? LEN LEFT AVG JOIN LEN LEFT AVG JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a valid SQL type? CHARACTER FLOAT All of these NUMERIC CHARACTER FLOAT All of these NUMERIC ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the SQL statements is correct? SELECT Username, Password WHERE Username = 'user1' SELECT Username, Password FROM Users None of these SELECT Username AND Password FROM Users SELECT Username, Password WHERE Username = 'user1' SELECT Username, Password FROM Users None of these SELECT Username AND Password FROM Users 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 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 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS