NEW QUESTION 1

When you create a backup control file, where is the resulting file written to?

• A. The database user dump destination directory
• B. The database diagnostic destination directory
• C. To $ORACLE_HOME/rdbms
• D. To $ORACLE_HOME/admin
• E. To the directory and filename you specify in the command

Answer: E

NEW QUESTION 2

You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:
ALTER TABLE employees SHRINK SPACE CASCADE;
Which statement is correct in this scenario?

• A. The EMPLOYEES table will be changed to read-only mode during the shrink operation.
• B. The indexes created on the EMPLOYEES table will need to be rebuilt after the shrinkoperation is over.
• C. The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.
• D. Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.

Answer: C

NEW QUESTION 3

Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS, which statement is true?

• A. You cannot perform the TSPITR with the constraints enabled.
• B. You must perform the TSPITR recovery of both tablespaces for it to be successful.
• C. You can perform TSPITR only on the USERS tablespace.
• D. RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it automatically.
• E. The TSPITR will only be successful if the constraint is enabled.

Answer: B

NEW QUESTION 4

Which statement about Automatic Memory Management with Oracle 11g is true?

• A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.
• B. Oracle can reallocate memory between the SGA and PGA automatically as needed.
• C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.
• D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.

Answer: B

NEW QUESTION 5

Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?

• A. Create new indexes.
• B. Modify existing indexes.
• C. Implement partitioning on a nonpartitioned table.
• D. Create materialized views.
• E. All of the above

Answer: E

Explanation:
Overview of SQL Access Advisor
Materialized views, partitions, and indexes are essential when tuning a database to achieve optimum performance for complex, data-intensive queries. SQL Access Advisor helps you achieve your performance goals by recommending the proper set of materialized views, materialized view logs, partitions, and indexes for a given workload. Understanding and using these structures is essential when optimizing SQL as they can result in significant performance improvements in data retrieval. The advantages, however, do not come without a cost. Creation and maintenance of these objects can be time consuming, and space requirements can be significant. In particular, partitioning of an unpartitioned base table is a complex operation that must be planned carefully.

NEW QUESTION 6

Which pseudocolumn could you use to identify a unique row in a Flashback Versions
Query?

• A. XID
• B. VERSIONS_PK
• C. VERSIONS_XID
• D. VERSIONS_UNIQUE

Answer: C

NEW QUESTION 7

View the Exhibit and examine the data manipulation language (DML) operations that you performed on the NEWEMP table. Note that the first two updated are not listed by the Flashback Versions Query.
What could be the reason? Exhibit:

• A. The first two updated were not explicitly committed.
• B. ALTER TABLE caused the recycle bin to release the space.
• C. The data definition language (DDL) operation caused a log switch.
• D. Flashback Versions Query stops producing versions of rows that existed before a change in the table structure.

Answer: C

NEW QUESTION 8

NLS parameters can be set using the five methods listed. Put the methods in order from highest to lowest according to Oracles order of precedence:
a: Default setting
b: Client environment variable
c: Explicit ALTER SESSION statement d: Inside SQL function
e: Server initialization parameter

• A. b, d, e, a, c
• B. e, a, b, c, d
• C. d, c, b, e, a
• D. a, b, d, c, e
• E. d, c, b, a, e

Answer: C

Explanation:

C:\Users\albo\Desktop\1-1.jpg

NEW QUESTION 9

To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:

The blocks of code execute successfully; however, you do not get the required outcome. What could be the reason?

• A. A template needs to be associated with the task.
• B. A workload needs to be associated with the task.
• C. The partial or complete workload scope needs to be associated with the task.
• D. The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task.

Answer: B

NEW QUESTION 10

What command would you issue to enable automated backups of control files?

• A. alter database controlfile autobackup on
• B. alter system controlfile autobackup on
• C. configure controlfile autobackup on
• D. enable controlfile autobackup

Answer: C

NEW QUESTION 11

In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file.
Which option must you consider for this task?

• A. using only the RMAN SWITCH command to set the new location for the data file
• B. placing the database in the MOUNT state for the restore and recovery operations.
• C. using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.
• D. configuring two channels: one for the restore operation and the other for the recovery operation

Answer: C

NEW QUESTION 12

You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline.
Which action would you take before performing this task?

• A. Compute the baseline statistics.
• B. Take an immediate AWR snapshot.
• C. Decrease the window size for the baseline.
• D. Decrease the expiration time for the baseline.

Answer: A

Explanation:
A moving window baseline corresponds to all AWR data that exists within the AWR retention period. This is useful when using adaptive thresholds because the database can use AWR data in the entire AWR retention period to compute metric threshold values.

NEW QUESTION 13

Which of the following parameters defines the location where Oracle should create archived redo logs?

• A. LOG_ARCHIVE_1
• B. LOG_DESTINATION_1
• C. LOG_ARCHIVED_DESTINATION_1
• D. LOG_ARCHIVE_DEST_1
• E. LOG_ARCHIVE_SOURCE_1

Answer: D

NEW QUESTION 14

Which of the following statements are true about the BACKUP command? (Choose all that apply.)

• A. The BACKUP command can not be used to make image copies of a datafile.
• B. The BACKUP command can improve performance by multiplexing backup files.
• C. The BACKUP can take advantage of the block-change tracking capability.
• D. The BACKUP command cannot store data in incremental backups.
• E. The BACKUP command can store data in cumulative incremental backups only.

Answer: BC

NEW QUESTION 15

Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member.
When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\REDO01.LOG'
You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?

• A. ALTER DATABASE DROP LOGFILE GROUP 1;
• B. ALTER DATABASE CLEAR LOGFILE GROUP 1;
• C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
• D. ALTER DATABASE DROP LOGFILE MEMBER 'D:\REDO01.LOG';

Answer: C

NEW QUESTION 16

A user sends you an email with the following error message:
create table idtable(id number)
* ERROR at line 1:
ORA-01116: error in opening database file 4
ORA-01110: data file 4: '/oracle01/oradata/orcl/users01.dbf'
ORA-27041: unable to open file Linux Error: 2: No such file or directory Additional information: 3
You can choose from the following steps:
a: Restore the missing database datafiles. b: Take the missing datafile offline.
c: Shut down the database.
d: Issue the recover tablespace USERS command.
e: Issue the Startup Mount command to mount the database. f: Bring the USERS tablespace online.
g: Issue the alter database open command.
Which is the correct order of these steps in this case?

• A. b, a, d, f
• B. c, a, e, b, d, f, g
• C. c, e, d, g
• D. b, d, f
• E. e, d, g

Answer: A

Explanation:
RMAN> repair failure;
Strategy: The repair includes complete media recovery with no data loss
Repair script: /u01/app/oracle/diag/rdbms/test0924/test0924/hm/reco_172511374.hm contents of repair script:
# restore and recover datafile
sql 'alter database datafile4 offline'; restore datafile 4;
recover datafile 4;
sql 'alter database datafile 4 online';

NEW QUESTION 17

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 opertion

Answer: A

NEW QUESTION 18

Which of the following is NOT an advantage of block media recovery (BMR)?

• A. Reduced MTTR.
• B. Datafiles remain offline while corrupt blocks are repaired.
• C. Datafiles remain online while corrupt blocks are repaired.
• D. A and C

Answer: B

Explanation:
Overview of Block Media Recovery (link) Purpose of Block Media Recovery
You can use block media recovery to recover one or more corrupt data blocks within a data file. Block media recovery provides the following advantages over data file media recovery:
✑ Lowers the mean time to recover (MTTR) because only blocks needing recovery are restored and recovered
✑ Enables affected data files to remain online during recovery
Without block media recovery, if even a single block is corrupt, then you must take the data file offline and restore a backup of the data file. You must apply all redo generated for the data file after the backup was created. The entire file is unavailable until media recovery completes. With block media recovery, only the blocks actually being recovered are unavailable during the recovery.
Block media recovery is most useful for physical corruption problems that involve a small, well-known number of blocks. Block-level data loss usually results from intermittent, random I/O errors that do not cause widespread data loss, and memory corruptions that are written to disk. Block media recovery is not intended for cases where the extent of data loss or corruption is unknown and the entire data file requires recovery. In such cases, data file media recovery is the best solution.

NEW QUESTION 19

Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? (Choose all that apply.)

• A. SET_ATTRIBUTE_NULL
• B. ALTER_JOB
• C. ALTER_JOB_PARAMETERS
• D. ALTER
• E. SET_ATTRIBUTE

Answer: AE

Explanation:
SET_ATTRIBUTE_NULL Procedure, Changes an attribute of an object to NULL SET_ATTRIBUTE Procedure, Changes an attribute of a job, schedule, or other Scheduler object
There is NO such "ALTER_JOB", "ALTER_JOB_PARAMETERS" and "ALTER" procedure available.

NEW QUESTION 20

You want to perform the following operations for the DATA ASM disk group:
✑ Verify the consistency of the disk.
✑ Cross-check all the file extent maps and allocation tables for consistency.
✑ Check whether the alias metadata directory and file directory are linked correctly.
✑ Check that ASM metadata directories do not have unreachable allocated blocks.
Which command accomplishes these tasks?

• A. ALTER DISKGROUP data CHECK;
• B. ALTER DISKGROUP data CHECK DISK;
• C. ALTER DISKGROUP data CHECK FILE;
• D. ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;

Answer: A

Explanation:
Syntax: ALTER DISKGROUP <disk_group_id> CHECK [REPAIR | NOREPAIR];
The check_diskgroup_clause lets you verify the internal consistency of Oracle ASM disk group metadata. The disk group must be mounted. Oracle ASM displays summary errors and writes the details of the detected errors in the alert log.
The CHECK keyword performs the following operations:
✑ Checks the consistency of the disk.
✑ Cross checks all the file extent maps and allocation tables for consistently.
✑ Checks that the alias metadata directory and file directory are linked correctly.
✑ Checks that the alias directory tree is linked correctly.
✑ Checks that Oracle ASM metadata directories do not have unreachable allocated blocks.
Refer to here

NEW QUESTION 21

How would you grant the RVPC user access to specific RMAN database records in the
RMAN virtual private catalog?

• A. Issue the grant command from the SYS user (or equivalent) of the target database.
• B. Issue the grant command from the SYS user (or equivalent) of the recovery-catalog database.
• C. Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.
• D. Issue the grant command from RMAN when connected to the recovery catalog-owning schema.
• E. Issue the grant command from RMAN when connected to the target database.

Answer: D

NEW QUESTION 22

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 23

You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message:
SQL> startup
ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file
'C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE
\INITORCL.ORA'
Using RMAN, how would you respond to this error?

• A. Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.
• B. Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.
• C. Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.
• D. Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.
• E. Issue the restore spfile from autobackup command from the RMAN prompt.

Answer: C

NEW QUESTION 24

Examine the following RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which prerequisite must be met before accomplishing the backup?

• A. Provide a password for the encryption
• B. Set up an Oracle wallet for the encryption
• C. No setup is required as it is a default encryption method
• D. Both Oracle wallet and password must be set up for the encryption

Answer: B

NEW QUESTION 25

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 26
......