Introduction to SQL When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s): NOT IN only. LIKE only. Both IN and NOT IN. IN only. NOT IN only. LIKE only. Both IN and NOT IN. IN only. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to eliminate a table from a database is: UPDATE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DELETE TABLE CUSTOMER; DROP TABLE CUSTOMER; UPDATE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DELETE TABLE CUSTOMER; DROP TABLE CUSTOMER; 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? 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); None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Select the right statement to insert values to the student table. INSERT INTO student VALUES ( INSERT student VALUES ( INSERT VALUES ( INSERT VALUES INTO student ( INSERT INTO student VALUES ( INSERT student VALUES ( INSERT VALUES ( INSERT VALUES INTO student ( ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to remove rows from a table 'CUSTOMER' is: DELETE FROM CUSTOMER WHERE ... DROP FROM CUSTOMER ... REMOVE FROM CUSTOMER ... UPDATE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... DROP FROM CUSTOMER ... REMOVE FROM CUSTOMER ... UPDATE FROM CUSTOMER ... ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS