Oracle database 10g:Administration I 認定 1Z0-042 試験問題:

1. You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task?

A) Give analysts DBA privilege, so that they can query DBA_EXTERNAL_TABLES.
B) Use an external table so you can have the metadata available in your database, but leave the data in the operating system files.
C) Upgrade the hardware/memory to accommodate the data.
D) Load the data into your database by using the PARALLEL clause.

2. The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct?

A) Undo data will be retained in the UNDO tablespace for 1,000 seconds, then it gets moved to the TEMPORARY tablespace to provide read consistency.
B) Undo data becomes obsolete after 1,000 seconds.
C) Committed undo data would be retained for 1,000 seconds if free undo space is available.
D) Undo data gets refreshed after every 1,000 seconds.
E) Undo data will be stored permanently after 1,000 seconds.

3. You want to protect your database from single point of failure by multiplexing the control file. Your database is started using SPFILE. You have to perform the following tasks:
1.Shut down the database instance.
2.Copy the control file to new location.
3.Configure the CONTROL_FILES parameter.
4.Restart the instance.
Select the correct order in which these tasks need to be performed.

A) 2,3,1,4
B) 1,2,3,4
C) 3,1,2,4
D) 3,2,1,4

4. Because of a power outage, instance failure has occurred. From what point in the redo log does recovery begin and where does it end?

A) beginning of redo log to end of redo log
B) current redo log and inactive redo log
C) all redo logs before the point of last commit
D) checkpoint position to end of redo log
E) beginning of redo log to checkpoint position

5. You are working on a database created with the Oracle Database 10g software in which the initialization parameter COMPATIBLE is set to 10.0.0. The hr_tbs tablespace in the database is created as follows:
CREATE TABLESPACE hr_tbs DATAFILE '/oracle/oradata/hr_tbs.dbf' SIZE 50M;
View the Exhibit to see the properties of the database.
Which statement is correct in this scenario?

A) hr_tbs is a dictionary-managed tablespace.
B) hr_tbs is a bigfile tablespace.
C) All the tablespaces in the database must be of the smallfile tablespace type.
D) All the tablespaces in the database will be locally managed by default.
E) The tablespace type bigfile or smallfile must be mentioned in the command.

質問と回答：