1Z0-515 Exam Questions
71 real 1Z0-515 exam questions with expert-verified answers and explanations. Page 2 of 2.
- Question #51Partitioning
Why does partitioning help parallelism with RAC?
partition-wise joinsRACinterconnect trafficparallelism - Question #52Introduction to Data Warehousing Concepts
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...
data warehouse designpartitioningpartition-wise joinsdesign principles - Question #53Loading Data into the Data Warehouse
What is the difference between an ETL (Extraction Transformation Load) approach and an ELT (Extraction Load Transformation) approach to data integration? Select one.
ETLELTdata integrationtransformation approaches - Question #54Introduction to Data Warehousing Concepts
Identify the benefit of using bitmap join indexes. Select one.
bitmap join indexesquery performanceindex benefits - Question #55Advanced Concepts
What data can you compress using Advanced Compression in Oracle Database 11g?
Advanced CompressionDML operationsOracle 11gcompression types - Question #56Advanced Concepts
Which best describes Oracle's OLAP Option for Oracle Database 11g Release 2?
OLAP OptionOLAP cubesrelational databaseROLAP - Question #57Loading Data into the Data Warehouse
The most performant way to load data from an external table that will also guarantee direct path loading is:
external tableCTASdirect path loadingdata loading methods - Question #58Introduction to Data Warehousing Concepts
Identity the true statement about a data warehouse
data warehouse characteristicshistorical dataOLTP vs DW - Question #59Advanced Concepts
Identify the statement about ASM that is NOT true.
ASMAutomatic Storage Managementstorage optionsOracle licensing - Question #60Introduction to Data Warehousing Concepts
Which two statements are true about the advantages of using a data warehouse?
data warehouse advantagesschema designmaterialized viewsquery performance - Question #61Partitioning
What are two ways in which query performance can be improved with partitioning?
partition pruningpartition-wise joinsquery performanceI/O optimization - Question #62Introduction to Data Warehousing Concepts
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...
ad-hoc analysisstar schemaOLAPschema comparison - Question #63Materialized Views
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...
SQL Access Advisormaterialized viewsperformance tuningEnterprise Manager - Question #64Advanced Concepts
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...
Exadatastorage capacitycompression ratioFull Rack - Question #65
What would you do to compress data in partitions that are frequently updated in Oracle Database 11g?
- Question #66Advanced Concepts
What would you use to evenly distribute data across the disk in your Oracle data warehouse?
ASMdata stripingdisk distributionstorage management - Question #67Advanced Concepts
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?
result set cacheRESULT_CACHE_MODEinitialization parametersperformance tuning - Question #68Partitioning
Which is NOT an advantage provided by partitioning?
partitioning advantagesstorage requirementsI/O reductionparallelism - Question #69Advanced Concepts
Which condition can cause a change in the contents of the SQL Result Set Cache?
SQL Result Set Cachecache invalidationDML impactcache management - Question #70Advanced Concepts
What areas can SQL Access Advisor give advice on?
SQL Access Advisorpartitioning advicematerialized viewsindex advice - Question #71Partitioning
How does partitioning help to INCREASE AVAILABILITY?
partitioning availabilitymaintenance windowshigh availabilitypartition management