Winter Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: v4s65

Note! Following 1z0-067 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

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

Go to page:
Question # 4

Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (COB) plan using Oracle Database Resource Manager?

A.

maximum undo per consumer group

B.

maximum idle time for a session in a PDB

C.

parallel server limit

D.

CPU

E.

maximum number of sessions for a PDB

Full Access
Question # 5

Which two statements are true about service creation for pluggable databases (PDBs)?

A.

When a PDB is created, a service is automatically started in the instance with the same name as the PDB.

B.

The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.

C.

A database managed by Oracle Restart can have additional services created or existing services modified by using the srvctl utility for each PDB.

D.

Only a common user can create additional services for a PDB.

E.

When a PDB is created, a service with the same name as the PDB is created in the PDB.

Full Access
Question # 6

You want to create a database and you have the following:

Oracle Grid Infrastructure is installed and configured

Oracle Database Vault is installed in ORACLE_HOME to be used for this database

Oracle Enterprise Manager Cloud Control is available and an agent is deployed on the database server

Examine the requirements:

Configuring the database instance to support shared server mode

Using Automatic Storage Management (ASM) for storing database files

Configuring a naming method to help a remote user connect to a database instance

Configuring the Fast Recovery Area

Configuring Database Vault

Configuring Enterprise Manager (EM) Database Express

Registering with EM Cloud Control

Configuring remote log archive destinations

Enabling daily incremental backups

Configuring a nondefault block size for nondefault block size tablespaces

Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)?

A.

1,2,3,4,5,6,8,9, and 10

B.

1,2, 4,5,6,7, and 8

C.

1, 2, 3, 8, 9, and 10

D.

1, 2, 4, 5, 7, 8, 9, and 10

E.

1, 2, 4, 5, 6, and 7

Full Access
Question # 7

As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database.

Which step should you perform next to start the upgrade of the database?

A.

Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade.

B.

Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.

C.

Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.

D.

Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.

Full Access
Question # 8

You are administering a multitenant container database (CDB) cdb1.

Examine the command and its output:

SQL>show parameterfile

NAMETYPEVALUE

-----------------------------------------------------------------------

db_create_file_deststring

db_file_name_convertstring

db_filesinteger200

You verify that sufficient disk space is available and that no file currently exists in the ‘/u0l/app/oracle/oradata/cdb1/salesdb' location.

You plan to create a new pluggable database (PDB) by using the command:

SQL>CREATEPLUGGABLEDATABASESALESPDB

ADMINUSERsalesadmIDENTIFIED 3Y password

ROLES=(dba)

DEFAULTTABLESPACEsales

DATAFILE' /u01/app/oracle/oradata/cdb1/salesdb/sales01 .dbf’SIZE 250M AUTOEXTEND ON

FILE_NAME_CONVERT=(‘/u01/app/oracle/oradata/cdb1/pdbseed/',

'/u01/app/oracle/oradata/cdb1/salesdb/')

STORAGE(MAXSIZE2G)

PATK_PREFIX='/u01/app/oracle/oradata/cdb1/SALESPDB';

Which statement is true?

A.

SALESPDB is created and is in mount state.

B.

PDB creation fails because the D3_file_name_convert parameter is not set in the CDB.

C.

SALESPDB is created and is in read/write mode.

D.

PDB creation fails because a default temporary tablespace is not defined for SALESPDB.

Full Access
Go to page: