Introduction to SQL Which SQL statement is used to delete data FROM a database? DELETE REMOVE COLLAPSE ALTER DELETE REMOVE COLLAPSE ALTER ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? INSERT UPDATE ADD APPEND INSERT UPDATE ADD APPEND 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 s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT DISTINCT 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 s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT DISTINCT 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
Introduction to SQL What is the full form of SQL? None of these Simple Query Language Structured Query List Structured Query Language None of these Simple Query Language Structured Query List Structured Query Language ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);prints 10 0 9 5 10 0 9 5 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The keyword LIKE can be used in a WHERE clause to refer to a range of values. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS