1z0-071 Practice Test practice questions, page 2 of 11, with answer review and explanations.
Question 6
Which two are true? (Choose two.)
CONCAT joins two character strings together.
CONCAT joins two or more character strings together.
FLOOR returns the largest positive integer less than or equal to a specified number.
INSTR finds the offset within a character string, starting from position 0.
INSTR finds the offset within a string of a single character only.
FLOOR returns the largest integer less than or equal to a specified number.
Question 7
Examine these SQL statements which execute successfully: Which two statements are true after execution? (Choose two.)
The primary key constraint will be enabled and IMMEDIATE.
The foreign key constraint will be enabled and DEFERRED.
The primary key constraint will be enabled and DEFERRED.
The foreign key constraint will be disabled.
The foreign key constraint will be enabled and IMMEDIATE.
Question 8
Examine this SQL statement: Which two are true? (Choose two.)
All existing rows in the ORDERS table are updated.
The subquery is executed before the UPDATE statement is executed.
The subquery is not a correlated subquery.
The subquery is executed for every updated row in the ORDERS table.
The UPDATE statement executes successfully even if the subquery selects multiple rows.
Question 9
Which two statements are true about TRUNCATE and DELETE? (Choose two.)
DELETE can use a WHERE clause to determine which row(s) should be removed.
TRUNCATE can use a WHERE clause to determine which row(s) should be removed.
TRUNCATE leaves any indexes on the table in an UNUSABLE state.
The result of a TRUNCATE can be undone by issuing a ROLLBACK.
The result of a DELETE can be undone by issuing a ROLLBACK.
Question 10
The STORES table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE is within the last 25 months. Which WHERE clause can be used?