← Back to exam page

1z0-071 – Oracle Datbase 12c SQL

Loading demo links...

Showing 7–9 of 15 questions

Question 7

Which two statements are true regarding working with dates? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    The RR date format automatically calculates the century from the SYSDATE function but allows the session user to enter the century.
  • ○

    The RR date format automatically calculates the century from the SYSDATE function and does not allow a session user to enter the century.
  • ○

    The default internal storage of dates is in character format.
  • ○

    The default internal storage of dates is in numeric format.
Question 8

Examine the types and examples of relationship that follow:

1 One-to-one a) teacher to Student

2 One-to-many b) Employees to Manager

3 Many-to-one c) Person to SSN

4 Many-to-many d) Customers to Products

Which option indicates correctly matched relationships?

Select an option, then click Submit answer.

  • ○

    1-d, 2-b, 3-a, and 4-c
  • ○

    1-c, 2-d, 3-a, and 4-b
  • ○

    1-a, 2-b, 3-c, and 4-d

  • ○

    1-c, 2-a, 3-b, and 4-d

Question 9

Which statement is true about transactions?

Select an option, then click Submit answer.

  • ○

    A set of Data Manipulation Language (DML) statements executed in a sequence ending with a SAVEPOINT forms a single transaction.
  • ○

    Each Data Definition Language (DDL) statement executed forms a single transaction.
  • ○

    A set of DDL statements executed in a sequence ending with a COMMIT forms a single transaction.
  • ○

    A combination of DDL and DML statements executed in a sequence ending with a COMMIT forms a single transaction.