1Z0-515
(Data Warehousing 11g Essentials)
Document version: 19.10.11
1Z0-515 Exam Questions
Important Note About 1Z0-515 PDF
techeXams’ 1Z0-515 PDF is a comprehensive compilation of questions and answers that have been
developed by our team of certified professionals. In order to prepare for the actual exam, all you
need is to study the content of this exam questions. An average of approximately 10 to 15 hours
should be spent to study these exam questions and you will surely pass your exam. It’s our
guarantee.
Copyright
techeXams holds the copyright of this material. techeXams grants you a limited license to view and
study this material, either for personal or commercial use. Unauthorized reproduction or distribution
of this material, or any portion thereof, may result in severe civil and criminal penalties, and will be
prosecuted to the maximum extent possible under law.
Disclaimer
Neither this guide nor any material in this guide is sponsored, endorsed or affiliated with any of the
respective vendor. All trademarks are properties of their respective owners.
1
© Copyright www.techeXams.ws 2011 1Z0-515 Practice Exams, 1Z0-515 Audio Trainings, 1Z0-515 Study Guides
1Z0-515 Exam Questions
Question: 1
Your customer is looking to implement ad-hoc analysis in a data warehouse. Which
approach is least likely to be used assuming that the customer does not want the expense
of managing view?
A. Star schema
B. Snowflake schema
C. Third normal form schema
D. OLAP
Answer: A
Question: 2
Which feature would enable higher availability during maintenance operations while also
improving query response performance?
A. Partitioning
B. Materialized views
C. Bitmap Indexing
D. OLAP
Answer: A
Question: 3
Identify the statement about Oracle OLAP that is NOT true.
A. Oracle OLAP cubes are stored in the Oracle relational database
B. Oracle OLAP uses standard Oracle database security.
C. Meta data for Oracle OLAP is accessible in an external data dictionary
D. Oracle OUP can be deployed using RAC.
Answer: A
Explanation:
2
© Copyright www.techeXams.ws 2011 1Z0-515 Practice Exams, 1Z0-515 Audio Trainings, 1Z0-515 Study Guides
1Z0-515 Exam Questions
http://download.oracle.com/docsIcd/B2835SOlIolap.111/b28I 24/whatsnew.htm
Question: 4
The most performant way to load data from an external table that will also guarantee
direct path loading is:
A. Using Create Table as Select (CTAS)
B. Using Data Pump
C. Using Insert as Select (lAS)
D. Using transparent gateways
Answer: A
Explanation:
http://www.filibeto.org/sun/lib/nonsun/oracle/11.1
.0.6.0/B28359_01/server.111/b28310/tables004.htm
Question: 5
For which type of query is the SQL result cache automatically disabled?
A. Queries that access data which changes frequently
B. Queries that return large amounts of data
C. Queries that use SQL functions such as SYSDATE
D. Queries that are used infrequently
Answer: C
Explanation:
http:Ilbooks.google.comlbooks?id-4S6xQu-rmYC&pg=PA821 &l pgPA821&dqSQL+result+cache+aut
omatically+disabled&source=bl&ots=cmCLbFNfO-&sig=0EPalT1ws3PkpqVhs-
DSfalAnrQ&hl=en&ei=o8Y-TZtD0_fiBs6GzKUK&sa=X&oi=book_resuIt&ct=result&resnum=1&ved=OC
BUQ6AEwAA#v=onepage &qSQL%20result%20cache%20automatically%20disabled&f=false
Question: 6
3
© Copyright www.techeXams.ws 2011 1Z0-515 Practice Exams, 1Z0-515 Audio Trainings, 1Z0-515 Study Guides
1Z0-515 Exam Questions
A Full Rack Oracle Exadata Database Machine can contain 100 TB of disk space with high
performance. How much user data should you conservatively estimate this configuration
can hold?
A. 100 TB
B. 75 TB
C. 50 TB
D. 28 TB
E. 20 TB
Answer: A
Get Full Version of Exam 1Z0-515 PDF Q&A
techeXams presents authentic, genuine and valid study material, which promise 100%
success in very first attempt. To take optimal results for 1Z0-515 exam, you need to
buy full version of 1Z0-515 question and answer. An average of approximately 10 to 15
hours should be spent to study these exam questions and you will surely pass your
exam. So come join us and quench your thirst for knowledge.
Get complete 1Z0-515 questions and answers by visiting URL
“http://www.techexams.ws/exams/1Z0-515 .do”
4
© Copyright www.techeXams.ws 2011 1Z0-515 Practice Exams, 1Z0-515 Audio Trainings, 1Z0-515 Study Guides