NEW QUESTION 1

A user named Arren is executing this query:
select table_name, operation, undo_sql from
flashback_transaction_query t, (select versions_xid as xid
from employees versions between scn minvalue and maxvalue
where employee_id = 123) e where t.xid = e.xid;
When the query runs, he receives an ORA-01031: insufficient privileges error. Since the user owns the employees table, you know that it is not the problem.
Which of the following SQL statements will correct this problem?

• A. GRANT SELECT ANY TRANSACTION TO ARREN;
• B. GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARREN;
• C. GRANT SELECT_ANY_TRANSACTION TO ARREN;
• D. GRANT FLASHBACK TO ARREN;
• E. GRANT SELECT ANY VIEW TO ARREN;

Answer: A

NEW QUESTION 2

Which of these recommendations should be followed before capturing a workload? (Choose all that apply.)

• A. Make sure your replay database has the same structure as the capture database, except without data.
• B. Make sure the replay and capture databases are similar in data content.
• C. Perform a clean shutdown and restart of the capture database before beginning a workload capture.
• D. Start the capture database in UNRESTRICTED mode, then start the capture.
• E. Define inclusion and exclusion filters.

Answer: BC

NEW QUESTION 3

At the request of a user, you issue the following command to restore a dropped table: SQL> flashback table "BIN$F2JFfMq8Q5unbC0ceE9eJg==$0" to before drop;
Later, the user notifies you that the data in the table seems to be very old and out of date. What might be the problem?

• A. Because a proper range of SCNs was not specified, the wrong data was restored.
• B. A proper range of timestamps was not specified, so the wrong data was restored.
• C. A previous Flashback Drop operation had been performed, resulting in multiple versions of the table being stored in the Recycle Bin.
• D. Either option A or B could be correc
• E. Not enough information was provided to determine which.
• F. None of the above.

Answer: C

NEW QUESTION 4

You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it.
You issued the following command to drop the Flashback Archive FLA1: DROP FLASHBACK ARCHIVE fla1;
What is the effect of this command?

• A. The Flashback Archive FLA1 is dropped only if it is empty.
• B. The tablespace having Flashback Archive is dropped.
• C. The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
• D. The Flashback Data Archive and historical data are dropped.

Answer: D

NEW QUESTION 5

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 6

You issued the following command:
CREATE GLOBAL TEMPORARY TABLE admin_work_area (startdate DATE, enddate DATE, class CHAR(20))
ON COMMIT DELETE ROWS TABLESPACE tbs_t1;
An index is then created on the ADMIN_WORK_AREA temporary table.
Which two statements are true regarding the TBS_T1 tablespace in the above command? (Choose two.)

• A. It stores only the temporary table but not its indexes.
• B. It stores both the temporary table as well as its indexes.
• C. It must be a nondefault temporary tablespace for the database.
• D. It can be a default or nondefault temporary tablespace for the database.
• E. It must be the default temporary tablespace of the user who issues the command.

Answer: BD

NEW QUESTION 7

Which two client requests are captured during database replay Capture? (Choose two)

• A. Flashback queries
• B. Shared server requests
• C. Login and logoff activities of sessions
• D. Direct path load of data from external files by using utilities such as SQL *loader
• E. Data definition language (DDL) and data manipulation language (DML) operations

Answer: CE

Explanation:
9.3 Workload Capture Restrictions
Certain types of user sessions and client requests may sometimes be captured in a workload, but they are not supported by Database Replay. Capturing these session and request types in a workload may result in errors during workload replay.
The following types of user sessions and client requests are not supported by Database Replay:
✑ Direct path load of data from external files using utilities such as SQL*Loader
✑ Non-PL/SQL based Advanced Queuing (AQ)
✑ Flashback queries
✑ Oracle Call Interface (OCI) based object navigations
✑ Non SQL-based object access
✑ Distributed transactions, Any distributed transactions that are captured will be replayed as local transactions.
✑ XA transactions, XA transactions are not captured or replayed. All local transactions are captured.
✑ JAVA_XA transactions, If the workload uses the JAVA_XA package, JAVA_XA function and procedure calls are captured as normal PL/SQL workload. To avoid problems during workload replay, consider dropping the JAVA_XA package on the
replay system to enable the replay to complete successfully.
✑ Database Resident Connection Pooling (DRCP)
✑ Workloads using OUT binds
✑ Multi-threaded Server (MTS) and shared server sessions with synchronization mode set to
OBJECT_ID
✑ Migrated sessions, The workload is captured for migrated sessions. However, user logins or session migration operations are not captured. Without a valid user login or session migration, the replay may cause errors because the workload may be replayed by a wrong user.
Typically, Database Replay refrains from capturing these types of non-supported user sessions and client requests. Even when they are captured, Database Replay will not replay them. Therefore, it is usually not necessary to manually filter out non-supported user sessions and client requests. In cases where they are captured and found to cause errors during replay, consider using workload capture filters to exclude them from the workload.

