NEW QUESTION 1
You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy.
One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed.
When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.
Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again? (Choose two.)

• A. Increase the value of the ASM_POWER_LIMIT parameter.
• B. Set the DISK_REPAIR_TIME disk attribute to a lower value.
• C. Specify the statement that adds the disk back to the disk group.
• D. Increase the number of ASMB processes.
• E. Increase the number of DBWR_IO_SLAVES in the ASM instance.

Answer: AD

Explanation:
A: ASM_POWER_LIMIT specifies the maximum power on an Automatic Storage Management instance for disk rebalancing. The higher the limit, the faster rebalancing will complete. Lower values will take longer, but consume fewer processing and I/O resources.
D:
* Normally a separate process is fired up to do that rebalance. This will take a certain amount of time. If you want it to
happen faster, fire up more processes. You tell ASM it can add more processes by increasing the rebalance power.
* ASMB
ASM Background Process
Communicates with the ASM instance, managing storage and providing statistics Incorrect:
Not B: A higher, not a lower, value of DISK_REPAIR_TIME would be helpful here.
Not E: If you implement database writer I/O slaves by setting the DBWR_IO_SLAVES parameter, you configure a single (master) DBWR process that has slave processes that are subservient to it. In addition, I/O slaves can be used to "simulate" asynchronous I/O on platforms that do not support asynchronous I/O or implement it inefficiently. Database I/O slaves provide non-blocking, asynchronous requests to simulate asynchronous I/O.

NEW QUESTION 2
Examine the following steps:
ADBA grants the CREATE TABLE system privilege with ADMIN OPTION to the user SIDNEY. SIDNEY grants the CREATE TABLE system privilege to the HR user.
Which statement is true?

• A. SIDNEY can revoke the CREATE TABLE system privilege only from HR, to whom he granted it.
• B. HR can grant the CREATE TABLE system privilege to other users.
• C. Neither SIDNEY nor HR can create new tables if the DBA revokes the CREATE TABLE privilege from SIDNEY.
• D. HR still retains the CREATE TABLE system privilege if the DBA revokes the CREATE TABLE privilege from SIDNEY.

Answer: D

Explanation:
References:
http://www.dba-oracle.com/t_with_grant_admin_privileges.htm

NEW QUESTION 3
Which three statements are true about the purpose of checkpoints? (Choose three.)

• A. They ensure that uncommitted transactions are rolled back in case of an instance failure.
• B. They ensure that all the dirty buffers are written to disk during a normal shutdown.
• C. They ensure that instance recovery starts in the event of an instance failure.
• D. They ensure that dirty buffers in the buffer cache are written to disk regularly.
• E. They reduce the time required for recovery in case of an instance failur

Answer: BDE

NEW QUESTION 4
Examine the following command:
SQL> DBMS_STATS. SET_TABLE_PREFS ('SH', 'CUSTOMERS', 'PUBLISH', 'false'); What is the effect of executing this command?

• A. Existing statistics for the CUSTOMERS table become unusable for the query optimizer.
• B. Automatic statistics collection is stopped for the CUSTOMERS table.
• C. Statistics for the CUSTOMERS table are locked and cannot be overwritten.
• D. Statistics subsequently gathered on the CUSTOMERS table are stored as pending statistic

Answer: D

NEW QUESTION 5
Which statement is true about unified auditing?

• A. The unified audit trail, by default, resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace.
• B. Only the CREATE, ALTER, and DROP statements are audited for all users, including SYS.
• C. Unified auditing is enabled only if the AUDIT_TRAIL parameter is set to NONE.
• D. The unified audit trail contains audit records only from unified audit policies and AUDIT settings.

Answer: A

Explanation:
References: https://docs.oracle.com/database/121/DBSEG/audit_admin.htm#DBSEG370

NEW QUESTION 6
Which three tools or tasks are run by default as part automated maintenance tasks? (Choose three.)

• A. Automatic Database Diagnostic Monitor
• B. Optimizer statistics gathering
• C. SQL Access Advisor
• D. Segment Advisor
• E. Automatic SQL Tuning Advisor

Answer: BDE

NEW QUESTION 7
Automatic Shared Memory Management is enabled for your database instance. You notice that there are SQL statements performing poorly because of repeated parsing activity.
Which action generates recommendations to overcome the performance issues?

• A. running the Memory Advisor for the buffer cache
• B. running the Memory Advisor for the library cache
• C. running the Memory Advisor for the SGA
• D. running the Memory Advisor for the PGA

Answer: B

NEW QUESTION 8
Which two are prerequisites for performing a flashback transaction? (Choose two.)

• A. Flashback Database must be enabled.
• B. Undo retention guarantee for the database must be configured.
• C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
• D. Supplemental logging must be enabled.
• E. Recycle bin must be enabled for the database.
• F. Block change tracking must be enabled tor the database.

Answer: BD

Explanation:
References: http://searchoracle.techtarget.com/tip/How-to-perform-Oracle-Flashback-Transaction-Queries https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS610

NEW QUESTION 9
You must track all transactions that modify certain tables in the sales schema for at least three years. Automatic undo management is enabled for the database with a retention of one day.
Which two must you do to track the transactions? (Choose two.)

• A. Enable supplemental logging for the database.
• B. Specify undo retention guarantee for the database.
• C. Create a Flashback Data Archive in the tablespace where the tables are stored.
• D. Create a Flashback Data Archive in any suitable tablespace.
• E. Enable Flashback Data Archiving for the tables that require tracking.

Answer: DE

Explanation:
E: By default, flashback archiving is disabled for any table. You can enable flashback archiving for a table if you have the FLASHBACK ARCHIVE object privilege on the Flashback Data Archive that you want to use for that table.
D: Creating a Flashback Data Archive
/ Create a Flashback Data Archive with the CREATEFLASHBACK ARCHIVE statement, specifying the following: Name of the Flashback Data Archive
Name of the first tablespace of the Flashback Data Archive
(Optional) Maximum amount of space that the Flashback Data Archive can use in the first tablespace
/ Create a Flashback Data Archive named fla2 that uses tablespace tbs2, whose data will be retained for two years: CREATEFLASHBACK ARCHIVE fla2 TABLESPACE tbs2 RETENTION 2 YEAR;

NEW QUESTION 10
Which two statements describe the relationship between a scheduler window, a resource manager plan, and a job class? (Choose two.)

• A. A scheduler window together with a job class, controls resource allocation for a job using that job class in that scheduler window.
• B. A job class specifies a scheduler window that will be open when that job class becomes active.
• C. A scheduler window specifies a resource manager plan that will be activated when that scheduler window becomes active.
• D. A scheduler window specifies a job class that will be activated when that scheduler window becomes active.
• E. A scheduler window can control resource allocation by itsel

Answer: AC

NEW QUESTION 11
Examine the command: SQL> CONNECT hr/hr@orcl
Which two configurations allow this command to execute successfully? (Choose two.)

• A. In the tnsnames.ora file, the SERVICE_NAME value of CONNECT_DATA should be explicitly suffixed with the domain name.
• B. The SERVICE_NAMES initialization parameter should contain the name orcl in the database host.
• C. The orcl TNS alias should be defined such that it is resolvable by a client running on the database host.
• D. The orcl TNS alias should be defined in the tnsnames.ora file on both the client and the database host.
• E. The TNS_ADMIN environment variable should be set to orcl on the clien

Answer: BC

NEW QUESTION 12
Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart.
Examine the following command and its output:
$ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?

• A. When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.
• B. When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.
• C. When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
• D. When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

Answer: B

Explanation:
About Startup Dependencies
Oracle Restart ensures that Oracle components are started in the proper order, in accordance with component dependencies. For example, if database files are stored in Oracle ASM disk groups, then before starting the database instance, Oracle Restart ensures that the Oracle ASM instance is started and the required disk groups are mounted. Likewise, if a component must be shut down, Oracle Restart ensures that dependent components are cleanly shut down first.
Oracle Restart also manages the weak dependency between database instances and the Oracle Net listener (the listener): When a database instance is started, Oracle Restart attempts to start the listener. If the listener startup fails, then the database is still started. If the listener later fails, Oracle Restart does not shut down and restart any database instances. http://docs.oracle.com/cd/E16655_01/server.121/e17636/restart.htm#ADMIN12710

NEW QUESTION 13
You install Oracle Grid Infrastructure standalone server and issue the following command: crsctl start has
Which two existing components get automatically added to the Oracle Restart configuration? (Choose two.)

• A. Oracle CSSD services
• B. the database whose instance is running
• C. Oracle Notification services
• D. Oracle Healthcheck services
• E. Oracle Net Listener

Answer: AC

NEW QUESTION 14
What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE” statement?

• A. It will create a multitenant container database (CDB) with only the root opened.
• B. It will create a CDB with root opened and seed read only.
• C. It will create a CDB with root and seed opened and one PDB mounted.
• D. It will create a CDB that must be plugged into an existing CDB.
• E. It will create a CDB with root opened and seed mounted.

Answer: B

Explanation:
* The CREATE DATABASE ... ENABLE PLUGGABLE DATABASE SQL statement creates a new CDB. If you do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non-CDB and can never contain PDBs.
Along with the root (CDB$ROOT), Oracle Database automatically creates a seed PDB (PDB$SEED). The following graphic shows a newly created CDB:

* Creating a PDB
Rather than constructing the data dictionary tables that define an empty PDB from scratch, and then populating its Obj$ and Dependency$ tables, the empty PDB is created when the CDB is created. (Here, we use empty to mean containing no customer-created artifacts.) It is referred to as the seed PDB and has the name PDB$Seed. Every CDB non-negotiably contains a seed PDB; it is non-negotiably always open in read-only mode. This has no conceptual significance; rather, it is just an optimization device. The create PDB operation is implemented as a special case of the clone PDB operation.

NEW QUESTION 15
Examine the parameters for a database instance:

Your database has three undo tablespaces and the default undo tablespace is not autoextensible. Resumable space allocation is not enabled for any sessions in the database instance.
What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?

• A. Transactions write their undo in the SYSTEM undo segment.
• B. Transactions fail.
• C. Transactions wait until space becomes available in UNDOTBS1.
• D. Transactions write their undo in a temporary tablespace.

Answer: B

Explanation:
References https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm (undo retention)

NEW QUESTION 16
You are managing an Oracle Database 12c database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.
Which three statements are true about these backups? (Choose three.)

• A. The backups would be consistent.
• B. The backups would be possible only if the database is running in ARCHIVELOG mode.
• C. The backups need to be restored and the database has to be recovered in case of a media failure.
• D. The backups would be inconsistent.
• E. The backups by default consist of all the data blocks within the chosen files or the full databas

Answer: BCD

NEW QUESTION 17
Your single-instance Oracle 12c database home currently supports conventional auditing and uses Automatic Storage Management (ASM). You want to enable unified auditing by executing the command:
$ make –fins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME Which two steps should you perform before executing this command? (Choose two.)

• A. Ensure that the initialization parameter AUDIT_TRAIL is set to DB.
• B. Drop any existing fine-grained audit (FGA) policies.
• C. Stop the listener.
• D. Shut down the database instance.
• E. Disable auditing by setting the initialization parameter AUDIT_TRAIL to NONE.

Answer: CE

Explanation:
References: https://blogs.oracle.com/UPGRADE/entry/unified_auditing_is_it_on

NEW QUESTION 18
Your database is configured in ARCHIVELOG mode. Examine the RMAN configuration parameters:

Examine the command:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which two are true? (Choose two.)

• A. It fails because the DELETE INPUT option can be used only with the BACKUP AS COPY command
• B. It creates image copies of the archivelogs
• C. It creates a backupset of archive log files
• D. It creates image copies of the database files
• E. It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command

Answer: BE

NEW QUESTION 19
Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)

• A. All AWR tables belong to the SYSTEM schema.
• B. The AWR data is stored in memory and in the database.
• C. The snapshots collected by AWR are used by the self-tuning components in the database
• D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
• E. AWR contains system wide tracing and logging information.

Answer: BCD

NEW QUESTION 20
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

• A. statistics recommendations
• B. SQL profile recommendations
• C. SQL statement restructure recommendations
• D. creation of materialized views to improve query performance

Answer: B

NEW QUESTION 21
In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement? (Choose two.)

• A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
• B. Setting the target tablespace to read-only
• C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
• D. Setting the target tablespace offline
• E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

Answer: BC

Explanation:
The value for TBS_PERCENT_USED specifies the percentage of the tablespace quota when a tablespace is considered full. The value for TBS_PERCENT_FREE specifies the targeted free percentage for the tablespace. When the percentage of the tablespace quota reaches the value of TBS_PERCENT_USED, ADO begins to move data so that percent free of the tablespace quota approaches the value of TBS_PERCENT_FREE. This action by ADO is a best effort and not a guarantee.

NEW QUESTION 22
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?

• A. Compare Period ADDM report
• B. AWR Compare Period report
• C. Active Session History (ASH) report
• D. Taking a new snapshot and comparing it with a preserved snapshot

Answer: A

NEW QUESTION 23
You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE; Which is true about the result of this command?

• A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.
• B. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
• C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.
• D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignore

Answer: A

NEW QUESTION 24
What is pre-requisite to alter a role?

• A. You should be granted the DBA role.
• B. You should set the OS_ROLES parameter to true.
• C. You should be granted the role with the GRANT OPTION.
• D. You should have the ALTER ANY ROLE system privileg

Answer: D

NEW QUESTION 25
You want to reduce fragmentation and reclaim unused space for the SALES table but not its dependent objects. During this operation, you want to ensure the following:

• A. Long-running queries are not affected.i
• B. No extra space is used.ii
• C. Data manipulation language (DML) operations on the table succeed at all times throughout the process.i
• D. Unused space is reclaimed both above and below the high water mar
• E. Which ALTER TABLE option would you recommend?
• F. DEALLOCATE UNUSED
• G. SHRINK SPACE CASCADE
• H. SHRINK SPACE COMPACT
• I. ROW STORE COMPRESS BASIC

Answer: C

Explanation:
References: https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema003.htm

NEW QUESTION 26
Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges? (Choose three.)

• A. Bind Variable Peeking
• B. SQL Plan Baselines
• C. Adaptive Cursor Sharing
• D. Bind variable used in a SQL statement
• E. Literals in a SQL statement

Answer: ACD

NEW QUESTION 27
......