Introduction to SQL A dynamic view is one whose contents materialize when referenced. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? Self-Join Non-Equijoin Equijoin None of these Self-Join Non-Equijoin Equijoin None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; 2345 1234 6789 456789 2345 1234 6789 456789 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? COMMIT DELETE TRUNCATE ROLLBACK COMMIT DELETE TRUNCATE ROLLBACK ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement: cannot have its results sorted using ORDER BY. can always be duplicated by a join. can only be used with two tables. has a distinct form that cannot be duplicated by a join. cannot have its results sorted using ORDER BY. can always be duplicated by a join. can only be used with two tables. has a distinct form that cannot be duplicated by a join. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS