E. Schedule the database backup using Database Configuration Assistant(DBCA) while creating the database.
答案：E.
刚看到这个答案的时候，以为答案有问题。Google一下，真有。 我们注意看题目，在安装数据库的时候，确保数据库在没有干预的情况下规则的备份。 只有E中的DBCA工具合适了。 而且DBCA 还真有这个功能(玩了几年Oracle，都没有留意到，杯具中...)
7. The application development team has developed PL/SQL procedures and functions for different purposes and calls them as and when required. The loading of individual procedures or functions into memory degrades performance with every call. Also, it causes a security problem for individual subprograms and loss of program units when the whole system is transported into a new location. Which method would you recommend to the application developers to solve this problem
A. Avoiding the use of cursors in the subprograms.
B. Using anonymous（匿名） PL/SQL blocks instead of subprograms.
C. Referring to views instead of tables inside the subprograms.
D. creating PL/SQL packages to include interrelated(相关关联) subprograms.
答案：D.
8. View the Exhibit.
Your Oracle 10g database has 6 tablespaces in which:
-TEMP is the default temporary tablespace
- UNDOTBS1 is the default undo tablespace
- USERS is the default permanent tablespace
In this database, which three tablespaces can be made offline (Choose three.)
A) TEMP
B) PROD
C) USERS
D) SYSAUX
E) SYSTEM
F) UNDOTBS1
答案: BCD。
可以参考在线文档中 Overview of Tablespaces 小节的内容。
http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/physical.htm#CNCPT1089
9. The junior DBA in your organization has accidentally deleted the alert log file. What will you do to create new alert log file
A. Create the new text file as alert.log
B. You have to recover the alert log file from the valid backup.
C. Change the value for the BACKGROUND_DUMP_DEST parameter.
D. No action required. The file would be created automatically by the instance.
答案： D.
10. While planning to manage more than one database in your system,you perform the following activities:
（1） organize different categories of files into independent subdirectories.
（2） Use consistent naming convention for database files.
（3） Separate administrative information pertaining to each database.
Which option corresponds(一致) to the type of activities performed by you
A. Oracle Managed Files.
B. Oracle Grid Architecture.
C. Optimal Flexible architecture.
D. Oracle database architecture.
答案：C
Optimal Flexible Architecture
http://download.oracle.com/docs/cd/B28359_01/install.111/b32002/app_ofa.htm#i633068