1z0-045 OCP 8i to 10g DBA Upgrade Braindump
ExamSoon 1z0-045 Exams
Oracle oracle database 10g:new features for oracle8i ocps
O rder : 1z0-045 Exam
Practice Exam: 1z0-045
Exam Number/Code: 1z0-045
Exam Name: oracle database 10g:new features for oracle8i ocps
Questions and Answers: 211 Q&As
Free 1z0-045 Braindumps
Exam : Oracle 1Z0-045
Title : Oracle(r) Database 10g:New Features for Oracle8i ocps
1. To re-create your control file as an Oracle Managed File, you use the CREATE CONTROLFILE command.
There is no SPFILE, and you are using the initDB1.ora initialization parameter file to start up your instance.
After executing the CREATE CONTROLFILE command, what should you do to start up your instance the next time?
A.Ensure that all data files are also Oracle Managed Files.
B.Ensure that all redo log files are also Oracle Managed Files.
C.Ensure that the correct value for the CONTROL_FILES initialization parameter is specified inside initDB1.ora.
D.Ensure that there is NO entry specified for the CONTROL_FILES initialization parameter inside initDB1.ora.
Answer: C
2. You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of
the day, you execute the following command on the ASM instance to shut down:
SQL> shutdown immediate;
What is the result of executing this command?
A.All the instances, including the ASM instance, are shut down in the ABORT mode.
B.The ASM instance is shut down, but the other instances are still running.
C.The ASM instance is still functional, but the other instances are shut down.
D.All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
E.HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in
the IMMEDIATE mode.
F.HRDB, FINDB, and ORGDB instances are shut down in the NORMAL mode and the ASM instance is shut down in
the IMMEDIATE mode.
Answer: D
3. You can use Oracle Flashback technology to look at past activity in your database.
What are two other characteristics