Introduction to SQL A subquery in an SQL SELECT statement is enclosed in: brackets -- [...]. braces -- {...}. parenthesis -- (...) . CAPITAL LETTERS. brackets -- [...]. braces -- {...}. parenthesis -- (...) . CAPITAL LETTERS. 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. 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; 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. 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; OR will be evaluated second; AND will be evaluated last. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A view is which of the following? A base table that can be accessed via SQL commands A virtual table that can be accessed via SQL commands A base table that cannot be accessed via SQL commands A virtual table that cannot be accessed via SQL commands A base table that can be accessed via SQL commands A virtual table that can be accessed via SQL commands A base table that cannot be accessed via SQL commands A virtual table that cannot be accessed via SQL commands ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? SAVE AS MODIFY SAVE UPDATE SAVE AS MODIFY SAVE UPDATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement that queries or reads data from a table is ________ . QUERY READ SELECT None of these QUERY READ SELECT None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is a view? 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. A view is a special stored procedure executed when certain event occurs. A view is a database diagram. None of these 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. A view is a special stored procedure executed when certain event occurs. A view is a database diagram. None of these ANSWER DOWNLOAD EXAMIANS APP