Introduction to SQL In SQL, which command is used to change a table's storage characteristics? CHANGE TABLE None of these ALTER TABLE MODIFY TABLE CHANGE TABLE None of these ALTER TABLE MODIFY TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve only unique values? DIFFERENT DISTINCTIVE UNIQUE DISTINCT DIFFERENT DISTINCTIVE UNIQUE DISTINCT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to eliminate a table from a database is: REMOVE TABLE CUSTOMER; UPDATE TABLE CUSTOMER; DROP TABLE CUSTOMER; DELETE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; UPDATE TABLE CUSTOMER; DROP TABLE CUSTOMER; DELETE TABLE CUSTOMER; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL If a query involves NOT, AND, OR with no parenthesis NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. The order of occurrence determines the order of evaluation. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. The order of occurrence determines the order of evaluation. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is a view? None of these A view is a database diagram. A view is a special stored procedure executed when certain event occurs. A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are. None of these A view is a database diagram. A view is a special stored procedure executed when certain event occurs. A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the temperature in increasing order of all cities SELECT city, temperature FROM weather; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; SELECT city, temperature FROM weather; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS