NEW QUESTION 1
Your database is running in archivelog mode. Examine the initialization parameters you plan to set for your database instance.
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch'
LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/3rch'
LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch' L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/3rch MANDATORY'
Identify the statement that correctly describes these settings.

• A. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in any of the log_archive_dest_.n destinations.
• B. Optional destinations cannot use the fast recovery area.
• C. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in the location specified for log_archive_dest_4.
• D. These settings work only if log archive_min_succeed_dest is set to a value of 4.

Answer: C

Explanation:
SQL> show parameter log_archive_min_succeed_dest NAME TYPE VALUE ———————————
————–—————————— log_archive_min_succeed_dest integer 1 SQL> https://docs.oracle.com/database/121/ADMIN/archredo.htm#ADMIN11346

NEW QUESTION 2
Which three statements are true about unplugging a pluggable database (PDB)?

• A. The PDB must be open in read only mode.
• B. The PDB must be dosed.
• C. The unplugged PDB becomes a non-CDB.
• D. The unplugged PDB can be plugged into the same multitenant container database (CDB)
• E. The unplugged PDB can be plugged into another CDB.
• F. The PDB data files are automatically removed from dis

Answer: BDE

Explanation:
B, not A: The PDB must be closed before unplugging it.
D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode information in an endianness-sensitive way. There is no supported way to handle the conversion of such columns automatically. This means, quite simply, that an unplugged PDB cannot be moved across an endianness difference.
E (not F): To explogt the new unplug/plug paradigm for patching the Oracle version most effectively, the source and destination CDBs should share a filesystem so that the PDB’s datafiles can remain in place.

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

Explanation:
The table is not static, but instead is continually growing. If a table grows without limit, the space required over the life of the table (its cluster) cannot be predetermined.

NEW QUESTION 4
View the SPFILE parameter settings in the Exhibit.

You issue this command and get errors: SQL> startup
ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET dueto existing internalsettings,seealertlog for moreinformation
Why did the instance fail to start?

• A. because pga_aggregate_target is not set
• B. because statistics_level is set to basic
• C. because memory_target and memory_max_target cannot be equal
• D. because sga_target and memory_target are both set

Answer: B

Explanation:

SQL> startup nomount ORA-01078: failure in processing system parameters ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET SQL>

NEW QUESTION 5
Examine the probable steps involved in the basic backup process of RMAN and Oracle Secure Backup (OSB):
1. RMAN initiates backup and passes the database backup storage selector to OSB.
2. RMAN creates the backup job.
3. OSB creates the backup job with an OSB user.
4. RMAN updates its repository.
5. RMAN executes the job and transfers data from a client to media.
6. OSB executes the job and transfers data from a client to media.
7. OSB updates its repository.
Identify the required steps in the correct order.

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

Answer: C

NEW QUESTION 6
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 7
You issue the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RKAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY; RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which three tasks are performed by the BACKUP DATABASE command?

• A. switching the online redo log file
• B. backing up all data files as image copies and archive log files, and deleting those archive log files
• C. backing up only the used blocks in the data files
• D. backing up all used and unused blocks in the data files
• E. backing up all archived log files and marking them as obsolete

Answer: ABD

NEW QUESTION 8
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_enameVARCHAR2,v_SALARYNU MBER,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

Explanation:
You can control access to privileges that are necessary to run user-created procedures by using definer’s rights, which execute with the privileges of the owner, or with invoker’s rights, which execute with the privileges of the user running the procedure.

NEW QUESTION 9
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_deststring/u01/app/oracle/admin/eml2rep/adump
background_dump_deststring
core_dump_deststring
db_create_file_deststring
db_recovery_file_deststring/u01/app/oracle/fast_recovery_area
diagnostic_deststring
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/en12.1.0/adump.
• C. It is set to /u01/app/oracle.
• D. It is set to /u01/app/oracle/flash_recovery_are

Answer: C

Explanation:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/diag001.htm#ADMIN11008
The Automatic Diagnostic Repository (ADR) is a directory structure that is stored outside of the database. It is therefore available for problem diagnosis when the database is down.
The ADR root directory is known as ADR base. Its location is set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows:
If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE.
If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log.

NEW QUESTION 10
Which two statements are true about dropping a pluggable database (PDB)?

• A. A PDB must be in mount state or it must be unplugged.
• B. The data files associated with a PDB are automatically removed from disk.
• C. A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs.
• D. A PDB must be in closed state.
• E. The backups associated with a PDB are removed.
• F. A PDB must have been opened at least once after creatio

Answer: AC

NEW QUESTION 11
Which two statements are true about a multitenant architecture?

• A. Each pluggable database (PDB) has its own initialization parameter file.
• B. A PDB can have a private undo tablespace.
• C. Log switches occur only at the container database level.
• D. A PDB can have a private temporary tablespace.
• E. Each PDB has a private control fil

Answer: CD

Explanation:
You are only able to switch the archived logs when you connect to the root of a CDB, but you cannot switch archived redo logs when connected to a PDB. You can able to create a PDB without temporary tablespace but not able to make it use the temporary tablespace of CDB.

NEW QUESTION 12
RMAN is connected to the target database PROD1 and an auxiliary instance in NOMOUNT state. Examine the command to create a duplicate database:
RMAN> DUPLICATE TARGET DATABASE TO dup1 FROM ACTIVE DATABASE
NOFILENAMECHECK PASSWORD FILE SPFILE;
Which two statements are true about the execution of the DUPLICATE command?

• A. All archive redo log files are automatically copied to the duplicate database.
• B. The duplicate database has the same directory structure as the source database.
• C. The duplicate database is created by using the backups created during the execution of the DUPLICATE command.
• D. The password file and SPFILE for the duplicate database DUP1 are created in their respective default locations.
• E. The duplicate database is created without using RMAN backups and PROD1 is allowed to remain open during duplication.

Answer: AE

NEW QUESTION 13
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 14
Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?

• A. A PDB opened in restricted mode allows only local users to connect.
• B. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.
• C. When a CDB is in mount state, PDBs are automatically placed in mount state.
• D. All PDBs must be shut down before shutting down a CDB instance.
• E. When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable database command.

Answer: BCE

Explanation:
Reference: https://oracle-base.com/articles/12c/multitenant-startup-and-shutdown-cdb-and-pdb- 12cr1

NEW QUESTION 15
Your database instance is started using an SPFILE. You are connected to cdb$root, as a DB

• A. You issue:SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;Which two statements are true about the statistics level parameter?
• B. It is immediately set to all in the SPFILE and the CDB instance.
• C. It is immediately set to all in only those pluggable databases (PDBs) where the value is set to typical.
• D. It is immediately set to all only for cd3Sroot.
• E. It is immediately set to all in all PDBs where the statistics_level parameter is not set.
• F. It is set to all for all PDBs only in the SPFIL

Answer: AD

Explanation:
When the STATISTICS_LEVEL parameter is modified by ALTER SYSTEM, all advisories or statistics are dynamically turned on or off, depending on the new value of STATISTICS_LEVEL. When modified by ALTER SESSION, the following advisories or statistics are turned on or off in the local session only.
Their system-wide state is not changed.

NEW QUESTION 16
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 17
Which two are prerequisites for creating a backup-based duplicate database?

• A. connecting to the target database and a recovery catalog to execute the duplicate command
• B. creating a password file for an auxiliary instance
• C. connecting to an auxiliary instance
• D. matching the database identifier (DBID) of the source database and the duplicate database
• E. creating an SPFILE for the target database

Answer: BC

Explanation:
References:
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#CHDEDFFH

NEW QUESTION 18
Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

• A. Reduced logical I/O
• B. Reduced virtual memory utilization
• C. Improved Serial Execution performance
• D. Reduced physical I/O
• E. Reduced CPU utilization

Answer: BE

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

• 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

Explanation:
https://oracle-base.com/articles/12c/multitenant-manage-tablespaces-in-a-cdb-and-pdb- 12cr1#temporary-tablespaces

NEW QUESTION 20
Which three statements are true about the SQL*Loader utility?

• A. It can be used to load data from multiple external files into multiple tables.
• B. It can be used to extract and reorganize data from external files, and then load it into a table.
• C. It can be used to load data from external files using direct path only.
• D. It can be used to create tables using data that is stored in external files.
• E. It can be used to generate unique sequential values in specified columns while loading dat

Answer: ABE

NEW QUESTION 21
user_data is a nonencryptedtablespace containing tables with data. You must encrypt ail data in this tablespace.
Which three methods can do this?

• A. Use Data Pump.
• B. Use ALTERTABL
• C. . .MOVE
• D. Use CREATE TABLE AS SELECT
• E. Use alter tablespace to encrypt the tablespace after enabling row movement on all its
• F. Use altertablespace to encrypt the tablespac

Answer: ABC

Explanation:
Finally, note that you can only create encrypted tablespaces; you cannot modify existing tablespaces to encrypt them. So, when you need existing data in encrypted tablespaces, the best solution is to first create encrypted tablespaces and then move the objects from the unencrypted tablespaces to them.

NEW QUESTION 22
You want RMAN to make duplicate copies of data files when using the backup command. What must you set using the RMAN configure command to achieve this?

• A. MAXSETSIZE TO 2;
• B. DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
• C. CHANNEL DEVICE TYPE DISK FORMAT '/disk1/%U' , '/disk2/%U';
• D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

Answer: D

Explanation:
Configuring Backup Duplexing You can use the CONFIGURE ... BACKUP COPIES command to specify how many copies of each backup piece should be created on the specified device type for the
specified type of file. This type of backup is known as a duplexed backup set. The CONFIGURE settings for duplexing only affect backups of datafiles, control files, and archived logs into backup
sets, and do not affect image copies. NOT A The CONFIGURE MAXSETSIZE command limits the size of backup sets created on a channel. This CONFIGURE setting applies to any channel, whether manually allocated or configured, when the BACKUP command is used to create backup sets. The default value
is given in bytes and is rounded down to the lowest kilobyte value. Reference: http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmconfa.htm#BRADV137

NEW QUESTION 23
Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined.
You execute this command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true?

• A. The minimum size for the standard buffer cache is 100 MB.
• B. The maximum size for the standard buffer cache is 100 MB.
• C. The minimum space guaranteed in the buffer cache for any server process is 100 MB.
• D. The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.
• E. The minimum size for all buffer caches is 100 M

Answer: A

Explanation:
If SGA_TARGET is set: If the parameter is not specified, then the default is 0 (internally determined by the Oracle Database). If the parameter is specified, then the user-specified value indicates a minimum value for the memory pool.

NEW QUESTION 24
Examine these Data Pump commands to export and import objects from and to the same database. The dba has not yet created users hr1 and oe1.
$expdp system/manager schemas = hr.oe directory = EXP_DIR dumpfile = export.dat include = table
$ impdpsysten/manager schemas = hr1,oe1 directory = EXP_DIR dumpfile = export.dat
remap_schena=hr:hrl, oe:oe1
What will happen when running these commands?

• A. expdp will fail because no path has been defined for the dumpfile.
• B. expdp will succeed but impdp will fail because the users do not exist.
• C. inpdp will create two users called hr1 and oe1 and import all objects to the new schemas.
• D. impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively.

Answer: B

Explanation:
ORA-39165: Schema not found error will be resulted

NEW QUESTION 25
Your multitenant container database (CDB) CDB1 has two pluggable databases, PDB1 and PDB2. The local net service name CDB1 connects to the root database, and the service names PDB1 and PDB2 connect to the pluggable databases (PDBs), PDB1 and PDB2, respectively.
Examine the commands to change the value of the PDB modifiable initialization parameter:
$> sqlplus sys/oracle_4U@pdb1 AS SYSDBA
SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=FALSE SCOPE=BOTH; SQL> CONN sys/oracle_4U@pdb2 AS SYSDBA
SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=TRUE SCOPE=BOTH; SQL> CONN sys/oracle_4U@pdb1 AS SYSDBA
SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=TRUE SCOPE=BOTH;
Which statement is true about the OPTIMIZER_USER_SQL_PLAN_BASELINES parameter? (Choose the best answer.)

• A. It gives an error because it cannot be set for the root database.
• B. It is set to TRUE for the root database and the pluggable database PDB2, because values can be set for this parameter at the PDB level in a PDB.
• C. It is set to TRUE for the root database and all the PDBs, because the value set at the root level has higher precedence.
• D. It is set to TRUE for the root database and all the PDBs, but is effective only when CDB is restarted and the PDBs are reopened.

Answer: B

NEW QUESTION 26
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, the PDB uses the CDB plan.
• B. To enable a resource plan for a PDB, a CDB resource plan must be created and enabled.
• C. If no PDB plan is enabled for a pluggable database, all sessions for that PDB are treated to an equal share of resources.
• D. 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.
• 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

NEW QUESTION 27
Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT;
Why would you need this to be executed?

• A. Because row IDs may change during the flashback operation
• B. Because the object number changes after the flashback operation
• C. Because the rows are retrieved from the recycle bin during the flashback operation
• D. Because the table is moved forward and back to a temporary during the flashback operation

Answer: A

NEW QUESTION 28
Which two statements are true about the Automatic Diagnostic Repository (ADR)?

• A. The ADR base is shared across multiple instances.
• B. The ADR base keeps all diagnostic information in binary format.
• C. The ADR can be used to store statspack snapshots to diagnose database performance issues.
• D. The ADR can be used for problem diagnosis even when the database instance is down.
• E. The ADR is used to store Automatic Workload Repository (AWR) snapshot

Answer: AD

NEW QUESTION 29
......