NEW QUESTION 8

Which statements about the MEMORY_TARGET initialization parameter are true? (Choose all that apply.)

• A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zero
• B. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
• C. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.
• D. MEMORY_TARGET is static and cannot be modified without shutting down the instance

Answer: ABC

NEW QUESTION 9

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.

NEW QUESTION 10

While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?

• A. The backup fails because one of the archived redo log files is missing.
• B. The backup succeeds but it would be without the missing archived log.
• C. During backup, you are prompted for the alternative destination for the missing archived redo log file.
• D. The backup succeeds because it fails over to one of the alternative archived redo log destinations.

Answer: D

NEW QUESTION 11

Which of the following does the recover command not do?

• A. Restore archived redo logs.
• B. Apply archived redo logs.
• C. Restore incremental backups.
• D. Apply incremental backups.
• E. Restore datafile images.

Answer: A

NEW QUESTION 12

View the Exhibit and examine the Data Pump architecture. Identify the numbered components.
Exhibit:

• A. 1 - Oracle Loader, 2 - Oracle Data Pump, 3 - Direct Path API
• B. 1 - Oracle Data Pump, 2 - Direct Path API, 3 - Oracle Loader
• C. 1 - Direct Path API, 2 - Oracle Loader, 3 - Oracle Data Pump
• D. 1 - Oracle Loader, 2 - Direct Path API, 3 - Oracle Data Pump

Answer: A

NEW QUESTION 13

Which three actions are required to configure the Flashback Database? (Choose three.)

• A. set Flash Recovery Area
• B. enable Flashback logging
• C. create FLASHBACK tablespace
• D. start the database in the ARCHIVELOG mode
• E. start the database in the NOARCHIVELOG mode

Answer: ABD

NEW QUESTION 14

View Exhibit1 to examine the CRS11G disk group when all the disks are online. View Exhibit2 to examine the CRS11G disk group when one disk is offline.
Why is the rebalancing not performed and the content of the disk group not empty in Exhibit2?
ASM-disk-group-1 (exhibit):

ASM-disk-group-2 (exhibit):

• A. Because the disk group is created with NORMAL redundancy
• B. Because the disk repair time attribute is set to a nonzero value
• C. Because the mirrored extents cannot be rebalanced across the other three disks
• D. Because the other three disks have 60% free space, the disk rebalancing is delayed

Answer: B

Explanation:
Key points:
1. The COMPATIBILITY.ASM>=11.1 and COMPATIBILITY.RDBMS>=11.1
2. The DISK_REPAIR_TIME is set to non-zero. by default it is 3.6hr. Refer to here.
Note: To use this feature, the disk group compatibility attributes must be set to 11.1 or higher. For more information, refer to "Disk Group Compatibility".
Oracle ASM fast resync keeps track of pending changes to extents on an OFFLINE disk during an outage. The extents are resynced when the disk is brought back online.
By default, Oracle ASM drops a disk in 3.6 hours after it is taken offline. You can set the DISK_REPAIR_TIME disk group attribute to delay the drop operation by specifying a time interval to repair the disk and bring it back online.

NEW QUESTION 15

Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery catalog. (Choose two.)

• A. configuring control file autobackup to be ON
• B. backing up data filed only and not the archived redo log files
• C. running the recovery catalog database in NOARCHIVELOG mode.
• D. setting the retention policy to a REDUNDANCY value greater than 1
• E. backing up the recovery catalog to the same disk as that of the target database

Answer: AD

Explanation:
Refer to here.
Configuring the Recovery Catalog Database
When you use a recovery catalog, RMAN requires that you maintain a recovery catalog schema. The recovery catalog is stored in the default tablespace of the schema. The SYS user cannot be the owner of the recovery catalog.
Decide which database you will use to install the recovery catalog schema, and also how you will back up this database. Also, decide whether to operate the catalog database in ARCHIVELOG mode, which is recommended.
Note: Do not use the target database to be backed up as the database for the recovery catalog. The recovery catalog must be protected if the target database is lost.

NEW QUESTION 16

Which statement about using RMAN stored scripts is true?

• A. To create and execute an RMAN stored script, you must use a recovery catalog.
• B. When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.
• C. RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
• D. When you execute a stored script, it always executes using the persistent channelsettings previously set with the CONFIGURE command.

Answer: A

Explanation:
About Stored Scripts
You can use a stored script as an alternative to a command file for managing frequently used sequences of RMAN commands. The script is stored in the recovery catalog rather than on the file system.
Stored scripts can be local or global. A local script is associated with the target database to which RMAN is connected when the script is created, and can only be executed when you are connected to that target database. A global stored script can be run against any database registered in the recovery catalog, if the RMAN client is connected to the recovery catalog and a target database.
The commands allowable within the brackets of the CREATE SCRIPT command are the same commands supported within a RUN block. Any command that is legal within a RUN command is permitted in the stored script. The following commands are not legal within stored scripts: RUN, @, and @@.
When specifying a script name, RMAN permits but generally does not require that you use quotes around the name of a stored script. If the name begins with a digit or is an RMAN reserved word, however, then you must put quotes around the name to use it as a stored script name. Consider avoiding stored script names that begin with nonalphabetic characters or that are the same as RMAN reserved words.

NEW QUESTION 17

Every resource plan must contain an allocation to which consumer group?

• A. LOW_GROUP
• B. SYS_GROUP
• C. DEFAULT_GROUP
• D. BASE_GROUP
• E. OTHER_GROUPS

Answer: E

NEW QUESTION 18

If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated? (Choose all that apply.)

• A. The next time you back up the database when you are also connected to the recovery catalog and the target database
• B. The next time you are connected to the target database and the recovery catalog database and issue the resync command
• C. The next time you connect RMAN to just the recovery catalog
• D. The next time you connect to the recovery catalog and the target database with RMAN
• E. Connecting to the recovery catalog and issuing the resync all databases command

Answer: AB

Explanation:
Deciding When to Resynchronize the Recovery Catalog
RMAN automatically resynchronizes the recovery catalog when
✑ RMAN is connected to a target database and recovery catalog
✑ And you have executed RMAN commands.
Thus, you should not need to manually run the RESYNC CATALOG command very often.

NEW QUESTION 19

To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used? (Choose all that apply.)

• A. LOG_HISTORY
• B. JOB_LOG_RETENTION
• C. WINDOW_LOG_RETENTION
• D. WHICH_LOG
• E. LOG_NAME

Answer: AD

Explanation:
----------------------------------------------
Attributes list of SET_SCHEDULE_ATTRIBUTE:
'default_timezone': Repeating jobs and windows that use the calendaring syntax retrieve the time
zone from this attribute when start_date is not specified. See "Calendaring Syntax" for more information.
'email_server': The SMTP server address that the Scheduler uses to send e-mail notifications for job state events. E-mail notifications cannot be sent if this attribute is NULL. 'email_sender': The default e-mail address of the sender of job state e-mail notifications. 'email_server_credential': The schema and name of an existing credential object that SYS has execute object privileges on. Default is NULL. The username and password stored in this credential are used to authenticate with the e-mail server when sending e-mail notifications. This functionality is available with Oracle Database 11g Release 2 (11.2.0.2). 'email_server_encryption': This attribute indicates whether or not encryption is enabled for this email server connection, and if so, at what point encryption starts, and with which protocol. This functionality is available starting with Oracle Database 11g Release 2 (11.2.0.2). Values are:
NONE: the default, indicating no encryption used
SSL_TLS: indicating that either SSL or TLS are used, from the beginning of the connection STARTTLS:indicating that the connection starts unencrypted, but the command STARTTLS is sent to the e-mail server and starts encryption
'event_expiry_time': The time, in seconds, before a job state event generated by the Scheduler expires from the Scheduler event queue. If NULL, job state events expire after 24 hours.
'log_history': The number of days that log entries for both the job log and the window log are retained. Default is 30 and the range of valid values is 0 through 1000000. 'max_job_slave_processes': This Scheduler attribute is not used.
The PURGE_LOG Procedure uses "WHICH_LOG" and "LOG_NAME" attributes. Syntax

