Introduction to SQL A dynamic view is one whose contents materialize when referenced. True False True False 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 NON-EQUIJOIN NATURAL JOIN OUTER JOIN EQUIJOIN NON-EQUIJOIN NATURAL JOIN OUTER JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The wildcard in a WHERE clause is useful when? An exact match is necessary in a SELECT statement. An exact match is not possible in a CREATE statement. An exact match is not possible in a SELECT statement. An exact match is necessary in a CREATE statement. An exact match is necessary in a SELECT statement. An exact match is not possible in a CREATE statement. An exact match is not possible in a SELECT statement. An exact match is necessary in a CREATE statement. 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 The keyword LIKE can be used in a WHERE clause to refer to a range of values. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is illegal? SELECT SYSDATE - SYSDATE FROM DUAL; SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; None of these SELECT SYSDATE - SYSDATE FROM DUAL; SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; None of these ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS