Introduction to SQL SQL data definition commands make up a(n) ________ . DDL HTML DML XML DDL HTML DML XML 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 IN (10000, 25000); None of these SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; Both A and B SELECT name FROM staffinfo WHERE salary IN (10000, 25000); None of these SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: ORDER BY. SORT BY. None of these GROUP BY. ORDER BY. SORT BY. None of these GROUP BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement: can always be duplicated by a join. can only be used with two tables. has a distinct form that cannot be duplicated by a join. cannot have its results sorted using ORDER BY. can always be duplicated by a join. can only be used with two tables. has a distinct form that cannot be duplicated by a join. cannot have its results sorted using ORDER BY. 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
EXAMIANS