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?
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?
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?
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?
Answer : B
Which three statements are true about Oracle Secure Backup (OSB)?
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)?
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.
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.
Answer : C
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?
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?
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?
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?
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?
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?
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?
Answer : A
Reference:http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#CEGE
JABH(to make password encrypted backups)