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

Question 1

You want an ASM instance to manage the files of your production database. To achieve this objective, you specify the following parameters in the parameter file.
INSTANCE_TYPE = RDBMS LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA
Which parameter would be ignored while starting up the instance of the production database?

A. DB_CREATE_FILE_DEST

B. LARGE_POOL_SIZE

C. LOG_ARCHIVE_DEST

D. CONTROL_FILES

E. LOG_ARCHIVE_FORMAT

F. DB_BLOCK_SIZE

Correct Answer: E

Question 2

Examine the following parameter settings from an initialization (init.ora) file:
DB_CREATE_FILE_DEST = '/u01/oradata/' DB_CREATE_ONLINE_LOG_DEST_1 = '/u02/oradata/' DB_CREATE_ONLINE_LOG_DEST_2 = '/u03/oradata/' If you create an Oracle Managed Files (OMF) database using these settings, what is the result?

A. The data files, temp files, and control file will be on device /u01; one online redo log group will be on device /u02; another redo log group will be on device /u03.

B. The data files, temp files, online redo log files, and control file will be on device /u01; multiplexed copies of the archive log files will be created: one set on device /u02, and another set on device /u03.

C. The data files and temp files will be on device /u01; one copy of the control file and one online redo log group will be on device /u02; another copy of the control file and a second redo log group will be on device /u03.

D. The data files and temp files will be on device /u01; one copy of the control file and the first member in each online redo log group will be on device /u02; another copy of the control file and a second member of each redo log group will be on device /u03.

Correct Answer: D

Question 3

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

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

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

Correct Answer: A,D

Question 4

At 6:00 p.m. you noticed that the database performance was slow between 2:00 p.m. and 6:00
p.m.
due to a series of interrelated problems. You plan to use the Automatic Database Diagnostic Monitor (ADDM) findings for the time period 2:00 p.m. to 6:00 p.m. to resolve the performance issue. The Automatic Workload Repository (AWR) snapshots are made every 30 minutes. What would you do?

A. Modify the Automatic Workload Repository (AWR) snapshot retention period to four hours

B. Check the alert log to see if it contains ADDM advice

C. Look at the latest ADDM report

D. Check for the ADDM advice trace file in the BACKGROUND_DUMP_DEST directory

E. Create a custom ADDM task over the period defined by the snapshots taken at 2:00 p.m. and
6:00 p.m.

F. Modify the time interval by using the DBMS_JOB.INTERVAL procedure

Correct Answer: E

Question 5

Which three file types are managed by Data Pump jobs? (Choose three.)

A. SQL files

B. error files

C. alert files

D. out files

E. dump files

F. log files

Correct Answer: A,E,F

Question 6

The Oracle 10g LogMiner needs a data dictionary copy to display the object names. From which three locations can LogMiner retrieve the data dictionary information? (Choose three.)

A. separate supplemental log file

B. the current online data dictionary

C. a Data Dictionary copy stored in the redo log file

D. a Data Dictionary copy stored in an operating system flat file

E. information in the control file

F. redo information stored within the redo vectors of the DML operation

Correct Answer: B,C,D

Question 7

Which two initialization parameters would you set to enable Automatic Shared Memory Management? (Choose two.)

A. set SGA_TARGET to a non-zero value

B. set LOG_BUFFER to zero

C. set SHARED_POOL_SIZE to zero

D. set STATISTICS_LEVEL to TYPICAL or ALL

E. set STATISTICS_LEVEL to BASIC

F. set DB_CACHE_SIZE to a non-zero value

Correct Answer: A,D

Question 8

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_STATS

B. DBMS_ALERT

C. DBMS_SERVER_ALERT

D. DBMS_SPACE_ADMIN

E. DBMS_SPACE

F. DBMS_MONITOR

Correct Answer: C

Question 9

Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?

A. point-in-time recovery

B. execute the ROLLBACK command with transaction number

C. flashback the database to before the transaction was committed

D. manually enter the appropriate data again

E. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

Correct Answer: E

Question 10

You need to create a schedule that will run a job on the second Friday of each month. What should the repeat interval of the schedule be set to?

A. FREQ = MONTHLY; BYDAY = FRI2;

B. FREQ = MONTHLY; BYDAY = 2FRI;

C. FREQ = MONTHLY; BYDAY = FRI(2);

D. FREQ = MONTHLY; BYDAY = -2FRI;

Correct Answer: B

Question 11

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. ORGANIZATION EXTERNAL

B. PARALLEL

C. TYPE

D. DEFAULT DIRECTORY

E. LOCATION

Correct Answer: B

Question 12

You are working on a database that was created using Oracle Database 10g; the default tablespace type property was not changed. You execute the following statement to create a tablespace, mytbs:
CREATE TABLESPACE mytbs DATAFILE '/u1/data/mytbs.dbf' SIZE 100M;
Which two statements are correct regarding the mytbs tablespace? (Choose two.)

A. It is a dictionary-managedtablespace.

B. It is abigfile tablespace (BFT).

C. It is a defaultbigfile tablespace.

D. It is asmallfile tablespace.

E. It is a locally managedtablespace.

Correct Answer: D,E

Question 13

Which two statements regarding a SQL profile are true? (Choose two.)

A. It cannot be stored persistently in the data dictionary.

B. It is built by Automatic Tuning Optimizer.

C. It can be used by the query optimizer automatically.

D. It can be created manually by using the CREATE PROFILE command.

Correct Answer: B,C

Welcome to TestSimulate

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