NEW QUESTION 1
You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs).
You have already created a test system to support the consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.
What is the easiest way to perform capacity planning for consolidation?

• A. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Performance Analyzer on the test system
• B. capturing the workload on the production system and replaying the workload for one PDB at a time on the test system
• C. capturing the workload on the production system and using Consolidated Database Replay to replay the workload of all production systems simultaneously for all PDBs
• D. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Tuning Advisor on the test system

Answer: C

Explanation:
Reference: https://docs.oracle.com/database/121/RATUG/GUID-29988B63-F974-46EF-9AAD- 3D04AF774337.htm#RATUG4122

NEW QUESTION 2
You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). RMAN is connected to CDB$ROOT.
Examine the command: RMAN> LIST FAILURE;
Which statement is true about this command?

• A. It lists failures only if RMAN is connected to a PDB.
• B. It lists failures for the CDB and all the PDBs in this CDB.
• C. It lists failures for a PDB only when RMAN is connected to a recovery catalog.
• D. It lists failures only for the CDB root databas

Answer: B

NEW QUESTION 3
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 tablespace

Answer: BCE

Explanation:

https://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta009.htm#i1015382 “RMAN also skips other datafile blocks that do not currently contain data, if all of the following
conditions apply: The COMPATIBLE initialization parameter is set to 10.2 There are currently no guaranteed restore points defined for the database The datafile is locally managed The datafile is being backed up to a backup set as part of a full backup or a level 0 incremental backup The backup set is being created on disk.

NEW QUESTION 4
You are administering a database that supports data warehousing workload and Is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
You want to recover the data file.
Examine the steps involved in the recovery process: 1.Shut down the database instance.
2.Start up the database instance in nomount state. 3.Mount the database.
4.Take the data file offline. 5.Put the data file online. 6.Restore the control file. 7.Restore the database. 8.Restore the data file.
9.Open the database with the resetlog option. 10.Recover the database with the noredo option.
11. Recover the data file with the noredo option. Identify the required steps in the correct order.

• A. 4, 8, 11, 5
• B. 1, 3, 8, 11, 9
• C. 1, 2, 6, 3, 7, 10, 9
• D. 1, 3, 7, 10, 9
• E. 1, 2, 6, 3, 8, 11, 9

Answer: C

NEW QUESTION 5
You wish to enable an audit policy for all database users, except sys, system, and scott. You issue the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?

• A. all users except sys
• B. all users except scott
• C. all users except sys and scott
• D. all users except sys, system, and scott

Answer: B

NEW QUESTION 6
For which three pieces of information can you use the RMAN list command?

• A. stored scripts in the recovery catalog
• B. available archived redo log files
• C. backup sets and image copies that are obsolete
• D. backups of tablespaces
• E. backups that are marked obsolete according to the current retention policy

Answer: ABD

Explanation:
About the LIST Command: The primary purpose of the LIST command is to list backup and copies. For example, you can list: -Backups and proxy copies of a database, tablespace, datafile, archived redo
log, or control file -Backups that have expired -Backups restricted by time, path name, device type, tag, or recoverability -Archived redo log files and disk copies http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmreprt.htm#BRADV89585

NEW QUESTION 7
Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB hr_pdb, the common user c##admin and the local user b_admin have only the connect privilege.
You create a common role c##role1 with the create table and select any table privileges. You then execute the commands:
SQL> GRANTc##role1 TOcMadmin CONTAINER=ALL;
SQL>CONNsys/oracle@HR_PDB assysdba
SQL> GRANTc##role1TO b_admin CONTAINER=CURRENT;
Which two statements are true?

• A. C##admin can create and select any table, and grant the c##role1 role to users only in the root container.
• B. B_admin can create and select any table in both the root container and kr_pdb.
• C. c##admin can create and select any table in the root container and all the PDBs.
• D. B_admin can create and select any table only in hr_pdb.
• E. The grant c=»role1 to b_admin command returns an error because container should be set to AL

Answer: CD

NEW QUESTION 8
What two are the prerequisites for enabling Flashback Database?

• A. The database must be in ARCHIVELOG mode
• B. The database must be in MOUNT EXCLUSIVE mode
• C. The database must be opened in RESTRICTED mode
• D. The database instance must be started in the NOMOUNT state
• E. The database instance must have the keep buffer pool defined

Answer: AB

NEW QUESTION 9
During the day, your database must support an OLTP workload that requires a large database buffer cache. At night, it must support batch jobs that require a higher value to be set for large pool.
What must you do to allow the memory pools to change size automatically as required? (Choose the best answer.)

• A. Enable AMM and set the SGA_TARGET initialization parameter to a nonzero value.
• B. Enable AMM and set the PRE_PAGE_SGA initialization to TRUE.
• C. Enable Automatic Memory Management (AMM) and set the PGA_TARGET initialization parameter to a nonzero value.
• D. Enable AMM and set the PGA_TARGET initialization parameter to a nonzero valu

Answer: B

NEW QUESTION 10
The CATDBI2c 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: Srman
RMAN> CONNECT CATALOG rc12c/pass12c@catdbI2c
RMAN> IMPOST CATALOG rc1l/pwdcatl11@catdbl1 DBID=I423241; 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

Explanation:
The version of the source recovery catalog schema must be equal to the current version of the destination recovery catalog schem
A. If they are not equal, then upgrade the schemas to the same version.
https://docs.oracle.com/database/121/RCMRF/rcmsynta026.htm#RCMRF198

NEW QUESTION 11
You want to back up a database such that only formatted blocks are backed up. Which statement is
true about this backup operation?

• A. The backup must be performed in mount state.
• B. The tablespace must be taken offline.
• C. All files must be backed up as backup sets.
• D. The database must be backed up as an image cop

Answer: A

Explanation:
If you run multiple AUDIT statements on the same unified audit policy but specify different EXCEPT users, then Oracle Database uses the last exception user list, not any of the users from the preceding lists. This means the effect of the earlier AUDIT POLICY ... EXCEPT statements are overridden by the latest AUDIT POLICY ... EXCEPT statement https://docs.oracle.com/database/121/DBSEG/audit_config.htm#DBSEG459

NEW QUESTION 12
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 PD

Answer: AC

NEW QUESTION 13
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: ACE

Explanation:
File system backups may be performed at the file, directory, file system or raw partition level with full, incremental and offsite backup scheduling. As backup needs grow requiring more tape drives and centralized backup management of multiple servers, Oracle Secure Backup XE can be easily upgraded to the Oracle Secure Backup edition. http://www.oracle.com/technetwork/products/secure-backup/learnmore/osb-xe-10-130649.pdf

NEW QUESTION 14
Which two statements are true about a common user?

• A. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.
• B. A common user with the create user privilege can create other common users, as well as local users.
• C. A common user can be granted only a common role.
• D. A common user can have a local schema in a PDB.
• E. A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.

Answer: BD

NEW QUESTION 15
The CATDB12c database contains an Oracle Database version 12c catalog schema owned by the RC12C user.
The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open.
You execute the RMAN commands:
RMAN> CONNECT CATALOG rc12c/pass12c@catdb12c RMAN> IMPORT CATALOG rc11/pwdcat11@ract11
Which two tasks are performed as part of the import? (Choose two.)

• A. All databases registered in the RC11 catalog are registered in the RC12C catalog.
• B. Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.
• C. Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.
• D. Imported databases are unregistered from the RC11 catalog.
• E. Recovery catalog is resynchronized with the control files of the registered database

Answer: AD

NEW QUESTION 16
Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time.
Examine the steps to recover this table from an RMAN backup:
1. Determine which backup contains the table that needs to be recovered.
2. Issue the recover table RMAN command with an auxiliary destination defined and the point in time specified.
3. Import the Data Pump export dump file into the auxiliary instance.
4. Create a Data Pump export dump file that contains the recovered table on a target database. Identify the required steps in the correct order.

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

Answer: D

Explanation:
Because according to oracle PDFs if you run restore table ... auxiliary a impede and rename can be included. So there is no reason to make the import manually if it can be already included in step 2. https://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV689

NEW QUESTION 17
Which three RMAN persistent settings can be set for a database?

• A. backup retention policy
• B. default backup device type
• C. default section size for backups
• D. default destinations for backups
• E. multiple backup device types for a single backup

Answer: ABD

Explanation:
http://docs.oracle.com/cd/B19306_01/backup.102/b14192/setup004.htm#i1019739 To simplify
ongoing use of RMAN, you can set several persistent configuration settings for each target database. These settings control many aspects of RMAN behavior. For example, you can configure the backup retention policy, default destinations for backups, default backup device type, and so on. You can use the SHOW and CONFIGURE commands to view and change RMAN configurations.

NEW QUESTION 18
Which three statements are true about persistent lightweight jobs?

• A. A user cannot set privileges on them.
• B. They generate large amounts of metadata.
• C. They may be created as fully self-contained jobs.
• D. They must reference an existing Scheduler Program.
• E. The are useful when users need to create a large number of jobs quickl

Answer: ADE

Explanation:
Unlike regular jobs, they are not schema objects. Because lightweight jobs are not schema objects, you cannot grant privileges on them. A lightweight job inherits privileges from its specified program. Thus, any user who has a certain set of privileges on the program has corresponding privileges on the lightweight job. Use lightweight jobs when you have many short-duration jobs that run frequently. Under certain circumstances, using lightweight jobs can deliver a small performance gain. A lightweight job must reference a program object (program) to specify a job action. The program must be already enabled when the lightweight job is created, and the program type must be either ‘PLSQL_BLOCK’ or ‘STORED_PROCEDURE’.
http://docs.oracle.com/database/121/ADMIN/schedover.htm#ADMIN12668

