最新的Oracle 1Z0-045免費考試真題

問題1

You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?

A. DBMS_ALERT

B. DBMS_SERVER_ALERT

C. DBMS_SPACE_ADMIN

D. DBMS_SPACE

E. DBMS_MONITOR

F. DBMS_STATS

正確答案: B

問題2

What should you look at first to compute the number of undo blocks that are consumed and estimate the size of the undo tablespace needed to handle the workload on your system?

A. V$ROLLSTAT

B. V$TRANSACTION

C. DBA_UNDO_EXTENTS

D. DBA_ROLLBACK_SEGS

E. V$UNDOSTAT

正確答案: E

問題3

Identify four uses of the Oracle Scheduler. (Choose four.)

A. Enables you to periodically execute operating system script files located on the same server as the database.

B. Enables you to create a job that makes use of saved programs and schedules.

C. Enables you to execute jobs in a clustered environment.

D. Enables you to schedule job execution based on time.

E. Enables you to map a consumer group to an Oracle user.

F. Enables you to set idle time limits for a resource plan.

G. Enables you to assign priorities to the consumer groups.

正確答案: A,B,C,D

問題4

Online table redefinition includes which three features? (Choose three).

A. Storage parameters for the table can be modified.

B. The redefinition can be done across different schemas.

C. User-defined data types, BFILES or LONG columns are supported.

D. Tables without primary keys are supported.

E. Parallel support can be added or removed.

F. Organization can be changed from heap-organized to IOT structure, or vice versa.

正確答案: A,E,F

問題5

Examine the statement:
SQL> CREATE TABLESPACE user_data 2> EXTENT MANAGEMENT LOCAL 3> SEGMENT SPACE MANAGEMENT AUTO;
Which two assumptions must be true for this statement to execute successfully? (Choose two.)

A. Oracle Managed Files are used for this instance.

B. The database will manage the free space of segments in thetablespace using a bitmap.

C. The USER_DATAtablespace is managed using FET$/UET$ tables.

D. Space within segments in the USER_DATA tablespace is managed with freelists.

正確答案: A,B

問題6

View the Exhibit. You want to unload data from the ORDERS, ORDER_ITEMS, and PRODUCTS database tables to four OS flat files by using the External Table Population method. To achieve this objective, you execute the command shown on the Exhibit. After successful execution of the command, you find that only two files have been created and not four. Which option do you need to change to achieve your objective?

A. TYPE

B. DEFAULT DIRECTORY

C. PARALLEL

D. ORGANIZATION EXTERNAL

E. LOCATION

正確答案: C

問題7

Which process performs the rebalance data extent movements across ASM disk groups in ASM?

A. Checkpoint (CKPT)

B. ASM Rebalance Master (RBAL)

C. ASM Rebalance (ARBn)

D. System Monitor (SMON)

E. ASM Background (ASMB)

F. Process Monitor (PMON)

正確答案: C

問題8

Which task would you perform to convert little-endian CLOB data to the big endian format while transporting from a database created in an earlier version of Oracle to an Oracle 10g database?

A. No action is required because Oracle RDBMS implicitly does the conversion in Oracle 10g database while accessing the data.

B. Transport the data after changing the character set of the target database to bigendian.

C. Use the CHANGE command of the RMAN utility.

D. Use the CONVERT command of the RMAN utility.

E. Transport the data after changing the character set to be anendian-independent format in the target database.

正確答案: A

問題9

You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?

A. the CONVERT command of RMAN

B. Data Pump Export and Import

C. the BACKUP.. RESTORE.. command of RMAN

D. conventional export and import

E. the BACKUP AS COPY DATABASE .. command of RMAN

正確答案: E

問題10

Which three parameters are ignored when creating an automatic space management segment? (Choose three.)

A. PCTUSED

B. FREELISTS Change it to FREELIST

C. MAXTRANS

D. INITRANS

E. PCTFREE

F. FREELIST GROUPS

正確答案: A,B,F

問題11

What is true if you want to switch undo tablespaces from the current one, called UNDO1, to a new one called UNDO2?

A. It is NOT possible to switch unless no active transaction exists in UNDO1.

B. It is possible to switch to UNDO2; current active transactions will be automatically migrated to UNDO2.

C. It is possible to switch to UNDO2, but current active transactions will abort.

D. It is possible to switch to UNDO2; only current active transactions will continue to execute inside UNDO1.

正確答案: D

最新的Oracle database 10g:new features for Oracle8i ocps - 1Z0-045免費考試真題

聯系我們

站內鏈接

最新更新