Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints bc ab gh 23 bc ab gh 23 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement: can only be used with two tables. can always be duplicated by a join. has a distinct form that cannot be duplicated by a join. cannot have its results sorted using ORDER BY. can only be used with two tables. can always be duplicated by a join. has a distinct form that cannot be duplicated by a join. cannot have its results sorted using ORDER BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A dynamic view is one whose contents materialize when referenced. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that: None of these all columns of the table are to be returned. all records meeting the full criteria are to be returned. all records with even partial criteria met are to be returned. None of these all columns of the table are to be returned. all records meeting the full criteria are to be returned. all records with even partial criteria met are to be returned. 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 must be enclosed in double quotes? Column Alias All of these Dates Strings Column Alias All of these Dates Strings ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS