1z0-045 Exam

Quality and Value for the 1z0-045 Exam

Test4pass Practice Exams for Oracle 1z0-045 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

100% Guarantee to Pass Your 1z0-045 Exam

If you prepare for the exam using our Test4pass testing engine, we guarantee your success in the first attempt. If you do not pass the OCP 8i to 10g DBA Upgrade 1z0-045 exam (ProCurve Secure WAN) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.

Oracle 1z0-045 Downloadable, Printable Exams (in PDF format)

Our Exam 1z0-045 Preparation Material provides you everything you will need to take your 1z0-045 Exam. The 1z0-045 Exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first try, but also save your valuable time.

1z0-045 Downloadable, Interactive Testing engines

We are all well aware that a major problem in the IT industry is that there is a lack of quality study materials. Our Exam Preparation Material provides you everything you will need to take a certification examination. Like actual certification exams, our Practice Tests are in multiple-choice (MCQs) Our Oracle 1z0-045 Exam will provide you with free 1z0-045 dumps questions with verified answers that reflect the actual exam. These questions and answers provide you with the experience of taking the actual test. High quality and Value for the 1z0-045 Exam:100% Guarantee to Pass Your OCP 8i to 10g DBA Upgrade exam and get your OCP 8i to 10g DBA Upgrade Certification.

Hot KeyWords On 1z0-045 test

We collect some hot keywords about this exam:
Test4pass , Pass 4 Sure , Test in Side ,Pass Guide ,Test King 1z0-045 exam | 1z0-045 pdf exam | 1z0-045 braindumps | 1z0-045 study guides | 1z0-045 trainning materials | 1z0-045 simulations | 1z0-045 testing engine | 1z0-045 vce | 1z0-045 torrent | 1z0-045 dumps | free download 1z0-045 | 1z0-045 practice exam | 1z0-045 preparation files | 1z0-045 questions | 1z0-045 answers.

How to pass your 1z0-045 exam

You can search on Search Engine and Find Best IT Certification site: Test4pass.com - Find the Method to succeed 1z0-045 test,The safer.easier way to get OCP 8i to 10g DBA Upgrade Certification .

��
��
Exam : Oracle 1Z0-045
Title : Oracle(r) Database 10g:New Features for Oracle8i ocps


1. ou want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 a.m.
Which command terminates with an error if the backup is not complete at the end of the specified duration?
A.RMAN> BACKUP DURATION 2:00 MINIMIZE LOAD DATABASE;
B.RMAN> BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASE;
C.RMAN> BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE;
D.RMAN> BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE;
Answer: A

2. Examine this startup script called startmydb.sql:
CONNECT myid/mypwd AS SYSDBA STARTUP
EXIT
In Oracle 8 i, you could have executed this script by invoking Server Manager with the command:
svrmgrl @startmydb.sql
Which alternative command could you use to run the startmydb.sql script with SQL*Plus to start your Oracle 10g database?
A.sqlplus @startmydb.sql
B.sqlplus -Sstartmydb.sql
C.sqlplus -S @startmydb.sql
D.sqlplus /NOLOG @startmydb.sql
Answer: D

3. You plan to create an external table from the EMPLOYEES, DEPARTMENTS, and LOCATIONS database tables. Which method or command should you use to create and populate the external table?
A. the expdp and impdp commands
B.conventional export and import
C.CREATE TABLE.. and SQL*Loader
D.CREATE TABLE.. and INSERT INTO.. SELECT.. FROM..
E.CREATE TABLE.. ORGANIZATION EXTERNAL ..AS SELECT.. FROM..
Answer: E

4. Which two statements regarding the FLASHBACK_TRANSACTION_QUERY view are correct? (Choose two.)
A. You can find information about only active transactions from the view.
B.You can find information about read only transactions from the view.
C.You require the SELECT ANY TRANSACTION system privilege to access the view.
D.You can find information about both active and committed transactions from the view.
E.You require the SELECT ON FLASHBACK_TRANSACTION_QUERY object privilege to access the view.
Answer: CD

5. Which three statements are true about the privileged connection options available in Oracle 10g? (Choose three.)
A. The CONNECT INTERNAL is disallowed.
B.The Server Manager tool is no longer supplied.
C.The listener must be running to make a connection.
D.The use of a remote password login file (orapwd) is unchanged.
Answer: ABD

6. 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

7. You have three temporary tablespace groups named G1, G2, and G3 in your database.
You are creating a new temporary tablespace as follows:
CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP '';
Which statement regarding the above command is correct?
A.It will create the tablespace TEMP1 in group G1.
B.It will create the tablespace TEMP1 in group G3.
C.It will not add the tablespace TEMP1 to any group.
D.It will create the tablespace TEMP1 in the default group.
E.It will throw an error with message 'specified group is not available'.
F.It will create a new group with a system-generated name and add the tablespace TEMP1 to it.
Answer: C

8. After changing the PCTFREE value of the automatic space management table EMPLOYEES, which task can you perform in order for your change to take effect immediately?
B.Execute the command ANALYZE TABLE employees COMPUTE STATISTICS.
C.Execute the command DBMS_STATS.GATHER_TABLE_STATISTICS on the EMPLOYEES table.
D.Execute the DBMS_REPAIR.SEGMENT_FIX_STATUS procedure on the EMPLOYEES table.
Answer: D

9. 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

10. 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

11. Which two statements regarding the Policy Framework in Enterprise Manager (EM) are correct? (Choose two.)
A. Policy violations are prioritized as High, Medium, or Informational by category.
B.Policies can be disabled completely, or flagged as ignored, for the specified target.
C.Policies can be flagged as ignored, but never completely disabled, for the specified target.
D.Policy violations must be corrected, otherwise the database will shut down until corrective action occurs.
Answer: AB

12. You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this? (Choose two.)
A. set SQL_TRACE=True
B.set UNDO_RETENTION=14400
C.set FAST_START_MTTR_TARGET=240
D.set LOG_CHECKPOINT_INTERVAL=240
E.set DB_FLASHBACK_RETENTION_TARGET=14400
F.issue ALTER DATABASE FLASHBACK ON; command
G.set the RETENTION GUARANTEE clause for the undo tablespace
Answer: BG

13. With CURSOR_SHARING = SIMILAR, cursors are shared for safe literals only. What is meant by 'safe literals only'?
A.No literal value is substituted for a shared cursor.
B.Different execution plans are generated for substituted literal values.
C.The optimizer ignores all indexes and statistics to establish the appropriate execution path.
D.The substitution of any literal value will produce exactly the same execution plan.
Answer: D

14. 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