1Z0-032
单选题Which statement correctly describes the function of Oracle9i Cache Fusion feature？（）A It provides each session with its own view of the database at a different point in the past. B It enables you to execute scalable applications on a clustered database
题目
It provides each session with its own view of the database at a different point in the past.
It enables you to execute scalable applications on a clustered database without having to partition the users or the database tables.
It lets you dynamically reassign memory in your database buffer cache to different block buffer sizes.
It allows you to add new sites to multimaster replication environment without quiescing the master definition site.
参考答案和解析
相似问题和答案
第1题：
A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.What should you do to accomplish this task?（）
A. Execute the query and view Active Session History (ASH) for information about the query.
B. Enable SQL trace for the query.
C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.
D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
第2题：
Which statement is true regarding RMAN components？（）
- A、Each target database requires its own recover catalog.
- B、RMAN scripts can be stored in the recovery catalog or the target control file.
- C、A channel is a stream of data to a device type and corresponds to one server session.
- D、The RMAN executable interprets sever session commands and establishes connections to the target database.
正确答案:C
第3题：
A. The cached result becomes invalid when any structural change is done to the EMPLOYEES table.
B. If the function execution results in an unhandled exception, the exception result is also stored in the cache.
C. Each time the function is invoked in a different session, the current result in the result cache gets overwritten.
D. If the function is invoked with a different parameter value, the existing result in the result cache gets overwritten by the latest value.
第4题：
Identify four uses of the Oracle Scheduler.（）
- A、 enables Oracle database to schedule which processes execute on which processors in a multiple CPU environment
- B、 enables Oracle database to do patches according to a DBA-defined schedule
- C、 enables you to schedule the execution of jobs based on time
- D、 enables you to execute jobs in a clustered environment
- E、 enables you to periodically execute operating systemscript files located on the same server as the database
- F、 enables you to create a job that makes use of saved programs and schedules
- G、 enables you to automate the management of the jobs that are created using the DBMS_JOB package
正确答案:C,D,E,F
第5题：
A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）
- A、Execute the query and view Active Session History (ASH) for information about the query.
- B、Enable SQL trace for the query.
- C、Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.
- D、Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
正确答案:C
第6题：
You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）
- A、 Open the database in read-only mode.
- B、 Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
- C、 Enable the block change tracking feature.
- D、 Execute the ALTER DATABASE FLASHBACK ON statement.
正确答案:A,C
第7题：
RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）
- A、’SQL ALTER DATABASE OPEN’；
- B、SQL ALTER DATABASE ’OPEN’；
- C、OPEN DATABASE；
- D、DATABASE OPEN
正确答案:C
第8题：
View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN> REPAIR FAILURE;Which statement describes the consequence of the command?（）
A. The command performs the recovery and closes the failures.
B. The command only displays the advice and the RMAN script required for repair.
C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.
D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).
第9题：
You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）
- A、Execute the ALTER DATABASE ARCHIVELOG statement
- B、Select ARCHIVELOG option in the database control and restart the database to apply the changes.
- C、Shut down and start the instance， and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.
- D、Shut down and start the instance， mount the database， then execute the ALTER DATABASE ARCHIVELOG statement.
正确答案:B,D
第10题：
Note the following points describing various utilities in Oracle Database 11g： 1：It enables the high-speed transfer of data from one database to another. 2：It provides a complete solution for the backup， restoration， and recovery needs of the entire database. 3：It enables the loading of data from an external file into an Oracle database. 4：It provides a tape backup management for the Oracle ecosystem. Which point describes Oracle Secure Backup（）
- A、1
- B、2
- C、3
- D、4
- E、1，2，and 4
- F、1，2，3，and 4
正确答案:D