nerdexam
Oracle

1Z0-074 · Question #78

In your CDB1 container database, the DB_CREATE_FILE_DEST parameter is set to '/u01/app/ oracle/oradata'. CDB1 has an application container called REGIONS_APP. There are no seeds for REGIONS_APP and…

The correct answer is E. Set the PDB_FILE_NAME_CONVERT parameter to `/u01/app/oracle/oradata'. Explanation/Reference:

Managing Pluggable Databases

Question

In your CDB1 container database, the DB_CREATE_FILE_DEST parameter is set to ‘/u01/app/ oracle/oradata’. CDB1 has an application container called REGIONS_APP. There are no seeds for REGIONS_APP and there are no other application containers. You plan to execute this command. CREATE PLUGGABLE DATABASE AS SEED ADMIN USER seed_adm IDENTIFIED BY admin_123; What must you do for the command to execute successfully?

Options

  • ASet the current container to REGIONS_APP
  • BSet the current container to CDB1
  • CAdd the FILE_NAME_CONVERT clause to the command
  • DAdd the CREATE_FILE_DEST clause to the command
  • ESet the PDB_FILE_NAME_CONVERT parameter to `/u01/app/oracle/oradata'

How the community answered

(58 responses)
  • A
    3% (2)
  • B
    16% (9)
  • C
    2% (1)
  • D
    9% (5)
  • E
    71% (41)

Explanation

Explanation/Reference:

Topics

#application container seed#CREATE PLUGGABLE DATABASE#application root#PDB_FILE_NAME_CONVERT

Community Discussion

No community discussion yet for this question.

Full 1Z0-074 Practice