Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP v7.0 (1z0-067)

Page:    1 / 12   
Total 175 questions

Your multitenant container database (CDB) contains multiple pluggable databases (PDBs).
You execute the command to create a common user:

SQL> CREATE USER c##a_admin -

IDENTIFIED BY password -

DEFAULT TABLESPACE users -

QUOTA I00M ON users -
TEMPORARY TABLESPACE temp;
Which statement is true about the execution of the command?

  • A. The common user is created in the CDB and all the PDBs, and uses the users and temp tablespaces of the CDB to store schema objects.
  • B. The command succeeds only if all the PDBs have the users and temp tablespaces.
  • C. The command gives an error because the container=all clause is missing.
  • D. The commandsucceeds and sets the default permanent tablespace of a PDB as the default tablespace for the c##a_admin user if the users tabiespace does not exist in that PDB.


Answer : B

You must unload data from the orders, order_items, and products database tables to four filesusing the External Tables.

CREATE TABLE orders_ext -
(order_id, order_date, product_id, product_name,quantity)

ORGANIZATION EXTERNAL -

TYPE ORACLE_DATAPUMP -

DEFAULT DIRECTORY ext.dir -
LOCATION (ordersl.dmp','orders2.dmp,orders3.dmp,lorders4.dmp')

PARALLEL -

AS -
SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity
FROM orders o,productsp,order_itemsi
WHERE o.orderjd = i.order_id and i.product_id = p.product_id;
You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created?

  • A. TYPE
  • B. LOCATION
  • C. PARALLEL
  • D. DEFAULT DIRECTORY
  • E. ORGANIZATION EXTERNAL


Answer : C

Explanation: Parallel Loading and UnloadingThe dump file must be on a disk big enough to hold all the data being written. If there is insufficient space for all of the data, then an error is returned for the CREATE TABLE AS SELECT statement. One way to alleviate the problem is to create multiple files in multiple directory objects (assuming those directories are on different disks) when executing the CREATE TABLE AS SELECT statement.
Multiple files can be created by specifying multiple locations in the form directory:file in the
LOCATION clause and by specifying the PARALLEL clause. Each parallel I/O server process that is created to populate the external table writes to its own file. The number of files in the LOCATION clause should match the degree of parallelization because each I/O server process requires its own files. Any extra files that are specified will be ignored. If there are not enough files for the degree of parallelization specified, then the degree of parallelization is lowered to match the number of files in the LOCATION clause.

Which three statements are true about compression of backup sets?

  • A. Compressed backups can only be written to media.
  • B. Binary compression creates performance overhead during a backup operation.
  • C. Unused blocks below the high-water mark are not backed up.
  • D. Compressed backups cannot have section size defined during a backup operation
  • E. It works only for locally managed tablespaces.


Answer : B,C,E

You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with
DBA privileges.
The statistics_level parameter isPDB modifiable.
As the user sys, execute the following command on pdb2:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;
Which statement is true about the result of this command?

  • A. The statistics_level parameter is set to all when anyof the PDBs is reopened.
  • B. The statistics_level parameter is set to all only for PDB2 when it is reopened.
  • C. The statistics_level parameter is set to all when the root database is restarted.
  • D. The statement is ignored because there is no SPFILE for a PDB.


Answer : B

Which three statements are true about Oracle Secure Backup (OSB)?

  • A. It can encrypt client data written to tape.
  • B. It can be used to take image copy backups to tape.
  • C. It can be used to manage tape backup and restore operations for multiple databases.
  • D. It can be used along with an RMAN recovery catalog for maintaining records of backups in a tape library.
  • E. It can be used to perform file system backups at the file, directory, file system, or raw partition level.


Answer : A,C,E

Which two methods can be used toadd an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)?

  • A. Use the d3MS_pdb package to plug the Oracle 11g database into the existing CDB as a PDB.
  • B. Use the create database ... enable pluggable database statement to create a PDB by copying data files from pd3Sseed and use data pump to load data from the Oracle 11g database into the newly created PDB.
  • C. Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB.
  • D. Pre-create a PDB in CDB and use the network_link and parallel parameters with data pump import to import data from the Oracle 11g database to the newly created PDB.
  • E. Upgrade the Oracle 11g database to a 12c non-CDB and use the dbms_pdb.describe procedure to plug the database as a new PDB into the CDB.


Answer : B,E

Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:
1. Create a policy to capture the privileges used by a user for privilege analysis.
2. Generate a report with the data captured for a specified privilege capture.
3.Start analyzing the data captured by the policy.
4.Revoke the unused privileges.
5. Compare the used and unused privileges' lists.
6. Stop analyzing the data.
Identify the correct sequence of steps.

  • A. 1, 3, 5, 6, 2, 4
  • B. 1, 3, 6, 2, 5, 4
  • C. 1, 3, 2, 5, 6, 4
  • D. 1, 3, 5, 2, 6, 4


Answer : B

Explanation: 1. Create a policy to capture the privilege used by a user for privilege analysis.
3. Start analyzing the data captured by the policy.
6. Stop analyzing the data.
2. Generate a report with the data captured for a specified privilege capture.
5. Compare the used and unused privileges lists.
4. Revoke the unused privileges.

You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database withthe VERSION parameter set to 12 using the expdp utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the
DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the
DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.

  • A. 2, 1, 3, 4, 5, 6
  • B. 1, 3, 4, 5, 6, 7
  • C. 1, 4, 3, 5, 6, 7
  • D. 2, 1, 3, 4, 5, 6, 7
  • E. 1, 5, 6, 4, 3, 2


Answer : C

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

  • A. By default, EM express is available for a database after database creation.
  • B. You can use EM express to manage multiple databases running on the same server.
  • C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
  • D. You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.
  • E. You can create and configure pluggable databases by using EM express.


Answer : A

Explanation: EM Express is built inside the database.
Note:
Oracle Enterprise Manager Database Express (EM Express) is a web-based database management tool that is built inside the Oracle Database. It supports key performance management and basicdatabase administration functions. From an architectural perspective, EM Express has no mid-tier or middleware components, ensuring that its overhead on the database server is negligible.

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 duringthe 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 theSTARTUP 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.


Answer : C

In your multitenant container database (CDB) that contains pluggable databases (PDBs), the hr user executes the following commands to create and grant privileges on a procedure:
CREATEORREPLACEPROCEDUREcreate_test_v(v_emp_idNUMBER,v_enameVARCHA
R2,v_SALARYNUMBER,v_dept_idNUMBER)

BEGIN -
INSERT INTO hr.test VALUES (v_emp_id, v_ename, v salary, v_dept_id);
END;
GRANT EXECUTE ON CREATE_TEST TO John, jim, smith, king;
How can you prevent users having the execute privilege on the create_test_v procedure frominserting values into tables on which they do not have any privileges?

  • A. Create the create_test procedure with definer's rights.
  • B. Grant the execute privilege to users with grant option on the create_test procedure.
  • C. Create the create_test procedure with invoker's rights.
  • D. Create the create_test procedure as part of a package and grant users the execute privilege on the package.


Answer : C

You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:
$ . oraenv

ORACLE-_SID = [oracle] ? cdb1 -
The oraclebasefor ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is
/u01/app/oracle
$ rman target /
Recovery Manager : Release 12.1.0.0.2 - production on Fri Ju1 19 05:18:33: 2013
Coppyright (c) 1982, 2013, oracle and/or its affiliates. All rights reserved.
Connected to target database:CDB1 (DBID=782249327)
RMAN>SELECT name FROMv$tablespace;
Which statement is true about the execution of the last command?

  • A. It succeeds and displays all the tablespaces that belong to the root database.
  • B. It fails and returns an error because a connection is not made by using the sysdba privilege.
  • C. It succeeds and displays all the tablespaces that belong to the root and pluggable databases.
  • D. It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.


Answer : A

The CATDB12C database contains an Oracle Database 12c catalog schema owned by the rci2c user.
The CATD3H database contains an Oracle Database Ug catalog schema owned by the rch user.
A database with dbid=H2324I is registered in the catdbII catalog. Both the recovery catalog databases are open.
In the CATD3i2c database, you execute the commands:
: r-ar.
RKAN> CONNECT CATALOG rci2c/passI2c@catdbi2c
RKAN> IMPORT CATALOG rcii/pwdcatUQcatdfoil DBI2=142324i;
What is the outcome of the import?

  • A. It fails because the target database and recovery catalog database are of different versions.
  • B. It succeeds and all global scripts in the rci: catalog that have the same name as existing global scripts in the RCI2C catalog are automatically renamed.
  • C. It succeeds but the database is not automatically registered in the rc:2c catalog.
  • D. It fails because RMAN is not connected to the target database with r3:T=:42324:.


Answer : B

You notice a performance change in your production Oracle 12c database. You want to knowwhich change caused this performance difference.
Which method or feature should you use?

  • A. Compare Period ADDM report
  • B. AWR Compare Period report
  • C. Active Session History (ASH) report
  • D. taking a new snapshot and comparing it with a preserved snapshot


Answer : A

Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIEDBY <password> ON FOR ALL TABLESPACES;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which type of encryption is used for the backup performed by using this command?

  • A. password-mode encryption
  • B. dual-mode encryption
  • C. transparent encryption
  • D. default encryption


Answer : A

Reference:http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#CEGE
JABH(to make password encrypted backups)

Page:    1 / 12   
Total 175 questions