Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: Oracle 1Z0-045
Title
: Oracle® Database 10g:New
Features for Oracle8i ocps
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
1. Consider this syntax:
MERGE INTO t1
USING t2 ON (join predicate)..
What does the MERGE syntax do?
A.It performs a merge join of the row from T2 only if it doesn't exist in the T1 table.
B.It creates a natural join of tables T1 and T2 for all columns that have the same name.
C.It creates a Cartesian product of table T1 and table T2 for all columns that have the same name.
D.For each row from T2, it updates the row if it exists within table T1, otherwise it inserts the row into T1.
Answer: D
2. You can use Oracle Flashback technology to look at past activity in your database.
What are two other characteristics of Oracle Flashback technology? (Choose two.)
A.Oracle Flashback technology uses undo information to construct consistent data.
B.You can use a PL/SQL cursor opened while using an Oracle Flashback image to perform DML once you
deactivate the Flashback option in your session.
C.You can only use an Oracle Flashback view of the data if the required records are still in the online redo
log files.
D.Oracle Flashback lists the DML that was executed during the period you identify when initiating your
session.
Answer: AB
3. Your Data Guard architecture consists of one primary database and one standby database, both located
on the same machine. What is the minimum that you need in order to use the command-line interface of the
Oracle 10g Data Guard Manager tool to monitor your Data Guard architecture?
A.only one Data Guard Monitor (DMON)
B.only the Oracle Management Server (OMS)
C.two Data Guard Monitors, one for each instance
D.one Data Guard Monitor and one Oracle Management Server
Answer: C
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
4. After changing the PCTFREE va