Question 1.
Following an upgrade from Oracle8, release 8.0, to Oracle8i, release 1 or 2, you should run the script utlrp.sql to accomplish which goal?

A. Create a set of compatible data dictionary tables.
B. Recompile any PL/SQL modules made invalid by the upgrade.
C. To remove the release upgrade program modules from the SYSTEM tablespace.
D. Replace statistics tables created with the DBMS_STATS with current versions.

Answer:   B

Question 2.
Which command will open a standby database in read-only mode?

A. ALTER DATABASE OPEN READ ONLY;
B. STARTUP READ ONLY;
C. ALTER DA MOUNT READ ONLY;
D. ALTER DATABASE READ ONLY;

Answer:   A

Question 3.
Which two statements are true? (Choose two)

A. Composite partitioning enables you to prevent partition elimination.
B. Composite partitioning supports hash—partitioned global indexes.
C. Composite partitioning is ideal for both historical data and data placement.
D. Composite partitioning providing high availability, like range partitioning.

Answer:   C & D

Question 4.
Which command will no longer be supported after Oracle 8.1?

A. CONNECT INTERNAL
B. CONNECT/ AS SYSDBA
C. CONNECT/ AS SYSTEM
D. CONNECT/ AS SYSOPER

Answer:   A

Question 5.
Examine this statement:

SELECT *
FROM (SELECT class_id,crs_id
FROM classes
ORDER BY start_date DESC)
WHERE ROWNUM <11;

What will happen when this executes?

A. The ten rows with the latest start date will be returned.
B. The ten rows with the earliest start date will be returned.
C. An error is returned citing an ORDER BY embedded within a subquery.
D. An error is returned citing an ORDER BY clause reference to a column that is not selected.

Answer:   A

Question 6.
What is the maximum number of parallel recovery servers when the FAST_START_PARALLEL_ROLLBACK parameter is set to HIGH?

A. 2* CPU_COUNT
B. 4* CPU_COUNT
C. 6* CPU_COUNT
D. 2* number of rollback transactions
E. 4* number of rollback transactions

Answer:   B

Question 7.
Your standby database has been in read-only mode for the past five hours. During this time ten log switches have taken place on the production database. The DBA now wants to put the database into a sustained recovery mode. What happens to the archive logs?

A.	They are applied to the standby database while in read-only mode.
B.	They are applied to the standby database automatically when the DBA issues the ALTER DATABASE RECOVER MANAGED DATABASE command.
C.	They are applied to the standby database automatically when the DBA issues the ALTER DATABASE RECOVER DATABASE command.
D.	The DBA must manually apply the archived logs to the database, before putting the database into standby mode. 
E.	The archive logs are stored on the production server, and are transferred across when the standby database returns to managed recovery.

Answer:   B

Question 8.
To enable a database to have more than one service associated with it, the connect descriptor SID parameter in the tnsnames.ora file has been replaced by which two parameters?(Choose two)

A.	SERVICE _NAME.
B.	LISTENER_NAME.
C.	INSTANCE_NAME.
D.	DISPATCHERS.

Answer: A & C

Question 9.
In the DBA_TRIGGER data dictionary view, the value in the TABLE_NAME column will be NULL in which two situations? (Choose two)

A. The trigger is a schema trigger.
B. The trigger is a database trigger.
C. The trigger was created by the DBA for another user.
D. The trigger is created with the CREATE ANY TRIGGER privilege.
E. The trigger was created by a user who connected with the CONNECT INTERNAL command.

Answer:   A & B

Question 10.
Which three statements about transportable tablespaces are true? (Choose Three)

A.	A transportable tablespace must not contain BLOBs.
B.	The source and target databases must have the same block size.
C.	The source and target databases must have the same character set.
D.	The data file names must be the same for the source and target databases.
E.	The operating systems must be the same for the source and target databases.

Answer:   B, C, E

	Web www.certsbraindumps.com