Introduction to SQL SQL data definition commands make up a(n) ________ . DDL XML HTML DML DDL XML HTML DML ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Most companies keep at least two versions of any database they are using. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL If a query involves NOT, AND, OR with no parenthesis The order of occurrence determines the order of evaluation. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. The order of occurrence determines the order of evaluation. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ............. joins two or more tables based on a specified column value not equaling a specified column value in another table. EQUIJOIN NATURAL JOIN NON-EQUIJOIN OUTER JOIN EQUIJOIN NATURAL JOIN NON-EQUIJOIN OUTER JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword BETWEEN is used: as a wildcard. None of these for ranges. to limit the columns displayed. as a wildcard. None of these for ranges. to limit the columns displayed. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to eliminate a table from a database is: UPDATE TABLE CUSTOMER; DROP TABLE CUSTOMER; DELETE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; UPDATE TABLE CUSTOMER; DROP TABLE CUSTOMER; DELETE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS