1z0-042
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
E:the value of the UNDO_RETENTION parameter
Correct Answers: A, C, E
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 tablespace in your database
E: re-creating the control files, after you lost all the control files in your database
Correct Answers: C
3.You want to create a new optimized database for your transactional production
environment 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.
D: Use Database Configuration Assistant (DBCA) to create the database with Transaction
Processing template.
E: Use the CREATE DATABASE .. command to create the database with Automatic Storage
Management (ASM) file system.
Correct Answers: 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.
1
评论0