1Z0-045 by Oracle Actual Free Exam Questions And Answers

Question 1

When WORKAREA_SIZE_POLICY is set to AUTO, the work areas are sized to accomplish which two goals? (Choose two).

A. To tune memory using the existing *_AREA_SIZE parameters.

B. To ensure that the overall size of the PGA will never exceed the value of PGA_AGGREGATE_TARGET.

C. To allocate memory to work areas in order to optimize throughput only.

D. To allocate memory to work areas in order to optimize both throughput and response time.

E. To allocate memory to work areas in order to optimize response time only.

Discussion 0

Correct Answer: B,D Vote an answer

Question 2

Users complain that SQL statements using a particular index fail. Using DBVERIFY, you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large.
What is the least disruptive recovery strategy available in Oracle 10g?

A. Rebuild the index using the online option.

B. Take the individual data file (not the wholetablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.

C. Take the individual data file offline (not the wholetablespace), restore and recover the data file from backup with RMAN, then set the data file online again.

D. Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks.

Discussion 0

Correct Answer: D Vote an answer

Question 3

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_SPACE

B. DBMS_MONITOR

C. DBMS_SPACE_ADMIN

D. DBMS_SERVER_ALERT

E. DBMS_STATS

F. DBMS_ALERT

Discussion 0

Correct Answer: D Vote an answer

Question 4

Which three statements regarding resumable statements are correct? (Choose three.)

A. Only the local instance is affected when changing theresumable timeout parameter in a distributed transaction.

B. RESUMABLE_TIMEOUT = 0 disablesresumable space allocation for all sessions.

C. Resumable statements can only be enabled at the system level.

D. Resumable statements can be enabled at the system level as well as the session level.

E. The ALTER SESSION ENABLE RESUMABLE command is obsolete in Oracle Database10g.

F. Resumable statements cannot contain a distributed transaction.

Discussion 0

Correct Answer: A,B,D Vote an answer

Question 5

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. Transport the data after changing the character set to be anendian-independent format in the target database.

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

C. Use the CONVERT command of the RMAN utility.

D. Use the CHANGE command of the RMAN utility.

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

Discussion 0

Correct Answer: B Vote an answer

Question 6

View the Exhibit and examine the recommendation graph provided for a test database by the Undo Advisor.
The graph recommends that the size of undo tablespace should be set to _____.

Discussion 0

Correct Answer: C Vote an answer

Question 7

You decide to activate the resumable space allocation feature for all your database users by enabling the feature in a logon trigger. This causes a statement that requires space beyond a user's quota _____.

A. to wait indefinitely for the quota to be increased, regardless of the timeout setting for other space allocation problems.

B. to invoke the default trigger that resets user quota, if there is free space in the relatedtablespace

C. to fail because quota limits do not activate theresumable space allocation feature

D. to wait in a suspended state until the quota is increased or until the timeout value is reached

Discussion 0

Correct Answer: D Vote an answer

Question 8

Which statements are true regarding the new Persistent Configuration feature in RMAN? (Choose two.)

A. It remembers the last backup command you used so that you can reschedule it easily.

B. It enables you to store your Channel attribute settings in the Recovery Catalog with each script.

C. It allows you to set the retention period of backups.

D. It enables you to store the settings for Channel attributes so that you do not have to specify them in each backup or restore command.

Discussion 0

Correct Answer: C,D Vote an answer

Question 9

When WORKAREA_SIZE_POLICY is set to AUTO, the work areas are sized to accomplish which two goals? (Choose two).

A. To tune memory using the existing *_AREA_SIZE parameters.

B. To ensure that the overall size of the PGA will never exceed the value of PGA_AGGREGATE_TARGET.

C. To allocate memory to work areas in order to optimize throughput only.

D. To allocate memory to work areas in order to optimize both throughput and response time.

E. To allocate memory to work areas in order to optimize response time only.

Discussion 0

Correct Answer: B,D Vote an answer

Question 10

An Oracle flashback view can be enabled________.

A. during execution of a transaction provided it involves only NOLOGGING operations

B. by any valid database user

C. at the system level

D. at the session level

Discussion 0

Correct Answer: D Vote an answer

Question 11

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. Space within segments in the USER_DATA tablespace is managed with freelists.

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. Oracle Managed Files are used for this instance.

Discussion 0

Correct Answer: B,D Vote an answer

Question 12

You enabled Flashback Database with the following command:
ALTER DATABASE FLASHBACK ON;
Which view would you query to determine whether the Flashback Database has been enabled?

A. V$INSTANCE

B. V$FLASHBACK_DATABASE_LOGFILE

C. V$SGA

D. V$FLASHBACK_DATABASE_STAT

E. V$FLASHBACK_DATABASE_LOG

F. V$DATABASE

Discussion 0

Correct Answer: F Vote an answer

Oracle database 10g:new features for Oracle8i ocps - 1Z0-045 Exam Practice Test

Contact Us

Useful Links

Latest Updated