Free Cheat-test Samples and Demo Questions Download
Adobe exams Adobe
Apple exams Apple
Avaya exams Avaya
Check Point exams Check Point
Cisco exams Cisco
Citrix exams Citrix
CIW exams CIW
CompTIA exams CompTIA
CWNP exams CWNP
EC-Council exams EC-Council
EMC exams EMC
Exin exams Exin
Fortinet exams Fortinet
GIAC exams GIAC
Hitachi exams Hitachi
HP exams HP
IBM exams IBM
Isaca exams Isaca
ISC exams ISC
ISEB exams ISEB
Juniper exams Juniper
LPI exams LPI
McAfee exams McAfee
Microsoft exams Microsoft
Oracle exams Oracle
PMI exams PMI
Riverbed exams Riverbed
SNIA exams SAP
Sun exams SAS
Symantec exams Symantec
VMware exams VMware
All certification exams

Oracle 1Z0-027 Exam - Cheat-Test.com

Free 1Z0-027 Sample Questions:

Q: 1
Which tool will provide you with diagnostic information for all the software log, trace files, and OS information on Database Machine?
A. dbmcheck.sh
B. diagget.sh
C. oswatcher
D. adrci
E. Enterprise Manager
Answer: B

Q: 2
Which three factors should you consider when choosing a method for migrating a database to the Database Machine?
A. Typeof database workload
B. Number of tablespaces in the source database
C. Size of the source database
D. Endian format of the source database
E. ASM attributes and allocation unit (AU) size of the diskgroups used by the source database
Answer: A, C, D

Q: 3
Which three are among the software components that constitute the QoS Management framework?
A. Cluster Health Monitor (CHM)
B. Cluster Verification Utility (CLUVFY)
C. O/S Resource Manager
D. Grid Infrastructure for a standalone server
E. Grid Infrastructure for a cluster
F. OC4J cluster resource
Answer: A, E, F

Q: 4
Which two communication methods are used by which components in the Enterprise manager Architecture for the Database Machine?
A. SNMP traps for alerts are sent by the storage server ILOM to the storage serverMSprocess
B. SNMP traps for alerts are sent by the storage serverMSprocess to the storage server ILOM
C. SNMP traps for alerts are sent by the storage serverILOMto the Enterprise Manageragent.
D. SNMP traps for alerts are sent by the storage serverMSprocess to the enterprise Manageragent
E. SNMP traps for alerts are sent by the storage server ILOM to the storage server RS process.
Answer: A, D

Q: 5
Which three statements are true regarding the configuration of Auto Service Request (ASR) on your Database Machine?
A. HTTPS connectivity must be enabled from the ASK Manager host to the internet.
B. ASR Manager must be installed on one of the database servers.
C. Oracle Solaris must be used on the server where ASK Manager is installed.
D. SMTP must be enabled on at least one database server.
E. Oracle Linux must be used on the server where ASR Manager is installed
F. ASRManager may be installed on any type of server running Oracle Linux.
G. ASRManager may be installed on any type of server running Oracle Solaris.
Answer: A, F, G

Q: 6
Which two are true about Smart Scan?
A. a query rewrite may occur to a container table stored in Exadata but will never benefit From Smart scan.
B. Column projection does not contribute to the performance benefit of Smart Scan
C. It is possible to offload single row functions to the storage servers.
D. Some joins can be offloaded to the storage servers.
E. A query rewrite may occur to a container table stored Exadata, and it will always benefit from Smart Scan.
F. All joins can be offloaded to the storage servers.
Answer: C, D

Q: 7
A read-only application is in development and is using a test database on a Database Machine. You are examining SQL statements from this application in an attempt to determine which ones will benefit from the Exadata Smart scan capability.
The following is true about the tables used by the application:
1. The data for the tables has just been loaded.
2. There are no applications accessing the tables currently.
3. None of the indexes are compressed or reverse key indexes.
4. The tables use the default organization type data.
5. The only data types for the table are varchar (2), number, or date.
6. The largest number of columns for any table is 29.
7. No access is based on ROWID, or virtual columns.
Which two access paths will always generate either a set of “cell smart table scan” or a set of “cell smart index scan” requested?
A. Full scans on sorted hash clustered tables executed in parallel
B. Full table scans on index organized tables executed in parallel.
C. Full table scans on heap tables executed in parallel
D. Full scans on index clustered tables executed in parallel
E. full scans on hash clustered tables executed in serially
F. fast full scans on B*Tree indexes executed in parallel
G. full index scans on B*Tree indexes executed in parallel
Answer: B, G


© 2014 Cheat-Test.com, All Rights Reserved