checklist? (Choose two.)
A. failures because a data file is renamed by error B. failures when no standby database is configured
C. failures that require no archive logs to be applied for recovery
D. failures due to loss of connectivity-for example, an unplugged disk cable
Answer: AD Section: (none)
QUESTION 244
Which two statements are true regarding the starting of the database instance using the following command? (Choose two.) SQL>STARTUP UPGRADE
A. It enables all system triggers. B. It allows only SYSDBA connections.
C. It ensures that all job queues remain active during the upgrade process.
D. It sets system initialization parameters to specific values that are required to enable database
upgrade scripts to be run.
Answer: BD Section: (none)
Explanation/Reference:
QUESTION 245
Which statements are true regarding system-partitioned tables? (Choose all that apply.)
A. Only a single partitioning key column can be specified. B. All DML statements must use partition-extended syntax.
C. The same physical attributes must be specified for each partition. D. Unique local indexes cannot be created on a system-partitioned table.
E. Traditional partition pruning and partitionwise joins are not supported on these tables.
Answer: DE Section: (none)
QUESTION 246
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.
Answer: AE Section: (none)
QUESTION 247
Which two statements about Oracle Direct Network File System (NFS) are true? (Choose two.)
A. It bypasses the OS file system cache.
B. A separate NFS interface is required for use across Linux, UNIX, and Windows platforms.
C. It uses the operating system kernel NFS layer for user tasks and network communication modules. D. File systems need not be mounted by the kernel NFS system when being served through Direct NFS. E. Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver.
Answer: AE Section: (none)
QUESTION 248
You want the ability to recovery any time within the last seven days and therefore you configured the recovery window retention policy using the command:
RMAN> CONFIGURE RETENTIOH POLICY TO RKCOVFRY WINDOW OF 7 DAYS;
After configuring the recovery window, you performed the database backup as follows:
A. Backup RB1 at log sequence number 12871 on 5th Jan B. Backup RB2 at log sequence number 15622 on 12th Jan C. Backup RB3 at log sequence 16721 on 15th Jan
D. On 20th Jan when the log sequence number was 18112 you realize that there Is a need to a
E. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cos
point in time at the beginning of the recovery window. You have all an hived redo log files to date.
Answer: D Section: (none)
Explanation/Reference:
QUESTION 249
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 Section: (none)
QUESTION 250
You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation.
The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system. How would you create these jobs?
A. Create both jobs by using events raised by the scheduler B. Create both jobs by using events raised by the application
C. Create a job to rebuild indexes by using events arised by the application and then create another
job to perform bulk load by using events raised by the scheduler
D. Create a job to rebuild indexes by using events arised by the Scheduller and then create another
job to perform bulk load by using events raised by the application
Answer: D Section: (none)
QUESTION 251
You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version
10.1 catalog schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You executed the following RMAN commands:
RMAN> CONNECT CATALOG rco11/password@catdb RMAN> IMPORT CATALOG rcat10/oracle@inst1;
What happens when you execute the above commands? (Choose all that apply.)
A. They deregister all databases registered in the RCAT10 catalog.
B. They import metadata for all registered databases in the RCAT10 database. C. They register all the RCAT10-catalog registered databases in the RCO11 catalog.
D. They overwrite all stored scripts in the RCO11 catalog with the same name as that in the RCAT10 catalog.
Answer: ABC Section: (none)
Explanation/Reference:
QUESTION 252
Which three are the valid statements in relation to SQL plan baselines? (Choose three.)
A. The plans can be manually loaded to the SQL plan baseline. B. The plans in the SQL plan baseline are verified and accepted plans.
C. The plans generated for every SQL statement are stored in the SQL plan baseline by default. D. The plan baselines are stored temporarily in the memory as long as the database instance is running. E. For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.
Answer: ABE
Section: (none)
QUESTION 253
You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?
A. The tuned plan is not added to the SQL plan baseline.
B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan. C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan. D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.
Answer: C Section: (none)
QUESTION 254
Which three statements correctly describe the features of the I/O calibration process? (Choose three.)
A. Only one I/O calibration process can run at a time.
B. It automates the resource allocation for the Automated Maintenance Tasks. C. It improves the performance of the performance-critical sessions while running.
D. It can be used to estimate the maximum number of I/Os and maximum latency time for the system. E. The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE.
Answer: ADE Section: (none)
Explanation/Reference:
QUESTION 255
Which two statements about the SQL Management Base (SMB) are true? (Choose two.)
A. It contains only SQL profiles generated by SQL Tuning Advisor. B. It stores plans generated by the optimizer using a stored outline. C. It is part of the data dictionary and stored in the SYSAUX tablespace.