Introduction to SQL The result of a SQL SELECT statement is a ________ . table file report form table file report form ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL If a query involves NOT, AND, OR with no parenthesis NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. The order of occurrence determines the order of evaluation. 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. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. The order of occurrence determines the order of evaluation. 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. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? COMMIT TRUNCATE DELETE ROLLBACK COMMIT TRUNCATE DELETE ROLLBACK ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a valid SQL type? NUMERIC CHARACTER All of these FLOAT NUMERIC CHARACTER All of these FLOAT ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS