Vendor
: Oracle
Exam Code : 1Z0-027
Version: Demo
Cheat-Test, help you pass any IT exam!
Cheat-Test.com - The Worldwide Renowned IT Certification Material Provider! The safer, easier way to help you pass any IT Certification exams.
We provide high quality IT Certification exams practice questions and answers (Q&A). Especially Cisco, Microsoft, HP, IBM, Oracle, CompTIA, Adobe, Apple, Citrix, EMC, Isaca, Avaya, SAP and so on. And help you pass an IT Certification exams at the first try.
Cheat-Test product Features: •
Verified Answers Researched by Industry Experts
•
Questions updated on regular basis
•
Like actual certification exams our product is in multiple-choice questions (MCQs).
•
Our questions and answers are backed by our GUARANTEE.
7x24 online customer service: contact@cheat-test.com
Click Here to get more Free Cheat-Test Certification exams!
http://www.Cheat-Test.com
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