NEW QUESTION 1

Which two statements are true about encrypting RMAN backup? (Choose two.)

• A. The transparent encryption of backups uses the encryption wallet
• B. The database uses the same encryption key for every encrypted backup
• C. The password encryption of backups only uses the password while creating and restoring backup

Answer: AC

NEW QUESTION 2

View the Exhibits exhibit1 and exhibit2.
Both the processes use PROG_1 as the job template that is already available. The time taken by the jobs are recorded in the TEST_LOG table. While comparing the time taken to create the jobs, the process in exhibit1 takes less time than the process in exhibit2.
What is the reason for this? lightweight-job-1 (exhibit):

lightweight-job-2 (exhibit):

• A. It updates several tables in the SYSTEM tablespace instead of creating new tables.
• B. It creates jobs temporarily in memory only.
• C. It creates less metadata for the jobs.
• D. It writes the job metadata to disk in compressed format.

Answer: C

Explanation:
The difference between two blocks of code is the "JOB_STYLE". The lightweight job creates less metadata for the jobs.

NEW QUESTION 3

Which two statements are true regarding hot patching? (Choose two.)

• A. It requires relinking of the Oracle binary.
• B. It does not require database instance shutdown.
• C. It can detect conflicts between two online patches.
• D. It is available for installing all patches on all platforms.
• E. It works only in a single database instance environment.

Answer: BC

Explanation:
Online Patching
Regular patches typically contain .o (object) files and/or .a (archive) libraries, and therefore require a relink of the RDBMS binary. Online patches, however, contain .so files, which are dynamic/shared libraries, and do not require a relink of the RDBMS binary. Consequently, since a relink is not needed, you can apply or roll back online patches while the RDBMS instance is running. This simplifies administration, because no downtime is needed, and also results in a much quicker turnaround time for installing or de-installing Online Patches.
A regular RDBMS patch can require many minutes to install, since it requires instance shutdown, a relink, and instance startup. On the other hand, you can install an online patch in just a few seconds.
Online patches are only applicable for Oracle RDBMS and not any other products. Online patches are currently supported on the following Windows and UNIX platforms for version 11.2.0.1.0 and later:
✑ Linux x86
✑ Linux x86_64
✑ HP-UX Itanium
✑ Solaris SPARC 64-bit
✑ Solaris AMD 64-bit
✑ AIX (AIX 6.1 and later)
About Patch Conflicts:
All patches may not be compatible with one another. For example, if you apply a patch, all the bugs the patch fixes could reappear after you apply another patch. This is called a conflict situation. OPatch detects such situations and raises an error when it detects a
conflict.

NEW QUESTION 4

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 5

You opened the encryption wallet and then issued the following command:
SQL>CREATE TABLESPACE securespace DATAFILE '/home/user/oradata/secure01.dbf' SIZE 150M
ENCRYPTION USING '3DES168' DEFAULT STORAGE(ENCRYPT);
Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.
What is the outcome?

• A. It creates the table and encrypts the data in it.
• B. It generates an error because the wallet is closed.
• C. It creates the table but does not encrypt the data in it.
• D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.

Answer: B

NEW QUESTION 6

Consider the following scenario for your database:
✑ Backup optimization is enabled in RMAN.
✑ The recovery window is set to 7 days in RMAN.
✑ The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.
✑ The TOOLS tablespace is read-only since November 4, 2007.
On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?

• A. The RMAN backup fails because the TOOLS tablespace is read-only
• B. The RMAN skips the backup of the tablespace because backup optimization is enabled
• C. The RMAN makes backup because optimization can be enabled only for backups to disk
• D. The RMAN makes the backup because no backup of the tablespace exists within the seven day window

Answer: D

NEW QUESTION 7

Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?

• A. AWR baselines are always created as repeating baselines.
• B. AWR baselines can be created on the basis of two time values.
• C. AWR baselines are always created with infinite expiration duration.
• D. AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration.

Answer: B

NEW QUESTION 8

In a Database Replay workload capture, what client request information is gathered?
(Choose all that apply.)

• A. SQL text
• B. Shared server requests (Oracle MTS)
• C. Bind variable values
• D. Information about transactions
• E. Remote DESCRIBE and COMMIT operations

Answer: ACD

NEW QUESTION 9

The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3.The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog.
The RVPC user can do which of the following? (Choose all that apply.)

• A. Register databases if granted the register database privilege
• B. See all databases in the recovery-catalog schema
• C. See all database-related metadata in the recovery catalog if they are granted access to that database
• D. Unregister databases from the RVPC catalog that were not granted to the RVPC catalog owner with the grant command
• E. Not be connected to with the RMAN command-line catalog parameter for backup or recovery purposes

Answer: AC

NEW QUESTION 10

You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to 'ora_%t_%s_%r.log'. Which statement regarding the archived redo log files, created in an earlier incarnation of the database, is true?

• A. The archived redo log files will be overwritten.
• B. The archived redo log files are deleted automatically.
• C. The archived redo log files should be moved to some other location.
• D. The archived redo log files are still maintained because the file names are unique.

Answer: D

NEW QUESTION 11

True or false: you can perform an active database duplication when the database is in NOARCHIVELOG mode.

• A. True
• B. False

Answer: B

NEW QUESTION 12

In what view are you likely to see the following output?

• A. V$SESSION_EVENT
• B. V$SESSION
• C. V$WAITS
• D. V$WAITSTAT
• E. V$SYSSTAT

Answer: B

NEW QUESTION 13

The following command is executed to create the baseline template:
SQL> EXECUTE DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE( START_TIME=> TO_TIESTAMP(SYSDATE+2), END_TIME=>TO_TIMESTAMP(SYSDATE+10),
BASELINE_NAME=>'Mybase4', TEMPLATE_NAME=>'Mytemp4', EXPIRATION=>NULL);
Which statement is true about the effect of the above command?

• A. It creates a baseline template that never expires.
• B. It produces an error because no snapshot information is provided to create the baseline.
• C. It creates a baseline template that expires after the Automatic Workload Repository (AWR) retention period.
• D. It creates a repeating baseline template that repeats after the Automatic Workload Repository (AWR) retention period.

Answer: A

NEW QUESTION 14

Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database?

• A. Option A
• B. Option B
• C. Option C
• D. Option D
• E. Option E

Answer: E

NEW QUESTION 15

View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks. You executed the following commands:
SQL> VAR tname VARCHAR2(60); SQL> BEGIN
:tname := 'my_instance_analysis_mode_task'; DBMS_ADDM.INSERT_SEGMENT_DIRECTIVE(:tname,'Sg_directive','SCOTT'); END;
Which statement describes the consequence? Exhibit:

• A. The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
• B. The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only.
• C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state.
• D. All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT schema.

Answer: C

Explanation:
sys@TEST1107> VAR tname VARCHAR2(60);
sys@TEST1107> BEGIN :tname := 'my_instance_analysis_mode_task';
2 DBMS_ADDM.INSERT_SEGMENT_DIRECTIVE(:tname,'Sg_directive','SCOTT');
3 END;
4 /
PL/SQL procedure successfully completed.
sys@TEST1107> SELECT DBMS_ADVISOR.GET_TASK_REPORT(:tname, 'TEXT', 'ALL') FROM
DUAL; ERROR:
ORA-13631: The most recent execution of task my_instance_analysis_mode_task contains no results.
ORA-06512: at "SYS.PRVT_ADVISOR", line 3189 ORA-06512: at "SYS.DBMS_ADVISOR", line 590
ORA-06512: at line 1 no rows selected

NEW QUESTION 16

You executed the following query:
SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG;
Considering that all the redo logs are available, what information can you derive from the output of the preceding query?

• A. The time when the last flashback operation in your database was performed
• B. The time when the first flashback operation in your database was performed
• C. The approximate time and the lowest system change number (SCN) to which you can flash back your database
• D. The system change number (SCN) and the time when the Flashback Database was enabled in the database instance

Answer: C

Explanation:
V$FLASHBACK_DATABASE_LOG displays information about the flashback data. Use this view to help estimate the amount of flashback space required for the current workload.

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

NEW QUESTION 17

Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)

• A. Database must be running in archivelog mode.
• B. Automatic undo management must be enabled.
• C. Undo retention guarantee must be enabled.
• D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).

Answer: BD

NEW QUESTION 18

You executed the following commands:
SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false; SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS('SH', 'CUSTOMERS',
'PUBLISH','false');
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH', 'CUSTOMERS');
Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?

• A. The statistics are stored in the pending statistics table in the data dictionary.
• B. The statistics are treated as the current statistics by the optimizer for all sessions.
• C. The statistics are treated as the current statistics by the optimizer for the current sessions only.
• D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.

Answer: A

NEW QUESTION 19

What RMAN command is used to execute a tablespace point-in-time recovery?

• A. recover
• B. duplicate
• C. restore
• D. copy
• E. None of the above

Answer: A

NEW QUESTION 20

The ADMIN_EMP table has columns EMPNO, ENAME, DEPTNO, and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema.
What action is required for the dependent objects when you perform online redefinition on the table?

• A. The materialized view should have a complete refresh performed after the online table redefinition is completed.
• B. The materialized view should have a fast refresh performed after the online table redefinition is completed.
• C. The materialized view, materialized log, and the index should be dropped and re-created after the online table redefinition is complete.
• D. The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.

Answer: A

Explanation:
Restrictions for Online Redefinition of Tables
✑ After redefining a table that has a materialized view log, the subsequent refresh of any dependent materialized view must be a complete refresh.

NEW QUESTION 21

Which three functions are performed by the SQL Tuning Advisor? (Choose three.)

• A. Building the SQL profile
• B. Recommending optimization of materialized views
• C. Checking query objects for missing and stale statistics
• D. Recommending bitmap, function-based, and B-tree indexes
• E. Recommending restructuring SQL queries that are using bad plans

Answer: ACE

NEW QUESTION 22

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 23

You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database, as shown here:
1. Put the tablespaces in backup mode.
2. Back up the datafiles for all tablespaces.
3. Take the tablespaces out of backup mode.
4. Back up all archived redo logs.
Your colleague asks for you to comment on his plan. Which response would be correct?

• A. The plan will work as is.
• B. The plan needs to be modified to allow for an archive-log switch after step 3.
• C. The plan needs to be modified so that a backup of the archived redo logs occurs before step 1.
• D. The plan needs to be adjusted to shut down the database after step 1 and to restart the database after step 2.
• E. The plan cannot work as presented.

Answer: B

Explanation:
Without command ALTER SYSTEM SWITCH LOGFILE, the backup of archive redo logs will be useless.

NEW QUESTION 24

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