Free Oracle 1z1-070 Exam Dumps Questions & Answers

Which three statements are true regarding the configuration of Auto Service Request (ASR) on an X5 Database Machine?

• A.  ASR Manager may be installed on any type of server running Oracle Solaris.
• B.  Oracle Solaris must be used on the server where ASR Manager is installed.
• C.  Oracle Linux must be used on the server where ASR Manager is installed.
• D.  ASR Manager must be installed on one of the database servers.
• E.  HTTPS connectivity must be enabled from the ASR Manager host to the Internet.
• F.  ASR Manager may be installed on any type of server running Oracle Linux.
• G.  SMTP must be enabled on at least one database server.

Identify the four software components that run only on an Exadata Database Machine Database Server.

• A.  ASM instance
• B.  DISKMON
• C.  Automatic Diagnostic Repository Command Interpreter (ADRCI)
• D.  Oracle Enterprise Manager Agent (OMA)
• E.  CELLCLI
• F.  Cell Serve (CELLSRV)
• G.  DSKM

An important application has been migrated to a database on an X5 Database Machine.
You are examining high-load SQL statements from this application, in an attempt to determine which ones will benefit from the Exadata Smart Scan capability.
Which three access paths always generate "cell single block physical read" or "cell multiblock physical read" requests?

• A.  Index unique scan access by primary key to heap organized tables executed serially
• B.  Index fast full scans executed in parallel
• C.  Full table scans on index organized tables executed in parallel
• D.  Full table scans on heap organized tables executed serially
• E.  Index unique scan access by primary key to heap organized tables executed in parallel
• F.  Full table scans on heap organized tables executed in parallel

You are patching your Exadata X6 Database Machine by applying a new image to the Storage Servers in a rolling fashion.
Your ASM environment on the Database Machine has five diskgroups stored on an unpartitioned Exadata storage grid, with redundancy settings as shown:
1. DATA_DBM1 - Normal Redundancy
2. RECO_DBM1 - Normal Redundancy
3. DBFS_DG - Normal Redundancy
4. DATA2_DBM1 - High Redundancy
5. DATA3_DBM1 High Redundancy
Which two diskgroups will not suffer from any data loss throughout the patching process even if there is a single disk failure on one of the cells

• A.  RECO_DBM1
• B.  DBFS_DG
• C.  DATA3_DBM1
• D.  DATA2_DBM1
• E.  DATA_DBM1

Which three are recommended options on an X5 Exadata Database machine, for staging files that will be loaded as external tables?

• A.  a DBFS file system stored in a staging database on the Database Machine
• B.  an Exadata-based ACFS file system on the Database Machine
• C.  a ZFS over NFS file system mounted on a database server where the external table will be accessed
• D.  on local storage on one or more storage servers that are accessible to the database server where the load will be performed
• E.  on an ACFS file system stored in a staging database on the Database Machine