NEW QUESTION 1
The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace. To accomplish the task, you issued the following command:
SQL> ALTER TABLESPACE hr_data BEGIN BACKUP;
Which two statements are true in this scenario? (Choose two.)

• A. No transaction on the tablespace is allowed but you can perform queries.
• B. The tablespace will automatically come out of backup mode when the file copy is complete.
• C. The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.
• D. The database writes the before image of an entire block to the redo stream before modifyin
• E. block tor the first time.

Answer: CD

Explanation: Making User-Managed Backups of Online Read/Write Tablespaces
You must put a read/write tablespace in backup mode to make user-managed data file backups when the tablespace is online and the database is open. The ALTER TABLESPACE ... BEGIN BACKUP statement places a tablespace in backup mode. In backup mode, the database copies whole changed data blocks into the redo stream. After you take the tablespace out of backup mode with the ALTER TABLESPACE ... END BACKUP or ALTER DATABASE END BACKUP statement, the database advances the data file checkpoint SCN to the current database checkpoint SCN.
When restoring a data file backed up in this way, the database asks for the appropriate set of redo log files to apply if recovery is needed. The redo logs contain all changes required to recover the data files and make them consistent.

NEW QUESTION 2
In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally
caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.
Which method must you use to recover the lost data?

• A. Complete Recovery with online redo log
• B. Complete Recovery with archived redo log
• C. Tablespace Point-in-Time Recovery (TSPITR)
• D. Incomplete Recovery with system change number (SCN)

Answer: C

NEW QUESTION 3
You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE;
The next day, you issue the following command:
BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which statement about the use of the change tracking file is true?

• A. RMAN reads the block change tracking file only when it performs the incremental level 0 backup.
• B. RMAN reads the block change tracking file when it performs both incremental backups.
• C. RMAN reads the block change tracking file only when it performs the incremental level 1 backup.
• D. RMAN does not read the block change tracking file when it performs either incremental backup.

Answer: C

NEW QUESTION 4
What are the different logging modes available in Oracle Database 11g? (Choose two.)

• A. NOLOG mode
• B. NOARCHIVELOG mode
• C. LOGGING mode
• D. HOTDATABASE mode
• E. ARCHIVELOG mode

Answer: BE

NEW QUESTION 5
How many individual archive-log destination directories are supported by Oracle Database11g?

• A. 7
• B. 1
• C. 10
• D. 11
• E. 21

Answer: C

NEW QUESTION 6
Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?

• A. PLSQL_BLOCK
• B. JAVA_STORED_PROCEDURE
• C. STORED_PROCEDURE
• D. EXECUTABLE
• E. None of the above are invalid settings.

Answer: B

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

NEW QUESTION 7
You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE;
Which statement is true of this command?

• A. A different procedure is required to restore a database from compressed backups
• B. The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.
• C. Using this command to create backups minimizes the bandwidth consumed
• D. Using this command to create backups improves the performance of the backup process

Answer: C

NEW QUESTION 8
If you lost your entire database, including the database spfile, control files, online redo logs, and database datafiles, what kind of recovery would be required with RMAN?

• A. Complete database recovery.
• B. Incomplete database recovery.
• C. Approximate database recovery.
• D. Archived database recovery.
• E. The database could not be recovered with RMAN.

Answer: B

NEW QUESTION 9
You want to configure the Flashback Database feature and retain flashback logs for three days.
Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this:
1. Set the retention target:
SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320;
2. Enable Flashback Database:
SQL> ALTER DATABASE FLASHBACK ON;
3. Mount the database:
SQL> STARTUP MOUNT EXCLUSIVE
4. Shutdown the instance:
SQL> SHUTDOWN IMMEDIATE
5. Open the database:
SQL> ALTER DATABASE OPEN;
Choose the correct sequence.

• A. 4, 1, 3, 2, 5
• B. 4, 3, 1, 2, 5
• C. 2, 4, 3, 5, 1
• D. 4, 2, 5, 3, 1

Answer: B

NEW QUESTION 10
The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline.
Which two operations are performed by the optimizer in this scenario? (Choose two.)

• A. The optimizer adds the new plan to the plan history.
• B. The optimizer selects the new plan for the execution of the SQL statement.
• C. The optimizer adds the new plan to the SQL plan baseline as an accepted plan.
• D. The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.
• E. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.

Answer: AE

Explanation: 15.2.2 Selecting SQL Plan Baselines
During the SQL plan baseline selection phase, Oracle Database detects plan changes based on the stored plan history, and selects plans to avoid potential performance regressions for a set of SQL statements.
Each time the database compiles a SQL statement, the optimizer does the following:
1. Uses a cost-based search method to build a best-cost plan
2. Tries to find a matching plan in the SQL plan baseline
3. Does either of the following depending on whether a match is found:
✑ If found, then the optimizer proceeds using the matched plan
✑ If not found, then the optimizer evaluates the cost of each accepted plan in the SQL plan baseline and selects the plan with the lowest cost
The best-cost plan found by the optimizer that does not match any plans in the plan history for the SQL statement represents a new plan. The database adds this plan as a nonaccepted plan to the plan history. The database does not use the new plan until it is verified to not cause a performance regression. However, if a change in the system (such as a dropped index) causes all accepted plans to become non-reproducible, then the optimizer selects the best-cost plan. Thus, the presence of a SQL plan baseline causes the optimizer to use conservative plan selection strategy for the SQL statement.
To enable the use of SQL plan baselines, set the OPTIMIZER_USE_SQL_PLAN_BASELINES initialization parameter to TRUE (default). A SQL plan baseline contains one or more accepted plans.
The plan history is the set of plans, both accepted and not accepted, that the optimizer generates for a SQL statement over time, the plans in the baseline form a subset of the plan history. For example, after the optimizer generates the first acceptable plan for a SQL plan baseline, subsequent plans are part of the plan history but not part of the plan baseline.

