NEW QUESTION 1

Which three statements are true regarding the functioning of the Autotask Background Process (ABP)? (Choose three.)

• A. It creates jobs without considering the priorities associated with them.
• B. It translates tasks into jobs for execution by the scheduler.
• C. It determines the list of jobs that must be created for each maintenance window.
• D. It is spawned by the MMON background process at the start of the maintenance window.
• E. It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.

Answer: BCD

Explanation:
AutoTask Overview
Oracle 11g added a new component to the Oracle automated task infrastructure, that began in Oracle 10g, called AutoTask. AutoTask provides a central component that is responsible for management of scheduled maintenance tasks.
AutoTask Architecture
AutoTask builds on much of the existing architecture of Oracle 10g. The AutoTask architecture consists of the following components:
AutoTask Background Process (ABP) - APB is spawned by MMON and is responsible for managing the AutoTask features. It coordinates the AutoTask clients and the scheduler. It also maintains AutoTask related history that can be seen in the DBA_AUTOTASK_TASK view.
AutoTask Clients - Automated maintenance tasks that are scheduled by AutoTask. Oracle 11g includes clients for statistics gathering, the Segment Advisor, and the Automatic SQL Tuning Advisor.
The AutoTask Maintenance Windows - Individual maintenance windows exist for different days of the week.
These windows can be modified as required.
Resource Manager - A resource plan is enabled that is designed to limit the amount of resources that the AutoTask tasks can consume. This resource plan can be modified as required.
OEM - You can manage the start time and duration of the various AutoTask maintenance windows and add or remove maintenance tasks with OEM. You can also use OEM to enable or disable maintenance tasks.
The Scheduler - AutoTask operations rely heavily on the Scheduler. The AutoTask architecture uses scheduler windows and the scheduler infrastructure to execute AutoTask tasks.

NEW QUESTION 2

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 3

Which three statements are true about persistent configuration? (Choose three.)

• A. A user cannot set privileges on the persistent lightweight jobs
• B. Persistent lightweight jobs generate a large amount of metadata
• C. It is possible to create fully self-contained persistent lightweight jobs
• D. The use of a template is mandatory to create persistent lightweight jobs
• E. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time

Answer: ADE

NEW QUESTION 4

Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?

• A. a cumulative level 1 backup
• B. a differential level 1 backup
• C. a full backup
• D. a whole backup

Answer: A

NEW QUESTION 5

If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode, what will be the result when you issue the command alter database archivelog?

• A. The alter database archivelog command will fail.
• B. The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG mode.
• C. The alter database archivelog command will succeed.
• D. The alter database archivelog command will ask if you want to make the database consistent first.
• E. There is no alter database archivelog comman
• F. The correct command is alter database alterlogging.

Answer: A

Explanation:
Before you change database to archivelog mode, you need to have a clean database shutdown.

NEW QUESTION 6

What is an obsolete backup set?

• A. A backup set that is missing one or more backup set pieces
• B. A backup that has exceeded the retention criteria and is no longer needed
• C. A backup set that does not include archived redo logs
• D. A backup set that can not be recovered due to corruption
• E. A backup set superceded by a datafile copy

Answer: B

NEW QUESTION 7

The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application.
Which of these are good starting points to use when configuring the maximum values for SGA and PGA, based on the amount of memory available on the system?

• A. 20% SGA, 80% PGA
• B. 25% SGA, 75% PGA
• C. 50% SGA, 50% PGA
• D. 75% SGA, 25% PGA
• E. 80% SGA, 20% PGA

Answer: E

NEW QUESTION 8

Choose the correct order to package and upload data for an incident to Oracle Support.

• A. Schedule, create new package, view manifest, view contents
• B. Create new package, view manifest, view contents, schedule
• C. Schedule, create new package, view contents, view manifest
• D. Create new package, view contents, view manifest, schedule
• E. None of the above.

Answer: D

Explanation:

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

NEW QUESTION 9

You want to disable resumable space allocation for all sessions. Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable space allocation for all sessions?

• A. 10
• B. 100
• C. NULL

Answer: A

NEW QUESTION 10

Which RMAN backup command is used to create the block-change tracking file?

• A. alter database create block change tracking file
• B. alter database enable block change file
• C. alter database enable block change tracking using file '/ora01/opt/block_change_tracking.fil'
• D. alter system enable block change tracking using file '/ora01/opt/block_ change_tracking.fil'
• E. alter system block change tracking on

Answer: C

NEW QUESTION 11

Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database?

• A. Yes, if the database is in ARCHIVELOG mode.
• B. Yes, if the database is in NOARCHIVELOG mode.
• C. No, the backup is not usable in any way.
• D. Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE.

Answer: C

NEW QUESTION 12

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 13

Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter?

• A. Automatic PGA Memory Management
• B. Automatic SGA Memory Management
• C. Automatic Shared Memory Management
• D. Automatic Memory Management
• E. Manual SGA Memory Management
• F. None of the above

Answer: D

NEW QUESTION 14

To clean up old records that are in a Flashback Data Archive and are past the retention period, what must the DBA do?

• A. TRUNCATE the archive table.
• B. DROP the Flashback Data Archive.
• C. Nothing; expired rows are automatically removed.
• D. Nothing; expired rows are moved to an archive table.
• E. Delete entries from the archive where the metadata date retained is greater than the retention period.

Answer: C

NEW QUESTION 15

As the DBA, you run the following query on your ASM instance. What is the implication of the results of the query? (Choose two.)
SQL> select group_number, name, state from v$ASM_DISKGROUP; GROUP_NUMBER NAME STATE
============ ======= ========== 0 DGROUP1 DISMOUNTED
2 DGROUP2 MOUNTED
3 DGROUP3 MOUNTED

• A. The DGROUP1 disk group was unmounted by another DBA.
• B. A datafile has been lost, causing the ASM disk group DGROUP1 to go into the DISMOUNTED state
• C. One of the redundant disks (DGROUP1) has been lost in a disk group.
• D. This query has no meaning in an ASM instance.
• E. A disk associated with a disk group was discovered after the ASM instance initially opened.

Answer: AE

NEW QUESTION 16

You are performing incomplete recovery using RMAN. You execute the following RUN block:
RUN
{
SET UNTIL SCN 1107600; RESTORE DATABASE; RECOVER DATABASE;
}
Which statement is true about the result?

• A. RMAN restores all datafiles from the most recent backup available since the failure and applies the redo logs necessary to recover the database to SCN 1107600
• B. RMAN restores all datafiles needed to restore the database through SCN 1107599 and applies the redo logs necessary to recover the database through SCN 1107599.
• C. RMAN restores all datafiles and control files from the most recent backup
• D. The RUN block fails because you did not specify an UNTIL clause in your RECOVER DATABASE command

Answer: B

NEW QUESTION 17

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 18

Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g? (Choose all that apply.)

• A. Generate reports on data failure such as data file failures.
• B. You can track the Service Request (SR) and implement repairs.
• C. You can package and upload diagnostic data to Oracle Support.
• D. You can manually run health checks to gather diagnostic data for a problem.

Answer: BCD

NEW QUESTION 19

You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups.
Identify two prerequisites to perform the backups. (Choose two.)

• A. The database must be opened in restricted mode.
• B. The database must be configured to run in ARCHIVELOG mode.
• C. The tablespaces are required to be in backup mode before taking the backup.
• D. The tablespaces are required to be in read-only mode before taking the backup

Answer: BC

NEW QUESTION 20

Which is the correct command to back up the database, back up the archived redo logs, and then remove the backed-up archived redo logs?

• A. backup database
• B. backup database and archivelogs
• C. backup database plus archivelogs
• D. backup database plus archivelog delete input
• E. backup database and archivelog delete input

Answer: D

NEW QUESTION 21

Your archive-log destination directory runs out of space. What is the impact of this on the database?

• A. Non
• B. The database will switch over to the stand-by archive-log destination directory.
• C. A warning message will be written to the alert log of the database, but no adverse impacts to the database will be experienced.
• D. The database will shut down, and will not restart until you correct the out-of-space situation.
• E. The database will continue to try to write to the archive-log destination directory for one hou
• F. After one hour, the database will shut down normally.
• G. Once Oracle has cycled through all online redo logs, it will stop processing any DML or DDL until the out-ofspace condition is corrected.

Answer: E

NEW QUESTION 22

Which package provides API's for the SQL Tuning Advisor?

• A. DBMS_MONITOR
• B. DBMS_STATS
• C. DBMS_SQLTUNE
• D. DBMS_ADVISOR

Answer: C

Explanation:
View the Exhibit 1.
In the CUSTOMERS_OBE table, when the value of CUST_STATE_PROVINCE is "CA", the value of COUNTRY_ID is "US."
View the Exhibit exhibit2 to examine the commands and query plans. The optimizer can sense 8 rows instead of 29 rows, which is the actual number of rows in the table.
What can you do to make the optimizer detect the actual selectivity? desc-customers_obe (exhibit):

C:\Users\albo\Desktop\1-1.jpg
sql-select-customers_obe (exhibit):

C:\Users\albo\Desktop\1-1.jpg
A. Change the STALE_PERCENT value for the CUSTOMERS_OBE table.
B. Set the STATISTICS_LEVEL parameter to TYPICAL.
C. Create extended statistics for the CUST_STATE_PROVINCE and CUSTOMERS_OBE columns.
D. Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE. Answer: C
Real example refer to here. Determining Single Column Statistics
A good example of correlated or related columns are the country_id and cust_state_province columns in the CUSTOMERS_OBE table. When the value of cust_state_province is 'CA' , the value of country_id is 'US'. There is a skew in the data in these two columns, which means the majority of rows in the table have the values 'CA' and 'US'. Both the relationship between the columns and the skew in the data make it difficult for the optimizer to calculate the selectivity or cardinality of these columns correctly when they are used together in a query. Extended statistics should help in this situation.

NEW QUESTION 23

Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablspace. A user issues a query on the ORDERS table and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file '/u01/app/oracle/oradata/TEST/temp01.tmp' ORA-27037: unable to obtain file status
What would be the most efficient way to rectify this error? ##

• A. Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.
• B. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
• C. Allow the database to continue running, drop the temp01.tmp temporary file, and then re-create it with new tempfiles.
• D. Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then bring the temporary tablespace online.

Answer: A

NEW QUESTION 24

You installed Oracle Database 11g at fresh. Which statements are true regarding the default audit settings in this database? (Choose all that apply.)

• A. The audit trail is stored in an operating system file.
• B. Auditing is disabled for all privileges.
• C. The audit trail is stored in the database.
• D. Auditing is enabled for all privileges.
• E. Auditing is enabled for certain privileges related to database security.

Answer: CE

NEW QUESTION 25
......