NEW QUESTION 1
Examine the RMAN command:
RMAN> BACKUP VALIDATE DATABASE;
Which statement is true about the execution of the command?

• A. Block change tracking must be enabled before executing this command.
• B. The database must be running in ARCHIVELOG mode for the successful execution of this command.
• C. A complete database backup must exist before executing this command.
• D. The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header.
• E. The command checks for blocks that contain a valid checksum and matching headers and footers, but that has logically inconsistent contents.

Answer: D

NEW QUESTION 2
Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):

Which statement is true about granting the SELECT privilege on the DBA_USERS view to the c##ROLE1 role?

• A. The command fails and gives an error because object privileges cannot be granted to a common user.
• B. The command fails because CONTAINER is not set to CURRENT.
• C. The command succeeds and the common user C##ADMIN can create a session and query the DBA_USERS view in CDB$ROOT and all the PDBs.
• D. The command succeeds and the common user C##ADMIN can create a session in CDB$ROOT and all the PDBs, but can only query the DBA_USERS view in CDB$ROOT.
• E. The command succeeds and the common user C##ADMIN can create a session and query the DBA_USERS view only in CDB$ROOT.

Answer: C

NEW QUESTION 3
A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.
Which table organization allows for generating the bills with minimum degree of row sorting?

• A. a hash cluster
• B. an index cluster
• C. a partitioned table
• D. a sorted hash cluster
• E. a heap table with a rowid column

Answer: D

NEW QUESTION 4
You are administering a multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode and contains pluggable databases (PDBs), PDB_1 and PDB_2.
While opening PDB_1, you get an error: SQL> alter pluggable database pdb_1 open;
ORA-01157: cannot identify/lock data file 11-see DBWR trace file
ORA-01110: data file 11: '/u01/app/oracle/oradata/cdb1/pcb_1/example01.dbf'
To repair the failure, you open an RMAN session for the target database CDB$ROOT. You execute the following as the first command:
RMAN> REPAIR FAILURE;
Which statement describes the consequence of the command?

• A. The command performs the recovery and closes the failure.
• B. The command produces an error because RMAN is not connected to the target database PDB_1.
• C. The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command.
• D. The command executes successfully, performs recovery, and opens PDB_1.

Answer: C

NEW QUESTION 5
Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.)

• A. If no PDB plan is enabled for a pluggable database, all sessions for that PDB are treated to an equal share of resources.
• B. To enable a resource plan for a PDB, a CDB resource plan must be created and enabled.
• C. If a PDB plan is enabled for a pluggable database, Resource Manager uses the resource allocation at the PDB level and ignores the limits set at the CDB level.
• D. If no PDB plan is enabled for a pluggable database, the PDB uses the CDB plan.
• E. If a PDB plan is enabled for a pluggable database, resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Answer: AE

Explanation: A: ACDB resource plan determines the amount of resources allocated to each PDB. A PDB resource plan determines how the resources allocated to a specific PDB are allocated to consumer groups within that PDB.
Resource Manager allocates the resources in two steps:
E: A PDB resource plan allocates resource among the consumer groups within a PDB. References: https://docs.oracle.com/database/121/ADMIN/cdb_dbrm.htm

NEW QUESTION 6
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:
CREATE OR REPLACE PROCEDURE create_test_v(v_emp_idNUMBER,v_enameVARCHAR2, 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 from inserting 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

NEW QUESTION 7
Examine the command to duplicate a database: RMAN> DUPLICATE TARGET DATABASE TO cdb PLUGGABLE DATABASE pdb1, pdb5;
Which two statements are true about the DUPLICATE command? (Choose two.)

• A. The SPFILE is copied along with the data files of the pluggable databases (PDBs).
• B. A backup of pdb1 and pdb5 must exist before executing the command.
• C. The DUPLICATE command first creates a backup, and then duplicates the PDBs by using the backup.
• D. The root and the seed database in the container database (CDB) are also duplicated.
• E. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

Answer: BD

NEW QUESTION 8
Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)? (Choose two.)

• A. Use the DBMS_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 PDB$SEED 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: DE

NEW QUESTION 9
You are administering a multitenant container database (CDB).
Identify two ways to access a pluggable database (PDB) that is open in read-only mode. (Choose two.)

• A. by using the CONNECT statement as a local user having only the SET CONTAINER privilege
• B. by using easy connect
• C. by using external authentication
• D. as a common user with the SET CONTAINER privilege
• E. by executing the ALTER SESSION SET CONTAINER command as a local user

Answer: BD

NEW QUESTION 10
The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to
/u01/app/oracle/product/12.1.0/db 1.
You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database.
NAME TYPE VALUE
---------------- ------------------- -------------------
audit_file_dest string /u01/app/oracle/admin/eml2rep/adump background_dump_dest string
core_dump_dest string db_create_file_dest string
db_recovery_file_dest string /u01/app/oracle/fast_recovery_area diagnostic_dest string
What is the location of the ADR base?

• A. It is set to /u01/app/oracle/product:/12.1.0/db_1/log.
• B. It is set to /u01/app/oracle/admin/enl2r&p/adump.
• C. It is set to /u01/app/oracle.
• D. It is set to /u01/app/oracle/flash_recovery_area.

Answer: C

NEW QUESTION 11
Which two statements are true about tablespaces in multitenant container databases (CDBs)? (Choose two.)

• A. Default permanent tablespaces can be shared across pluggable databases (PDBs).
• B. The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.
• C. Each PDB can have its own default temporary tablespace.
• D. The default permanent tablespace for a PDB can be changed only by a local user with the required permissions.
• E. The amount of space that each PDB can use in a shared temporary tablespace must be set at the CDB level.

Answer: BC

NEW QUESTION 12
You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command.
Which two statements are true about the dependent objects of the CUSTOMERS table? (Choose two.)

• A. Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.
• B. All the constraints defined on the table, except the referential integrity constraints, are flashed back.
• C. All the triggers associated with the table are flashed back but are disabled.
• D. Materialized views that use the CUSTOMERS table are flashed back.
• E. LOB segments associated with the CUSTOMERS table are flashed back.

Answer: BE

Explanation: B: Oracle Database retrieves all indexes defined on the table except for bitmap join indexes, and all triggers and constraints defined on the table except for referential integrity constraints that reference other tables.

NEW QUESTION 13
Your database is running in archivelog mode. Examine the parameters for your database instance: LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY'
LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 ='LOCATIO=/disk3/arch' LOG_ARCHIVE_DEST _4 ='LOCATIONs/disk4/arch' LOG_ARCHIVE _MIN_SUCCEED_DEST = 2
While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used.
What happens at the next log switch?

• A. The database instance hangs and the redo log files are not overwritten.
• B. The archived redo log files are written to the fast recovery area until the mandatory destination is made available.
• C. The database instance is shutdown immediately.
• D. The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

Answer: D

NEW QUESTION 14
Which three statements are true about a job chain? (Choose three.)

• A. It can contain a nested chain of jobs.
• B. It can be used to implement dependency-based scheduling.
• C. It cannot invoke the same program or nested chain in multiple steps in the chain.
• D. It cannot have more than one dependency.
• E. It can be executed using event-based or time-based schedules.

Answer: ABE

NEW QUESTION 15
The CATDB12C database contains an Oracle Database 12c catalog schema owned by the RC12C user. The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user.
A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases are open.
In the CATDB12c database, you execute the commands:

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 RC11 catalog that have the same name as existing global scripts in the RC12C catalog are automatically renamed.
• C. It succeeds but the database is not automatically registered in the RC12c catalog.
• D. It fails because RMAN is not connected to the target database with DBID=1423241.

Answer: A

NEW QUESTION 16
Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.)

• A. You cannot export data from a remote database.
• B. You can rename tables during import.
• C. You can overwrite existing dump files during export.
• D. You can compress data but not metadata during export.

Answer: BC

NEW QUESTION 17
Your database supports an OLTP workload. Examine the output of the query:

To ensure faster instance recovery, you set the FAST_START_MTTR_TARGET initialization parameter to 30.
What is the effect of this setting on the database?

• A. Automatic checkpoint tuning is disabled.
• B. The frequency of log switches is increased.
• C. The overhead on database performance is increased because of frequent writes to disk.
• D. The MTTR advisor is disabled.

Answer: C

NEW QUESTION 18
Your database supports a Decision Support System (DSS) workload that involves the execution of complex
queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

• A. SQL Performance Analyzer
• B. SQL Access Advisor
• C. SQL Tuning Advisor
• D. Automatic Workload Repository (AWR) report
• E. Automatic Database Diagnostic Monitor (ADDM)

Answer: B

NEW QUESTION 19
Examine the RMAN commands executed in your database: RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET; RKAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
You issue the command:
RMAN> BACKUP DATABASE;
Which two statements are true about the command? (Choose two.)

• A. It performs a log switch.
• B. It creates compressed backup sets by using binary compression by default.
• C. It backs up only the used blocks in data files.
• D. It backs up data files, the control file, and the server parameter file.
• E. It creates a backup of only the control file whenever the database undergoes a structural change.

Answer: CD