nerdexam
Oracle

1Z0-060 · Question #53

You created a new database using the "create database" statement without specifying the "ENABLE PLUGGABLE" clause. What are two effects of not using the "ENABLE PLUGGABLE database" clause?

The correct answer is A. The database is created as a non-CDB and can never contain a PDB. D. The database is created as a non-CDB but can be plugged into an existing CDB. A (not B,not E): The CREATE DATABASE ... ENABLE PLUGGABLE DATABASE SQL statement creates a new CDB. If you do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non-CDB and can never contain PDBs. D: You can create a PDB by plugging in a…

New Features for Database Infrastructure and Architecture

Question

You created a new database using the "create database" statement without specifying the "ENABLE PLUGGABLE" clause. What are two effects of not using the "ENABLE PLUGGABLE database" clause?

Exhibit

1Z0-060 question #53 exhibit

Options

  • AThe database is created as a non-CDB and can never contain a PDB.
  • BThe database is treated as a PDB and must be plugged into an existing multitenant container
  • CThe database is created as a non-CDB and can never be plugged into a CDB.
  • DThe database is created as a non-CDB but can be plugged into an existing CDB.
  • EThe database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in.

How the community answered

(27 responses)
  • A
    93% (25)
  • B
    4% (1)
  • E
    4% (1)

Explanation

A (not B,not E): The CREATE DATABASE ... ENABLE PLUGGABLE DATABASE SQL statement creates a new CDB. If you do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non-CDB and can never contain PDBs. D: You can create a PDB by plugging in a Non-CDB as a PDB. The following graphic depicts the options for creating a PDB: Description of cncpt358.png follows Not E:For the duration of its existence, a database is either a CDB or a non-CDB. You cannot transform a non-CDB into a CDB or vice versa. You must define a database as a CDB at creation, and then create PDBs within this CDB.

Topics

#non-CDB creation#ENABLE PLUGGABLE DATABASE#CDB architecture#plugging non-CDB

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice