NEW QUESTION 1
View the Exhibit1 to examine the series of SQL commands. View the Exhibit2 to examine
the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS. Which statement is true if the SQL query in exhibit1 is executed again when the value of OPTIMIZER_MODE is set to FIRST_ROWS?

parameter-optimizer (exhibit):

• A. The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans.
• B. The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan.
• C. The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan.
• D. The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to FIRST_ROW during its creation.

Answer: B

Explanation: Setting the OPTIMIZER_MODE Initialization Parameter(Link)
The OPTIMIZER_MODE initialization parameter establishes the default behavior for choosing an optimization approach for the instance.
OPTIMIZER_MODE Initialization Parameter Values
✑ ALL_ROWS, The optimizer uses a cost-based approach for all SQL statements in the session regardless of the presence of statistics and optimizes with a goal of best throughput (minimum resource use to complete the entire statement). This is the default value.
✑ FIRST_ROWS_n, The optimizer uses a cost-based approach, regardless of the
presence of statistics, and optimizes with a goal of best response time to return the first n number of rows, where n equals 1, 10, 100, or 1000.
✑ FIRST_ROWS, The optimizer uses a mix of cost and heuristics to find a best plan
for fast delivery of the first few rows.
Note that using heuristics sometimes leads the optimizer to generate a plan with a cost that is significantly larger than the cost of a plan without applying the heuristic. FIRST_ROWS is available for backward compatibility and plan stability; use FIRST_ROWS_n instead.

NEW QUESTION 2
The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance.
SQL> STARTUP;
Which two activities are performed during a successful start up operation? (Choose two.)

• A. The databases configured to use the ASM instance are mounted
• B. The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter
• C. ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started
• D. ASM discovers and examines the contents of all files that are in the paths specified in theASM_DISKGROUPS initialization parameters

Answer: BC

Explanation: Refer to Starting Up an ASM Instance. To start up an ASM instance, you must:
1. To connect to the ASM instance with SQL*Plus, you must set the ORACLE_SID environment variable to the ASM SID.
2. The initialization parameter file, which can be a server parameter file, must contain: INSTANCE_TYPE = ASM
3. The STARTUP command, tries to mount the disk groups specified by the initialization parameter ASM_DISKGROUPS.
If ASM_DISKGROUPS is blank, the ASM instance starts and warns that no disk groups were mounted. You can then mount disk groups with the ALTER DISKGROUP...MOUNT command.
The Cluster Synchronization Services (CSS) daemon is required to enable synchronization between ASM and its client database instances. The CSS daemon is normally started (and configured to start upon reboot) when you use Database Configuration Assistant (DBCA) to create your database. If you did not use DBCA to create the database, you must ensure that the CSS daemon is running before you start the ASM instance.

NEW QUESTION 3
You issue the following command: RMAN>CONFIGURE BACKUP OPTIMIZATION ON;
What is the result of this command on your backups?

• A. An incremental backup strategy will be used automatically.
• B. Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.
• C. RMAN will configure itself for maximum performance at the cost of CPU.
• D. RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.
• E. RMAN will automatically compress backups.

Answer: B

NEW QUESTION 4
Your archive-log destination directory runs out of space. What is the impact of this on the database?

• A. Non
• B. The database will switch over to the stand-by archive-log destination directory.
• C. A warning message will be written to the alert log of the database, but no adverse impacts to the database will be experienced.
• D. The database will shut down, and will not restart until you correct the out-of-space situation.
• E. The database will continue to try to write to the archive-log destination directory for one hou
• F. After one hour, the database will shut down normally.
• G. Once Oracle has cycled through all online redo logs, it will stop processing any DML or DDL until the out-ofspace condition is corrected.

Answer: E

NEW QUESTION 5
Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)

• A. ALTER DISKGROUP misc MOUNT;
• B. ALTER DISKGROUP misc DROP DISK misc2;
• C. ALTER DISKGROUP misc CHECK ALL NOREPAIR;
• D. ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;
• E. ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';

Answer: AC

Explanation: Altering Disk Groups
You can use the ALTER DISKGROUP SQL statement to alter a disk group configuration. You can add, resize, or drop disks while the database remains online. Whenever possible, multiple operations in a single ALTER DISKGROUP statement are recommended. Grouping operations in a single ALTER DISKGROUP statement can reduce rebalancing operations.
Oracle ASM automatically rebalances when the configuration of a disk group changes. By default, the ALTER DISKGROUP statement does not wait until the operation is complete before returning. Query the V$ASM_OPERATION view to monitor the status of this operation.
add_disk_clause
Use this clause to add one or more disks to the disk group and specify attributes for the newly added disk. Oracle ASM automatically rebalances the disk group as part of this operation.
drop_disk_clause
Use this clause to drop one or more disks from the disk group.
DROP DISK
The DROP DISK clause lets you drop one or more disks from the disk group and automatically rebalance the disk group. When you drop a disk, Oracle ASM relocates all the data from the disk and clears the disk header so that it no longer is part of the disk group. The disk header is not cleared if you specify the FORCE keyword.

NEW QUESTION 6
You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?

• A. Create and populate a SQL Tuning Set from the AWR on every Monday.
• B. Change the RETENTION setting for the AWR snapshots to 7 days on Monday.
• C. Create a repeating baseline template.
• D. Insert a finding directive for future ADDM tasks.

Answer: C

NEW QUESTION 7
Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode? (Choose all that apply.)

• A. Database datafiles
• B. Control files
• C. Archived redo logs
• D. Online redo logs
• E. Flashback logs

Answer: ABD

Explanation: Recovering a Database in NOARCHIVELOG Mode
1. Restore all the data files and control files
2. (optional) if the media failure is not fixed, you need to modify the control file to the new location of data files and redo log files.
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE RENAME FILE '<damaged file, datafile, redo log>' TO '<new location>';
3. SQL> RECOVER DATABASE UNTIL CANCEL Because online redo logs are never backed up, you cannot restore them with the data files and control files. To enable the
database to reset the online redo logs, you must first mimic incomplete recovery:
4. SQL> ALTER DATABASE OPEN RESETLOGS;

NEW QUESTION 8
When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?

• A. INCLUDING DEPENDENCIES
• B. INCLUDING DEPENDENCIES CASCADE
• C. COMPACT
• D. CASCADE
• E. None of the above

Answer: D

NEW QUESTION 9
Which of the following is not a valid linguistic sort element?

• A. Accent expansion
• B. Canonical equivalence
• C. Reverse secondary sorting
• D. Ignorable characters
• E. Character rearrangement

Answer: A

NEW QUESTION 10
Your developers have asked you to restore the development database, which is in NOARCHIVELOG mode, back to last Tuesday the 20th. Your last backup is from Monday the 19th.
What do you do?

• A. Restore the 19ths backup, restore all archived redo logs, recover the database to the 20th, and open the database.
• B. Tell them that their request cannot be met with the current backup strategy.
• C. Restore the 19ths backup, apply the online redo logs, and open the database.
• D. Switch the database into ARCHIVELOG mode, restore the 19th's backup, restore all archived redo logs, and recover the database to the 20th.
• E. Use the recover database command to roll back the database from today to the 19th of the month.

Answer: B

NEW QUESTION 11
USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the
encrypted format. Which methods would you use to achieve this? (Choose all that apply.)

• A. Use Data Pump to transfer the existing data to a new encrypted tablespace.
• B. Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespace.
• C. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace.
• D. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace.
• E. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted.

Answer: ABC

NEW QUESTION 12
What is the default AU size of an ASM disk group? What is the maximum AU size in an ASM disk group?

• A. 100KB default, 10TB maximum
• B. 256KB default, 1024MB maximum
• C. 10MB default, 126PB maximum
• D. 64KB default, 1EB maximum
• E. 1MB default, 64MB maximum

Answer: E

Explanation: The AU size is determined at creation time with the allocation unit size (AU_SIZE) disk group attribute. The values can be 1, 2, 4, 8, 16, 32, and 64 MB.

NEW QUESTION 13
Which of the following options describes Segment Shrink?

• A. Reclaims space above and below the high-water mark without using additional space
• B. Moves rows to a new physical location, resetting the high-water mark, but uses additional space during the operation
• C. Deallocates space above the high-water mark that is currently not in use
• D. None of the above

Answer: A

NEW QUESTION 14
View the Exhibit to observe the error.
You receive this error regularly and have to shutdown the database instance to overcome the error. Automatic Shared Memory Management is configured for the instance.
What can you do to reduce the chance of this error in the future? Exhibit:

• A. Increase the value of SGA_MAX_SIZE
• B. Enable automatic memory management
• C. Set the PRE_PAGE_SGA parameter to true
• D. Lock the System Global Area (SGA) in memory

Answer: B

Explanation: ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string")
Cause: More shared memory is needed than was allocated in the shared pool or Streams pool.
Action: If the shared pool is out of memory, either use the DBMS_SHARED_POOL package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the initialization parameters SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE. If the large pool is out of memory, increase the initialization parameter LARGE_POOL_SIZE. If the error is issued from an Oracle Streams or XStream process, increase the initialization parameter STREAMS_POOL_SIZE or increase the capture or apply parameter MAX_SGA_SIZE.

NEW QUESTION 15
Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B? (Choose all that apply.)

• A. A must contain all of the characters defined in B.
• B. A must be Unicode.
• C. The encoded values in A must match the encoded values in B for all characters defined in B.
• D. A must be a multi-byte character set.
• E. The encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B.

Answer: AC

NEW QUESTION 16
You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1.
Which two statements are true in this scenario for the features enabled for ASM? (Choose two.)

• A. The ASM-preferred mirror read feature is enabled.
• B. The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.
• C. The ASM disk is dropped immediately from a disk group when it becomes unavailable.
• D. The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.

Answer: AB

NEW QUESTION 17
You want to disable resumable space allocation for all sessions. Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable space allocation for all sessions?

• A. 10
• B. 100
• C. NULL

Answer: A

NEW QUESTION 18
Which statements are true regarding the Query Result Cache? (Choose all that apply.)

• A. It can be set at the system, session, or table level.
• B. It is used only across statements in the same session.
• C. It can store the results from normal as well as flashback queries.
• D. It can store the results of queries based on normal, temporary, and dictionary tables.

Answer: AC

NEW QUESTION 19
Your database is running In ARCHIVELOG mode. One of the data files, USERDATA01.DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.
Which three files would be used in the user-managed recovery process performed by the
database administrator (DBA)? (Choose three.)

• A. Redo logs
• B. Control file
• C. The latest backup of only the damaged data file
• D. The latest backup of all the data file in the USERS tablespace
• E. Temporary files of temporary tablespace
• F. Archive Logs since the latest backup to point of failure

Answer: ACF

NEW QUESTION 20
Consider the following code snippet:

If this code were executed, which of the following statements would be true?

• A. The priority of the lne_job1 job would be set to 1.
• B. The lne_job1 job would be executed synchronously.
• C. The lne_job1 job would run immediately in the users current session.
• D. The lne_job1 job would retain its current priority.
• E. The job will immediately take priority over all running jobs.

Answer: A

Explanation: job_priority
This attribute specifies the priority of this job relative to other jobs in the same class as this job. If multiple jobs within a class are scheduled to be executed at the same time, the job priority determines the order in which jobs from that class are picked up for execution by the job coordinator. It can be a value from 1 through 5, with 1 being the first to be picked up for job execution.
If no job priority is specified when creating a job, the default priority of 3 is assigned to it.