← Back to exam page

1z0-067 – Upgrade Oracle9i/10g/11g OCA OR OCP to Oracle Database 12c OCP

Loading demo links...

Showing 10–12 of 15 questions

Question 10

You created a database with DBCA by using one of the Oracle supplied templates.

Which is the default permanent tablespace for all users except DBSNMP and OUTLN?

Select an option, then click Submit answer.

  • ○

    USERS
  • ○

    SYSTEM
  • ○

    SYSAUX
  • ○

    EXAMPLE
Question 11

Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):

SQL> CREATE ROLE c ##role1 CONTAINER-ALL;

SQL> GRANT CREATE SESSION, CREATE TABLE TO c##role1 CONTAINER=ALL;

SQL>CREATE USER c##admin IDENTIFIED BY orcl123;

SQL>GRANT c##role1 TO c##admin CONTAINER=ALL;

SQL> GRANT SELECT ON DBA_USERS to c##role1 CONTAINER=ALL;

Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1role?

Select an option, then click Submit answer.

  • ○

    The command fails and gives an error because object privileges cannot be granted to a common user.
  • ○

    The command fails because container is not set to current.
  • ○

    The command succeeds and the common user c##admin can create a session and query the DBA_users view in CDB$ROOT and all the PDBs.
  • ○

    The command succeeds and the common user c##admin can create a session in CDB$ROOT and all the PDBs, but can only query the dba_users view in CDB$ROOT
  • ○

    The command succeeds and the common user c##admin can create a session and query the DBA users view only in CDB$ROOT
Question 12

A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.

Which table organization allows for generating the bills with minimum degree of row sorting?

Select an option, then click Submit answer.

  • ○

    a hash cluster
  • ○

    an index cluster
  • ○

    a partitioned table
  • ○

    a sorted hash cluster
  • ○

    a heap table with a rowid column