不確定 Fast2test 的 1Z0-055 題庫是否符合您的需求？我們提供 Oracle Database 11g: New Features for 9i OCPs 免費範例試題，先下載體驗 297 道練習題的編排方式與解析品質，滿意之後再決定購買。

Oracle 1Z0-055 考試概覽:

Oracle 1Z0-055 考試大綱主題:

Oracle Database 11g: New Features for 9i OCPs 考生常見問題解答

最新的 9i Internet Application Developer 1Z0-055 免費考試真題：

問題 #1

USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methods would you use to achieve this? (Choose all that apply.)

A. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted.
B. Use Data Pump to transfer the existing data to a new encrypted tablespace.
C. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace.
D. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace.
E. Use ALTER TABLE..MOVE to transfer the existing data to a new encrypted tablespace.

問題 #2

You are managing Oracle Database 11g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours:
ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H;
Which statement is true in this scenario?

A. It starts the ASM fast mirror resync.
B. All the disks in the dga disk group in failure group f2 would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
C. All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
D. It drops all disk paths from the dga disk group.

問題 #3

Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)

A. It does not allow you to change the moving window size.
B. Adaptive threshold functionalities use it by default to compute statistics.
C. It is created by default with the window size being equal to the AWR retention time.
D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).

問題 #4

Which two statements are true regarding Health Monitor checks in Oracle Database 11g? (Choose two.)

A. Health Monitor checks are always initiated manually when there is some critical error.
B. Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.
C. Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.
D. Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt, or inconsistent.

問題 #5

You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals:
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH','SALES',GRANULARITY=>'GLOBAL');
You need statistics to be collected more quickly. What can you do to achieve this?

A. Set the STATISTICS_LEVEL parameter to BASIC.
B. Increase the value of STALE_PERCENT for the partition table.
C. Set DYNAMIC_SAMPLING to level 4.
D. Set the INCREMENTAL value to TRUE for the partition table.

問題與答案：