Introduction to SQL SQL data definition commands make up a(n) ________ . DML XML HTML DDL DML XML HTML DDL ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? Non-Equijoin None of these Self-Join Equijoin Non-Equijoin None of these Self-Join Equijoin ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL You can add a row using SQL in a database with which of the following? ADD INSERT MAKE CREATE ADD INSERT MAKE CREATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s): Both IN and NOT IN. LIKE only. IN only. NOT IN only. Both IN and NOT IN. LIKE only. IN only. NOT IN only. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000? None of these Both A and B SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; SELECT name FROM staffinfo WHERE salary IN (10000, 25000); None of these Both A and B SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; SELECT name FROM staffinfo WHERE salary IN (10000, 25000); 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
EXAMIANS