Free Oracle 1Z0-035 Exam Dumps Questions & Answers

In which tablespace are temporary LOBs stored?

• A.  in the user's default tablespace
• B.  any tablespace depending on the temporary LOBs' definition
• C.  in the user's temporary tablespace
• D.  in the SYSTEM tablespace

Which three features are provided by Recovery Manager and NOT provided by user-managed backup and recovery? (Choose three.)

• A.  online backups
• B.  partial database backups
• C.  incremental block-level backup
• D.  skipping unused blocks
• E.  detection of corrupted blocks during backup

Your present networking environment is set up to run TCP/IP. In addition, you have hundreds of concurrent users accessing a single server. Which Oracle networking solution can you use to manage this environment using the multiplexing technique?

• A.  Connection Manager
• B.  Advanced Networking Option
• C.  Net8
• D.  Oracle Names
• E.  Security Server
• F.  Open Gateway

What can you see when querying V$LOGMNR_CONTENTS?

• A.  only the redo generated by the current schema
• B.  the SQL statement run, and the relevant undo SQL statement
• C.  the old image and the new image of the row that was modified
• D.  the SQL statement run, and the old image
• E.  the SQL statement run, and the new image

What are three advantages of using Oracle Advanced Queuing? (Choose three.)

• A.  allows you to use RAW or user-defined data types for messages
• B.  allows you to put time constraints on messages so that they will be removed from the queue after a specified time
• C.  allows you to prioritize or order messages
• D.  allows you to use a REPLY queue to receive answers to your messages
• E.  allows you to use VARCHAR2, DATE, NUMBER and CHAR data type messages