C:UsersalboDesktop1-1.jpg

NEW QUESTION 11
View the Exhibit to examine the details for an incident. Which statement is true regarding the status of the incident?
Exhibit:

• A. The incident has been newly created and is in the process of collecting diagnostic information.
• B. The incident is now in the Done state and the ADR can select the incident to be purged.
• C. The DBA is working on the incident and prefers that the incident be kept in the ADR.
• D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support.

Answer: D

NEW QUESTION 12
Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.)

• A. Undo retention guarantee for the database must be configured.
• B. Supplemental log must be enabled for the primary key.
• C. Supplemental log must be enabled.
• D. Execute permission on the DBMS_FLASHBACK package must be granted to the user.

Answer: BCD

NEW QUESTION 13
Which command do you use to create a recovery-catalog schema?

• A. create recovery catalog
• B. create catalog
• C. build catalog
• D. catalog create
• E. mount catalog

Answer: B

Explanation: Use the CREATE CATALOG command to create a recovery catalog.
The recovery catalog can be a base recovery catalog or a virtual private catalog.
✑ A base recovery catalog is a database schema that contains RMAN metadata for a set of target databases.
✑ A virtual private catalog is a set of synonyms and views that enable user access to
a subset of a base recovery catalog.

C:UsersalboDesktop1-1.jpg

NEW QUESTION 14
You run the following commands:
RMAN> list expired backup; RMAN> delete expired backup;
What will happen to the backup set pieces associated with the backups that appear in the list expired backup command?

• A. They will be renamed.
• B. Nothing will happen to the
• C. The backup set pieces do not exist.
• D. They will be deleted immediately since they are not in the flash recovery area.
• E. You will need to manually remove the physical files listed in the output of the commands.
• F. They will become hidden files and removed 10 days later.

Answer: B

NEW QUESTION 15
You have lost all your online redo logs. As a result, your database has crashed. You have tried to restart the database and clear the online redo log files, but when you try to open the database you get the following error.
SQL> startup
ORACLE instance started.
Total System Global Area 167395328 bytes Fixed Size 1298612 bytes
Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes Database mounted.
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/oracle01/oradata/orcl/redo02a.log'
ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3
ORA-00312: online log 2 thread 1: '/oracle01/oradata/orcl/redo02.log'
ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3
SQL> alter database clear logfile group 2;
alter database clear logfile group 2 * ERROR at line 1:
ORA-01624: log 2 needed for crash recovery of instance orcl (thread 1) ORA-00312: online log 2 thread 1: '/oracle01/oradata/orcl/redo02.log' ORA-00312: online log 2 thread 1: '/oracle01/oradata/orcl/redo02a.log'
What steps must you take to resolve the error?
a: Issue the recover database redo logs command.
b: Issue the Startup Mount command to mount the database. c: Restore the last full database backup.
d: Perform a point-in-time recovery, applying all archived redo logs that are available.
e: Restore all archived redo logs generated during and after the last full database backup. f: Open the database using the alter database open resetlogs command.
g: Issue the alter database open command.

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

Answer: E

Explanation: If the online redo log is in ACTIVE or CURRENT status, you cannot issue CLEAR LOGFILE GROUP n command, it occurs ORA-01624 error.
The option (a) is invalid, there is NO such recover database redo log command, so that the answer must be (c, e, b, d, f).
It applies an incomplete recovery, then open database with RESETLOGS option.

NEW QUESTION 16
Which statement is true regarding virtual private catalogs?

• A. A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.
• B. The virtual private catalog owner cannot create and modify the stored scripts.
• C. The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
• D. To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.

Answer: D

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
What is the impact of the following backup if it exceeds the duration allowance? backup as compressed backupset duration 2:00 partial minimize load database ;

• A. The entire backup will fai
• B. It will not be usable for recovery.
• C. The entire backup will fail, but any datafile successfully backed up will be usable for recovery.
• D. If this backup fails, subsequent backups will prioritize datafiles not backed up.
• E. If this backup fails, an error will be raised and any other commands will not be executed.
• F. If this backup fails, no error will be raised and any other commands will be executed.

Answer: B

NEW QUESTION 19
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 20
Which statement about the enabling of table compression in Oracle Database 11g is true?

• A. Compression can be enabled at the table, tablespace, or partition level for direct loads only.
• B. Compression can be enabled only at the table level for both direct loads and conventional DML.
• C. Compression can be enabled at the table, tablespace, or partition level for conventional DML only.
• D. Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.

Answer: D