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 You can add a row using SQL in a database with which of the following? INSERT MAKE CREATE ADD INSERT MAKE CREATE ADD ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to sort the result-set? ORDER SORT ORDER BY SORT BY ORDER SORT ORDER BY SORT BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The FROM SQL clause is used to... specify search condition specify range for search condition specify what table we are selecting or deleting data FROM None of these specify search condition specify range for search condition specify what table we are selecting or deleting data FROM None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is valid SQL for an Index? ADD INDEX ID; CHANGE INDEX ID; REMOVE INDEX ID; CREATE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; REMOVE INDEX ID; CREATE INDEX ID; ANSWER DOWNLOAD EXAMIANS APP