oracle oca 试题.

www.supportcenter.cn

http://www.supportcenter.cn

共计：296道题

此题库整理了：

1Z0-042(1.14M).pdf

1Z0-042_by_Heyrae_2007-12-4.pdf

042(2008-04-24).doc，

备注：

有变哈，呵呵，168道题的那个（即是：1.14M），并且顺利通过

1. Which three pieces of information are considered while deciding the size of the undo tablespace in your

database? (Choose three.)

A) the size of an undo block

B) the size of the redo log files

C) undo blocks generated per second

D) the size of the database buffer cache

D) dropping a tablespace in your database

E) re-creating the control files, after you lost all the control files in your database

settings to optimize the database performance. Which method would you use to achieve this objective?

A) Use the CREATE DATABASE.. command to create the database with Oracle-managed files.

B) Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files.

B) Control files are read at the OPEN stage for the location of data files.

C) Control files are required to bring the database to the NOMOUNT stage.

www.supportcenter.cn

http://www.supportcenter.cn

5. A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE

B) It does not validate the existing data in the table.

A) run Segment Advisor

C) run the Automatic Workload Repository (AWR) report

Which statement regarding retention of undo data is correct?

B) Undo data gets refreshed after every 1,000 seconds.

C) Undo data will be stored permanently after 1,000 seconds.

www.supportcenter.cn

http://www.supportcenter.cn

A) When you delete a row from the emp table, you would receive a constraint violation error.

B) When you delete a row from the dept table, you would receive a constraint violation error.

E) When you delete a row from the dept table, automatically the corresponding rows are updated with null values in the

F) When you delete a row from the emp table, automatically the corresponding rows are updated with null values in the

dept table.

B) displays only the list of all basic parameters

D) displays only the list of all advanced parameters

E) displays the list of all the parameter files of a database

www.supportcenter.cn

http://www.supportcenter.cn

F) displays the current contents of the server parameter file

11. According to your backup strategy, you performed an incremental level 0 backup of your database. Which

B) The backup contains all used data blocks.

C) The backup contains only unused data blocks.

C) No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.

begin and where does it end?

B) checkpoint position to end of redo log

D) Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.

E) All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

the transaction. What are the two types of locks that this scenario would lead to? (Choose two.)

A) null lock on the row being updated

B) null lock on the table containing the row

C) ROW SHARE lock for the row being updated

What would you do to reclaim the used space in the Flash Recovery Area?

A) Back up the Flash Recovery Area.

www.supportcenter.cn

http://www.supportcenter.cn

D) Manually delete all the archived log files from the Flash Recovery Area by using operating system (OS) commands.

Which statement describes the conclusion?

C) The shared pool size should be increased to accommodate the SQL statements.

D) Preparing indexes on the tables used in the SQL statements would improve the library cache performance.

E) rolling forward during instance recovery

disk failure but the data files are not lost. You have the closed whole database backup available to you. Which

two statements are true in this scenario? (Choose two.)

A) The instance aborts.

B) The database cannot be recovered.

C) The database can be recovered by restoring the control files from the backup.

E) The database can be restored till the point of the last closed whole database backup.