NEW QUESTION 1

While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.
Identify the two events that can occur in the event of a log switch? (Choose two.)

• A. An entry is created in the alert log file and the database instance continues to function normally
• B. The log switch hangs occur for transactions until free space is available in the flash recovery area
• C. The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area
• D. The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented

Answer: BC

NEW QUESTION 2

You executed the following command to drop a user: DROP USER scott CASCADE;
Which two statements regarding the above command are correct? (Choose two.)

• A. All the objects of scott are moved to the Recycle Bin.
• B. Any objects in the Recycle Bin belonging to scott are purged.
• C. All the objects owned by scott are permanently dropped from the database.
• D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
• E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

Answer: BC

NEW QUESTION 3

You want to use RMAN to create compressed backups.
Which statement is true about the compression algorithms that RMAN can use?

• A. The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.
• B. The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.
• C. The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.
• D. Only the BZIP2 compression algorithm can be used to make compressed backups to disk.

Answer: A

NEW QUESTION 4

Which command is used to configure RMAN to perform a compressed backup for every backup executed?

• A. BACKUP AS COMPRESSED BACKUPSET DATABASE
• B. BACKUP AS COMPRESSED COPY OF DATABASE
• C. CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
• D. CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS
• E. BACKUP DATABASE COMPRESS

Answer: C

NEW QUESTION 5

You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations.
While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?

• A. Open the database in NORMAL mode
• B. Open the database in read-only mode
• C. Open the database in RESTRICTED mode
• D. Open the database with the RESETLOGS option

Answer: D

Explanation:
Recovering the Database After a Disaster
The procedure for disaster recovery is similar to the procedure for recovering the database with a backup control file in NOCATALOG mode. If you are restoring the database to a new host, then you should also review the considerations described in "Restoring a Database on a New Host".
This scenario assumes that the Linux server on which your database was running has been damaged beyond repair. Fortunately, you backed up the database to Oracle Secure Backup and have the tapes available. The scenario assumes the following:
✑ Oracle Database is already installed on the new host.
✑ You are restoring the database to a new Linux host with the same directory structure as the old host.
✑ You have one tape drive containing backups of all the data files and archived redo logs through log 1124, and autobackups of the control file and server parameter file.
✑ You do not use a recovery catalog with the database.
To recover the database on the new host:
1. If possible, restore or re-create all relevant network files such as tnsnames.ora and listener.ora and a password file.
2. Start RMAN and connect to the target database instance.
At this stage, no initialization parameter file exists. If you have set ORACLE_SID and ORACLE_HOME, then you can use operating system authentication to connect as SYSDBA. For example, start RMAN as follows:
% rman
RMAN> CONNECT TARGET
/
3. Specify the DBID for the target database with the SET DBID command, as described in "Restoring the Server Parameter File".
For example, enter the following command: SET DBID 676549873;
4. Run the STARTUP NOMOUNT command.
When the server parameter file is not available, RMAN attempts to start the instance with a dummy server parameter file.
5. Allocate a channel to the media manager and then restore the server parameter file from autobackup. For example, enter the following command to restore the server parameter file from Oracle Secure Backup:
RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE sbt; RESTORE SPFILE FROM AUTOBACKUP;
}
6. Restart the instance with the restored server parameter file. STARTUP FORCE NOMOUNT;
7. Write a command file to perform the restore and recovery operation, and then execute the command file.
The command file should do the following:
a. Allocate a channel to the media manager.
b. Restore a control file autobackup (see "Performing Recovery with a Backup Control File and No Recovery Catalog").
c. Mount the restored control file.
d. Catalog any backups not recorded in the repository with the CATALOG command.
e. Restore the data files to their original locations. If volume names have changed, then run SET
NEWNAME commands before the restore operation and perform a switch after the restore operation to update the control file with the new locations for the data files, as shown in the following example.
f. Recover the data files. RMAN stops recovery when it reaches the log sequence number specified.
RMAN> RUN
{
# Manually allocate a channel to the media manager ALLOCATE CHANNEL t1 DEVICE TYPE sbt;
# Restore autobackup of the control file. This example assumes that you have
# accepted the default format for the autobackup name. RESTORE CONTROLFILE FROM AUTOBACKUP;
# The set until command is used in case the database
# structure has changed in the most recent backups, and you want to
# recover to that point in time. In this way RMAN restores the database
# to the same structure that the database had at the specified time. ALTER DATABASE MOUNT;
SET UNTIL SEQUENCE 1124 THREAD 1; RESTORE DATABASE;
RECOVER DATABASE;
}
The following example of the RUN command shows the same scenario except with new file names for the restored data files:
RMAN> RUN
{
# If you must restore the files to new locations,
# use SET NEWNAME commands:
SET NEWNAME FOR DATAFILE 1 TO '/dev/vgd_1_0/rlvt5_500M_1'; SET NEWNAME FOR DATAFILE 2 TO '/dev/vgd_1_0/rlvt5_500M_2'; SET NEWNAME FOR DATAFILE 3 TO '/dev/vgd_1_0/rlvt5_500M_3'; ALLOCATE CHANNEL t1 DEVICE TYPE sbt;
RESTORE CONTROLFILE FROM AUTOBACKUP; ALTER DATABASE MOUNT;
SET UNTIL SEQUENCE 124 THREAD 1; RESTORE DATABASE;
SWITCH DATAFILE ALL; # Update control file with new location of data files. RECOVER DATABASE;
}
8. If recovery was successful, then open the database and reset the online logs: ALTER DATABASE OPEN RESETLOGS;

