1z0-071 Practice Test

1z0-071 Practice Test practice questions, page 7 of 11, with answer review and explanations.

Question 31

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

  1. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
  2. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
  3. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
  4. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
  5. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
  6. A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.

Question 32

Which two statements are true about the SET VERIFY ON command? (Choose two.)

  1. It displays values for variables used only in the WHERE clause of a query.
  2. It displays values for variables created by the DEFINE command.
  3. It can be used only in SQL*Plus.
  4. It displays values for variables prefixed with &&.
  5. It can be used in SQL Developer and SQL*Plus.

Question 33

Examine this list of requirements for a sequence: 1. Name: EMP_SEQ 2. First value returned: 1 3. Duplicates are never permitted. 4. Provide values to be inserted into the EMPLOYEES.EMPLOYEE_ID column. 5. Reduce the chances of gaps in the values. Which two statements will satisfy these requirements? (Choose two.)

  1. CREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1 CYCLE;
  2. CREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1 CACHE;
  3. CREATE SEQUENCE emp_seq;
  4. CREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1 NOCACHE;
  5. CREATE SEQUENCE emp_seq NOCACHE;
  6. CREATE SEQUENCE emp_seq START WITH 1 CACHE;

Question 34

Which three queries execute successfully? (Choose three.)

  1. SELECT 1 - SYSDATE - DATE '2019-01-01' FROM DUAL;
  2. SELECT SYSDATE - DATE '2019-01-01' - 1 FROM DUAL;
  3. SELECT SYSDATE / DATE '2019-01-01' - 1 FROM DUAL;
  4. SELECT SYSDATE - 1 - DATE '2019-01-01' FROM DUAL;
  5. SELECT (SYSDATE - DATE '2019-01-01') / 1 FROM DUAL;
  6. SELECT 1 / SYSDATE - DATE '2019-01-01' FROM DUAL;

Question 35

Which two are true about granting object privileges on tables, views, and sequences? (Choose two.)

  1. INSERT can be granted only on tables and sequences.
  2. DELETE can be granted on tables, views, and sequences.
  3. SELECT can be granted on tables, views, and sequences.
  4. ALTER can be granted only on tables and sequences.
  5. REFERENCES can be granted only on tables.