← Back to exam page

1z0-062 – Oracle Database 12c: Installation and Administration

Loading demo links...

Showing 16–18 of 20 questions

Question 16

Which set of statements is true about data dictionary views?

1. They are stored in the SYSTEM tablespace.

2. They are based on virtual tables.

3. They are owned by the SYS user.

4. They can be queried by a normal user only if the 07_DICTIONARY_ACCESSIBILITY parameter is set to TRUE.

5. The V$FIXED_TABLE view can be queried to list the names of these views.

6. They are owned by the SYSTEM user.

Select an option, then click Submit answer.

  • ○

    2, 5, and 6
  • ○

    1, 2, and 3
  • ○

    1 and 3
  • ○

    2, 3, 4, and 5
Question 17

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE” statement?

Select an option, then click Submit answer.

  • ○

    It will create a multitenant container database (CDB) with only the root opened.
  • ○

    It will create a CDB with root opened and seed read only.
  • ○

    It will create a CDB with root and seed opened and one PDB mounted.
  • ○

    It will create a CDB that must be plugged into an existing CDB.
  • ○

    It will create a CDB with root opened and seed mounted.
Question 18

The HR schema exists in databases, BOSTON and DENVER, with the same password, HR.

You have CREATE DATABASE LINK and CREATE SESSION privileges in both databases.

DENVER is defined as a service name in the tnsnames.ora of both databases.

You plan to use this command:

CREATE DATABASE LINK hr_link CONNECT TO hr IDENTIFIED BY hr USING ‘DENVER’;

What must be done to ensure that all users in BOSTON can access the HR schema in DENVER?

Select an option, then click Submit answer.

  • ○

    Change the command to create a public database link in BOSTON.
  • ○

    Change the command to create a public database link in DENVER.
  • ○

    Execute the command as SYS in DENVER.
  • ○

    Execute the command as SYS in BOSTON.
  • ○

    Execute the command as HR in BOSTON and SYS in DENVER.
  • ○

    Execute the command as SYS in both databases.