Question 11

DEFERRED_SEGMENT_CREATION is TRUE in one of your databases.
You execute this command:

Which three statements are true immediately after this statement executes successfully?
  • Question 12

    The HR user receives the following error while inserting data into the sales table:

    On investigation, you find that the users tablespace uses Automatic Segment Space
    Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it.
    Which two methods would you use to resolve this error?
  • Question 13

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

    You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.
    The CDB has several pluggable databases (PDBs) open in the read/write mode.
    There are ongoing transactions in both the CDB and PDBs.
    What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?
  • Question 15

    Identify three valid methods of opening, pluggable databases (PDBs).