分类：
2010-04-03 15:04:16
分享oracle考试的经验。
下面就来谈谈该考试的注意事项，首先考试费用是99美金，版本号是：V8.02.
以下是考试的部分题目：
1.Which three pieces of information are considered while deciding the size of the undotablespace in your database?(chose three.)
A.the size of an undo block
B.the size of redo log files
C.undo blocks generated per second
D.the size of the database buffer cache
E.the value of the UNDO_RETENTION parameter
Answer:ACE
2.You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?
A.renaming the control files
B.dropping a user in your database
C.enabling or disabling redo log archiving
D.dropping a tablespaces in your database
E.re-creating the control files, after you lost all the control files in your database
Answer:C
3.You want to create a new optimized database for your transactional production enviroment to be used by a financial application. While creating the database, you want the Oracle software to take care of all basic 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.
C.Use Enterprise Manager to create a new database with the Online Transaction Processing(OLTP)
option.
E.Use the CREATE DATABASE.. command to create the database with Automatic Storage
Management(ASM) file system.
Answer:D
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
Answer:ADE
5.A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the two effects of this command?(Choose two)
A.It fails if any existing row violates the constraint.
B.It does not validate the existing data in the table.
C.It enables the constraint to be enforced at the end of each transation.
D.It prevents insert,update,and delete operations on the table while the constraint is in the process of
being enabled.
Answer:AD
想要下载更多的资料，你可以到killtest题库网上看看去！
