1Z0-515 Exam Questions
71 real 1Z0-515 exam questions with expert-verified answers and explanations. Page 2 of 2.
- Question #51
Why does partitioning help parallelism with RAC?
- Question #52
You are looking for some general design principles that could be used in designing every large scale data warehouse you create. Identify the principle that would have the widest ap...
- Question #53
What is the difference between an ETL (Extraction Transformation Load) approach and an ELT (Extraction Load Transformation) approach to data integration? Select one.
- Question #54
Identify the benefit of using bitmap join indexes. Select one.
- Question #55
What data can you compress using Advanced Compression in Oracle Database 11g?
- Question #56
Which best describes Oracle's OLAP Option for Oracle Database 11g Release 2?
- Question #57
The most performant way to load data from an external table that will also guarantee direct path loading is:
- Question #58
Identity the true statement about a data warehouse
- Question #59
Identify the statement about ASM that is NOT true.
- Question #60
Which two statements are true about the advantages of using a data warehouse?
- Question #61
What are two ways in which query performance can be improved with partitioning?
- Question #62
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 managin...
- Question #63
You have analyzed your client's workload and the SQL Access Advisor in Enterprise Manager recommends that you create some materialized views to improve performance. What should you...
- Question #64
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 hol...
- Question #65
What would you do to compress data in partitions that are frequently updated in Oracle Database 11g?
- Question #66
What would you use to evenly distribute data across the disk in your Oracle data warehouse?
- Question #67
You want to enable result set caching to quickly see if this feature will help the performance of your application. Which is the quickest way to make this determination?
- Question #68
Which is NOT an advantage provided by partitioning?
- Question #69
Which condition can cause a change in the contents of the SQL Result Set Cache?
- Question #70
What areas can SQL Access Advisor give advice on?
- Question #71
How does partitioning help to INCREASE AVAILABILITY?