oracle IZ0-042考试题库解析

写给自己学习用,也可以让有需要的朋友参考,陆续上传,欢迎大家留言交流,共同进步

4. Which three statements are true about the stages of database startup? (Choose three.)

A) Data files and redo log files can be renamed at the MOUNT stage.

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.

D) Data files and redo log files are made available to users at the OPEN stage.

E) Data files and online redo log files are checked for consistency while opening the database

数据库启动分为4个阶段shutdow,nomount,mount,startup. 控制文件的读取在mount阶段,数据文件的读取在startup阶段

 

9. Which three statements are correct about temporary tables? (Choose three.)

A) Indexes and views can be created on temporary tables.

B) Both the data and the structure of temporary tables can be exported.

C) Temporary tables are always created in a user's temporary tablespace.

D) The data inserted into a temporary table in a session is available to other sessions.

E) Data manipulation language (DML) locks are never acquired on the data of temporary tables.

为什么不选择B 答案可以在这里找到http://www.felipecruz.com/oracle-temporary-tables.php

 

16. You notice this warning in the alert log file:

ORA-19815: WARNING: db_recovery_file_dest_size of 3221225472 bytes is 100.00% used, and has 0

remaining bytes available. What would you do to reclaim the used space in the Flash Recovery Area?

A) Back up the Flash Recovery Area.

B) Increase the retention time for the files.

C) Decrease the retention time for the files.

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

选择A的原因可以在这里找到http://umardba.blogspot.com/2009/12/ora-19815-warning-dbrecoveryfiledestsiz.html

 http://hi.baidu.com/zzztou/blog/item/3bbfd5d1779b5b3e9a502771.html

 

 

25. A user complains that he gets the following error message repeatedly after executing some SQL

statements. The error message forces the user to log off from and log on to the database to continue his work.

ORA-02392: exceeded session limit on CPU usage, you are being logged off

Which action would you take to increase the session limit on CPU usage?

A) Modify the profile assigned to the user.

B) Modify the roles assigned to the users.

C) Modify the object privileges assigned to the user.

D) Modify the system privileges assigned to the users.

E) Modify the value for the RESOURCE_LIMIT parameter in the parameter file.

答案A ，原因如下：

ORA-02392:exceeded session limit on CPU usage, you are being logged offCause:An attempt was made to exceed the maximum CPU usage allowed by the CPU_PER_SESSION clause of the user profile.Action:If this happens often, ask the database administrator to increase the CPU_PER_SESSION limit of the user profile.

 

 

52. A user receives the following error while executing a query:

ORA-01555: snapshot too old

Which two options can be the solutions to avoid such errors in future? (Choose two.)

A) increase the size of redo log files

B) increase the size of the undo tablespace

C) increase the size of the Database Buffer Cache

D) increase the size of the default temporary tablespace

E) enable the retention guarantee for the undo tablespace

 

ORA-01555:

snapshot too old: rollback segment number string with name "string" too smallCause:rollback records needed by a reader for consistent read are overwritten by other writersAction:If in Automatic Undo Management mode, increase undo_retention setting. Otherwise, use larger rollback segments