C:\Users\albo\Desktop\1-1.jpg Parameters
log_history
This specifies how much history (in days) to keep. The valid range is 0 - 1000000. If set to 0, no history is kept.
which_log
This specifies the log type. Valid values are: job_log, window_log, and job_and_window_log.
job_name
This specifies which job-specific entries must be purged from the jog log. This can be a comma-delimited list of job names and job classes. Whenever job_name has a value other than NULL, the which_log argument implicitly includes the job log.

NEW QUESTION 20

You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don't want to have to rebuild the disks from scratch.
What do you do?

• A. Take the whole disk group offline and wait for the controller card to be installe
• B. Once it's installed, bring the disk group online again.
• C. Change the ASM parameter ASM_PREFERRED_READ_FAILURE_GROUPS to indicate that you want to read from the non-failed dis
• D. Once the disk controller is replaced, reset the parameter to its original value.
• E. You have no choice but to rebuild the dis
• F. Drop the disk from the disk group and wait for the controller to be replace
• G. Once the controller is replaced, add the disk back into the disk group and allow ASM to rebuild it.
• H. If you are using any setting other than REDUNDANCY EXTERNAL for your disk group, you will have to recover any data on that disk from a backu
• I. The database will be unavailable until you can correct the problem and perform recovery.
• J. Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.

Answer: E

NEW QUESTION 21

Evaluate the following command and its output: SQL>SELECT * FROM dba_temp_free_space;
TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
=============== =============== =============== ========== LMTEMP 250609664 101048576 149561088
Which two statements correctly interpret the output? (Choose two.)

• A. FREE_SPACE indicates only the space that is currently unallocated.
• B. ALLOCATED_SPACE indicates only the space currently allocated and in use.
• C. FREE_SPACE indicates only the space that is currently allocated and available for reuse.
• D. ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.
• E. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.

Answer: DE

NEW QUESTION 22

Which statements are true regarding SecureFile LOBs? (Choose all that apply.)

• A. The amount of undo retained is user controlled.
• B. SecureFile LOBs can be used only for nonpartitioned tables.
• C. Fragmentation is minimized by using variable-sized chunks dynamically.
• D. SecureFile encryption allows for random reads and writes of the encrypted data.
• E. It automatically detects duplicate LOB data and conserves space by storing only one copy.

Answer: CDE

Explanation:
One of the new feature of Oracle 11g is that Oracle SecureFiles use variable chunk sizes, which can be as large as 64 MB.By storing these chunks next to one another, Oracle also minimizes fragmentation.
About Deduplication
SecureFiles Intelligent Deduplication, available with the Oracle Advanced Compression Option, enables Oracle Database to automatically detect duplicate LOB data within a LOB column or partition, and conserve space by storing only one copy of the data.
Note that you must have a license for the Oracle Advanced Compression Option before implementing SecureFiles Intelligent Deduplication. See Oracle Database Licensing Information for more information.
Note also that Oracle Streams does not support SecureFiles LOBs that are deduplicated. About Encryption
SecureFiles Intelligent Encryption, available with the Oracle Advanced Security Option, introduces a new encryption facility for LOBs. The data is encrypted using Transparent Data Encryption (TDE), which allows the data to be stored securely, and still allows for random read and write access.

NEW QUESTION 23

Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST?

• A. The default value is the value of the environment variable $ORACLE_HOME; if$ORACLE_HOME isn't set, then the default is set to $ORACLE_BASE.
• B. The default value is the value of the environment variable $ORACLE_BASE; if$ORACLE_BASE isn't set, then it is set to $ORACLE_HOME.
• C. DIAGNOSTIC_DEST is always equal to $ORACLE_HOME.
• D. DIAGNOSTIC_DEST is always equal to $ORACLE_BASE.

Answer: B

Explanation:
The answer is not exact correct.
If the ORACLE_BASE is not set, the default location is $ORACLE_HOME/log

NEW QUESTION 24

For which of the following can you use Segment Shrink? (Choose all that apply.)

• A. Heap tables
• B. Tables with function-based indexes
• C. Indexes
• D. Partitions and subpartitions
• E. None of the above

Answer: ACD

NEW QUESTION 25
......