NEW QUESTION 6

To reference existing ASM files, you need to use a fully qualified ASM filename. Your development database has a disk group named DG2A, the database name is DEV19, and the ASM file that you want to reference is a datafile for the USERS02 tablespace.
Which of the following is a valid ASM filename for this ASM file?

• A. dev19/+DG2A/datafile/users02.701.2
• B. +DG2A/dev19/datafile/users02.701.2
• C. +DG2A/dev19/users02/datafile.701.2
• D. +DG2A.701.2
• E. +DG2A/datafile/dev19.users.02.701.2

Answer: B

Explanation:
Fully Qualified File Name Form (link)
A fully qualified file name has the following form:
+diskgroup/dbname/filetype/filetypetag.file.incarnation Where:
+diskgroup is the disk group name preceded by a plus sign. You can think of the plus sign (+) as the root directory of the Oracle ASM file system, similar to the slash (/) on UNIX or Linux computers.
dbname is the DB_UNIQUE_NAME of the database to which the file belongs. filetype is the Oracle file type and can be one of the file types shown in Table 7-3.
filetypetag is type-specific information about the file and can be one of the tags shown in Table 7-3.
file.incarnation is the file/incarnation pair, used to ensure uniqueness. For example,
filetype = 'DATAFILE', Data files and data file copies
filetypetag = 'tblspname', Name of the tablespace into which the file is added

NEW QUESTION 7

The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.
Which two statements are true regarding the outcome of this action? (Choose two)

• A. All the related indexes and views are automatically dropped
• B. The flashback drop feature can recover only the table structure
• C. Only the related indexes are dropped whereas views are invalidated
• D. The flashback drop feature can recover both the table structure and its data

Answer: CD

NEW QUESTION 8

Which setting enables the baselines by default in Oracle Database 11g?

• A. setting the STATISTICS_LEVEL parameter to TYPICAL
• B. adding filters to the Automatic Database Diagnostic Monitor (ADDM)
• C. enabling Automated Maintenance Task using Oracle Enterprise Manager
• D. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE

Answer: A

NEW QUESTION 9

Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal.
Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks? (Choose two.)

• A. Define the POWER option while adding or removing the disks.
• B. Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.
• C. Increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES.
• D. Increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES.

Answer: AB

Explanation:
ARBn (ASM Rebalance Process): Rebalances data extents within an ASM disk group, possible processes are ARB0-ARB9 and ARBA.
ALTER DISKGROUP..POWER clause, specify a value from 0 to 11, where 0 stops the rebalance operation and 11 permits Oracle ASM to execute the rebalance as fast as possible. The value you specify in the POWER clause defaults to the value of the ASM_POWER_LIMIT initialization parameter. If you omit the POWER clause, then Oracle ASM executes both automatic and specified rebalance operations at the power determined by the value of the ASM_POWER_LIMIT initialization parameter.
Note:
Beginning with Oracle Database 11g Release 2 (11.2.0.2), if the COMPATIBLE.ASM disk group attribute is set to 11.2.0.2 or higher, then you can specify a value from 0 to 1024 in the POWER clause.

NEW QUESTION 10

The EMP table exists in your schema. You want to execute the following query:
SELECT ename, sal FROM emp
AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE) WHERE ename = 'ALLEN';
What are the minimum requirements for the statement to execute successfully? (Choose all that apply)

• A. ARCHIVELOG mode must be enabled
• B. Row Movement must be enabled for the table
• C. FLASHBACK must be set to ON for the database
• D. The UNDO_MANAGEMENT parameter must be set to AUTO
• E. The UNDO_RETENTION parameter must be set appropriately

Answer: DE

NEW QUESTION 11

You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is (jetting filled up very fast and it is
running out of space. Your database flash recovery area is low on specie and you have no more room on disk.
Proactively, which two options could you use to make more space available in the flash recovery [Choose two]

• A. Change the RMAN archived log deletion policy.
• B. Use the RMAN CROSSCHECK command to reclaim the archived log space.
• C. Change the RMAN retention policy to retain backups for a shorter period of time.
• D. Use OS command to move files from the flash recovery area to some other location

Answer: BD

NEW QUESTION 12

Which three statements correctly describe the features of the I/O calibration process? (Choose three.)

• A. Only one I/O calibration process can run at a time.
• B. It automates the resource allocation for the Automated Maintenance Tasks.
• C. It improves the performance of the performance-critical sessions while running.
• D. It can be used to estimate the maximum number of I/Os and maximum latency time for the system.
• E. The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE.

Answer: ADE

NEW QUESTION 13

In your production database, you:
✑ Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regular intervals
✑ Set the control file autobackup to "on"
✑ Are maintaining image copies of the database files
You have lost the server parameter file (SPFILE) and the control file.
Which option must you consider before restoring the SPFILE and the control file by using the control file autobackup?

• A. Setting DBID for the database
• B. Using the RMAN SWITCH command
• C. Using the RMAN SET NEWNAME command
• D. Starting up the database instance in the NOMOUNT state

Answer: D

NEW QUESTION 14

Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours?

• A. restore datafiles until time '09/28/2008:21:03:11';
• B. restore database files until time '09/28/2008:18:00:00';
• C. restore database until time '09/28/2008:18:00:00';
• D. recover database until time '09/28/2008:18:00:00';
• E. recover database until timestamp '09/28/2008:18:00:00';

Answer: C

NEW QUESTION 15

Which of the following statements best describes Flashback Versions Query?

• A. Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.
• B. Flashback Versions Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past.
• C. Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.
• D. Flashback Versions Query is used to view all version changes on rows that existed between two points in time.

Answer: D

NEW QUESTION 16

What methods of point-in-time recovery are available? (Choose all that apply.)

• A. Change-based
• B. Cancel-based
• C. Time-based
• D. Sequence number-based
• E. Transaction number-based

Answer: ABCD

NEW QUESTION 17

View the Exhibit and examine the resource consumption details for the current plan in use by the database instance.
Which two statements are true based on the output? (Choose two.) Exhibit:

• A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an error
• B. A user belonging to DSS_QUERIES can log in to a new session but the session will be queued
• C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management
• D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management, I/O waits, and latch or enqueue contention

Answer: BC

Explanation:
V$RSRC_CONSUMER_GROUP Use the V$RSRC_CONSUMER_GROUP view to monitor resources consumed, including CPU, I/O, and parallel servers. It can also be used to monitor statistics related to CPU resource management, runaway query management, parallel statement queuing, and so on. All of the statistics are cumulative from the time when the plan was activated.
SELECT name, active_sessions, queue_length, consumed_cpu_time, cpu_waits, cpu_wait_time FROM v$rsrc_consumer_group;

C:\Users\albo\Desktop\1-1.jpg
In the preceding query results, the DSS_QUERIES consumer group has four sessions in its active session pool and two more sessions queued for activation.
A key measure in this view is CPU_WAIT_TIME. This indicates the total time that sessions in the consumer group waited for CPU because of resource management. Not included in this measure are waits due to latch or enqueue contention, I/O waits, and so on.

NEW QUESTION 18

You executed the following commands in an RMAN session for your database instance that has failures:
RMAN> LIST FAILURE;
After some time, you executed the following command in the same session: RMAN> ADVISE FAILURE;
But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command.
Which statement is true for the above ADVISE FAILURE command in this scenario?

• A. It produces a warning for new failures before advising for CRITICAL and HIGH failures.
• B. It ignores new failures and considers the failures listed in the last LIST FAILURE command only.
• C. It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.
• D. It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.

Answer: A

NEW QUESTION 19

Which tasks can be accomplished using the DBMS_LOB.SETOPTIONS procedure?

• A. only encryption and compression settings for all SecureFile LOBs
• B. only encryption and deduplication settings for only SecureFile CLOBs
• C. deduplication, encryption, and compression settings for all SecureFile LOBs
• D. deduplication, encryption, and compression settings only for SecureFile CLOBs

Answer: C

Explanation:
Refer to here.
DBMS_LOB.SETOPTIONS()
This procedure sets compression, deduplication and encryption features. It enables the features to be set on a per-LOB basis, overriding the default LOB settings. This call incurs a round trip to the server to make the changes persistent.

NEW QUESTION 20

Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause.
Which components are backed up when this option is specified?

• A. only the control file, the current SPFILE, and data files
• B. only the current SPFILE and data files if autobackup is disabled
• C. only the data files and the archived redo logs
• D. the control file, current SPFILE file, data files, and archived redo logs

Answer: D

NEW QUESTION 21

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:
SQL> @utlu111i.sql
Which statement about the execution of this script is true?

• A. It must be executed from the Oracle Database 11g environment.
• B. It must be executed only after the SYSAUX tablespace has been created.
• C. It must be executed from the environment of the database that is being upgraded.
• D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
• E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

Answer: C

Explanation:
Script Name: utlu111i.SQL
Used to: Pre-Upgrade Information
Analyzes the database to be upgraded, detailing requirements and issues for the upgrade to Oracle Database 11g Release 1 (11.1)

NEW QUESTION 22

Which of the following tasks does the tool Incident Packaging Service (IPS) perform?

• A. Cleans up the ADR by deleting files not associated with an incident uploaded to Oracle Support.
• B. Identifies all files associated with a critical error and adds them to a zip file to be sent to Oracle Support.
• C. Automatically opens a Service Request with Oracle Support for each critical error and sends all relevant files.
• D. Displays a high-level view of critical errors on the database home page.

Answer: B

Explanation:
Incident packaging service (IPS) and incident packages
The IPS enables you to automatically and easily gather the diagnostic data—traces, dumps, health check reports, and more—pertaining to a critical error and package the data into a zip file for transmission to Oracle Support. Because all diagnostic data relating to a critical error are tagged with that error's incident number, you do not have to search through trace files and other files to determine the files that are required for analysis; the incident packaging service identifies the required files automatically and adds them to the zip file.
Before creating the zip file, the IPS first collects diagnostic data into an intermediate logical structure called an incident package (package). Packages are stored in the Automatic Diagnostic Repository. If you choose to, you can access this intermediate logical structure, view and modify its contents, add or remove additional diagnostic data at any time, and when you are ready, create the zip file from the package. After these steps are completed, the zip file is ready to be uploaded to Oracle Support.

NEW QUESTION 23

What is the advantage of setting the ASM-preferred mirror read for the stretch cluster configuration?

• A. It improves resync operations.
• B. This feature enables much faster file opens.
• C. It improves performance as fewer extent pointers are needed in the shared pool.
• D. It improves performance by reading from a copy of an extent closest to the node.

Answer: D

Explanation:
Preferred Read Failure Groups
When you configure Oracle ASM failure groups, it might be more efficient for a node to read from an extent that is closest to the node, even if that extent is a secondary extent. In other words, you can configure Oracle ASM to read from a secondary extent if that extent is closer to the node instead of Oracle ASM reading from the primary copy which might be farther from the node. Using the preferred read failure groups feature is most useful in extended clusters.

NEW QUESTION 24

Which of the following are valid program types for a lightweight job? (Choose all that apply.)

• A. PLSQL_BLOCK
• B. EXECUTABLE
• C. JAVA_STORED_PROCEDURE
• D. STORED_PROCEDURE
• E. EXTERNAL

Answer: AD

Explanation:
Job_type
Job action type ('PLSQL_BLOCK', 'STORED_PROCEDURE', 'EXECUTABLE', or 'CHAIN')

NEW QUESTION 25
......