[Free] 2018(Jan) EnsurePass Dumpsleader Oracle 1z0-067 Dumps with VCE and PDF 61-70
Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP
Question No: 61
Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user:
SQLgt; 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?
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.
The command succeeds only if all the PDBs have the users and temp tablespaces.
The command gives an error because the container=all clause is missing.
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.
Question No: 62
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
) 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?
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.
Question No: 63
Which three statements are true about compression of backup sets?
Compressed backups can only be written to media.
Binary compression creates performance overhead during a backup operation.
Unused blocks below the high-water mark are not backed up.
Compressed backups cannot have section size defined during a backup operation
It works only for locally managed tablespaces.
Question No: 64
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:
SQLgt; ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID=#39;*#39; SCOPE=SPFILE;
Which statement is true about the result of this command?
The statistics_level parameter is set to all when anyof the PDBs is reopened.
The statistics_level parameter is set to all only for PDB2 when it is reopened.
The statistics_level parameter is set to all when the root database is restarted.
The statement is ignored because there is no SPFILE for a PDB.
Question No: 65
Which three statements are true about Oracle Secure Backup (OSB)?
It can encrypt client data written to tape.
It can be used to take image copy backups to tape.
It can be used to manage tape backup and restore operations for multiple databases.
It can be used along with an RMAN recovery catalog for maintaining records of backups in a tape library.
It can be used to perform file system backups at the file, directory, file system, or raw partition level.
Question No: 66
Which two methods can be used toadd an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)?
Use the d3MS_pdb package to plug the Oracle 11g database into the existing CDB as a PDB.
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.
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.
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.
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.
Question No: 67
Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:
Create a policy to capture the privileges used by a user for privilege analysis.
Generate a report with the data captured for a specified privilege capture. 3.Start analyzing the data captured by the policy.
Revoke the unused privileges.
Compare the used and unused privileges#39; lists.
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
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.
Question No: 68
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:
Place all the user-defined tablespace in read-only mode on the source database.
Upgrade the source database to a 12c version.
Create a new PDB in the target container database.
Perform a full transportable export on the source database withthe VERSION parameter set to 12 using the expdp utility.
Copy the associated data files and export the dump file to the desired location in the target database.
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.
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
Question No: 69
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?
By default, EM express is available for a database after database creation.
You can use EM express to manage multiple databases running on the same server.
You can perform basic administrative tasks for pluggable databases by using the EM express interface.
You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.
You can create and configure pluggable databases by using EM express.
Explanation: EM Express is built inside the database.
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.
Question No: 70
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?
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.
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.
Start up the database instance by using theSTARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.
Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|