NEW QUESTION 19
Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value? (Choose two.)

• A. The value of the LOG_CHECKPOINT_INTERVAL parameter overrides the value of the FAST_START_MTTR_TARGET parameter.
• B. The MTTR advisor is enabled only if the value is greater than the default value.
• C. Automatic checkpoint tuning is enabled.
• D. The time taken to recover an instance after a crash is always exactly the same as the value set for the FAST_START_MTTR_TARGET parameter.

Answer: AB

NEW QUESTION 20
Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler?

• A. A job is specified as part of a program definition.
• B. A program can be used in the definition of multiple jobs.
• C. A program and job can be specified as part of a schedule definition.
• D. A program and schedule can be specified as part of a job definition.
• E. A program and window can be specified as part of a job definitio

Answer: BDE

Explanation:
References: http://docs.oracle.com/database/121/ADMIN/schedover.htm#ADMIN13371

NEW QUESTION 21
Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)

• A. An ASM instance mounts an ASM control file
• B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group
• C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly
• D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

Answer: CD

NEW QUESTION 22
Which two statements are true about Flashback Version Query?

• A. The result of a query can be used as part of a DML statement.
• B. It can be used to create views.
• C. It can be used only if Flashback Data Archive is enabled for a table.
• D. It retrieves all versions of rows that exist in a time interval, including the start time and end time.
• E. It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.

Answer: DE

NEW QUESTION 23
Which two statements are true regarding Oracle Data Pump?

• A. EXPDP and IMPDP are the client components of Oracle Data Pump.
• B. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
• C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
• D. Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.
• E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

Answer: AB

Explanation:
References: http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm

NEW QUESTION 24
Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests? (Choose three.)

• A. assigned to a class with rights to browse all directories and catalogs
• B. assigned to a class with rights to back up or restore Oracle database
• C. OSB encryption for data in transport and on tape
• D. RMAN preauthorization on the host
• E. matching the OS user identity of the Oracle instance associated with the database username
• F. scheduling of the RMAN backup to occur automatically at user-defined intervals

Answer: BDE

NEW QUESTION 25
LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory(OID).
SSL has been configure for the database and OLD and the password file has been configured for the database.
User scott with sysdba privilege tries to connect remotely using this command:
$sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name. Which authentication method will be attempted first?

• A. authentication by password file
• B. authentication by using certificates over SSL
• C. authentication by using the Oracle Internet Directory
• D. authentication by using the local OS of the database server

Answer: A

Explanation:
If the database is configured to use a password file for remote authentication, Oracle Database checks the password file first. http://docs.oracle.com/cd/E25054_01/network.1111/e16543/authentication.htm

NEW QUESTION 26
Examine the commands:
SQL> ALTER SESSION SET RECYCLBIN = ON;
Session altered.
SQL> DROP TABLE emp; --(First EMP table) Total dropped.
SQL> CREATE TABLE emp (id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2) );
Table created.
You then execute multiple INSERT statements to insert rows into EMP table and drop the table again: SQL> DROP TABLE emp; -- (Second EMP table)
Table dropped.
SQL> FLASHBACK TABLE emp TO BEFORE DROP;
Which statement is true about the FLASHBACK command?

• A. It recovers the structure, data, and indexes of the first emp table.
• B. It recovers only the structure of the second emp table.
• C. It returns an error because two tables with the same name exist in the recycle bin.
• D. It recovers the structure, data, and indexes of the second emp tabl

Answer: D

NEW QUESTION 27
Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)?

• A. Database Resident Connection Pooling
• B. Oracle Suggested Backup Strategy
• C. Database Vault in ORACLE_HOME
• D. Nondefaultblocksizetablespaces
• E. Configure Label Security

Answer: CE

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

• A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
• B. In a PDB plan, subplans may be used with up to eight consumer groups.
• C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groupsacross all PDBs in the CDB.
• D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
• E. If a PDB plan is enabled for a pluggable database, then 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: Setting a PDB resource plan is optional. If not specified, all sessions within the PDB are treated equally.
In a non-CDB database, workloads within a database are managed with resource plans.
In a PDB, workloads are also managed with resource plans, also called PDB resource plans. The functionality is similar except for the following differences:
Non-CDB Database Multi-level resource plans
Up to 32 consumer groups Subplans
PDB Database
Single-level resource plans only Up to 8 consumer groups
(Not B) No subplans

NEW QUESTION 29
......