多选题In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database? Both local and global partitioned B-tree Indexes are

第1题：

While designing your database， you have created the EMPLOYEES table as an index-organized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（） 

• A、A primary key must have been created.
• B、A mapping table must have been created.
• C、An overflow tablespace must have been specified.
• D、The PCTTHRESHOLD option must have been specified.

第2题：

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）

• A、Each extra column in the copy with more columns must not have a default value
• B、Columns that are common to both versions of the table must be defined in the same order on the master and the slave
• C、The slave database cannot have more columns than the master. Only the master database can have more columns
• D、Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server
• E、The master database cannot have more columns than the slave. Only the slave deatbase can have more columns

第3题：

A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index. Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions. This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month. You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned. Which three methods could transparently help to achieve this result?（）

• A、Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.
• B、Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
• C、Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.
• D、Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column
• E、Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.
• F、Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.

第4题：

While designing the database for one of your online transaction processing （OLTP） applications， you want to achieve the following：  a） high availability of data  b） faster primary key access to the table data  c） compact storage for the table  Which type of tables would you use to achieve these objectives？（）

• A、heap tables
• B、object tables
• C、partitioned tables
• D、index­organized tables （IOTs）

第5题：

If you create your database using Oracle Managed Files （OMF）， what is true？（）

• A、You must use Oracle predefined names to identify raw partitions that will hold OMF structures. 
• B、You must define directories for two online redo log groups and three copies of the control file. 
• C、If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. 
• D、You must use only OMF data files when adding new tablespaces or data files to your database in the future.

第6题：

In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database? Both local and global partitioned B-tree Indexes are defined on the table. A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends. Minimal disrupt ion to availability is required. Which three statements are true about this requirement?（）

• A、The partitions can be moved online to new tablespaces.
• B、Global indexes must be rebuilt manually after moving the partitions.
• C、The partitions can be compressed in the same tablespaces.
• D、The partitions can be compressed in the new tablespaces.
• E、Local indexes must be rebuilt manually after moving the partitions.

第7题：

You work as a database administrator for Certkiller .com. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）

• A、Database Control
• B、Management Server
• C、Management Repository
• D、Application Server Control
• E、Oracle Management Agent

第8题：

ou have a large amount of historical data in a flat file. Some analysts in your organization need to query thisdata in the file. The file is too large to load the data in it into your current database.  Which is the most effectivemethod to access this data in your database（）

• A、Use the database link.
• B、Use the SQL*Loader utility.
• C、Use the Oracle Data Pump utility.
• D、Create an external table and leave the data in the flat file

第9题：

第10题：

第11题：

第12题：

第13题：

Which is a restriction on a list partitioned table？（）

• A、You cannot create global range partitioned indexes on the table. 
• B、The optimizer will not execute partition wise joins on the table’s partitions. 
• C、You must include at least one element in the value list of each partition of the table, even if that element is the keyword NULL. 
• D、Partition pruning will not occur during query optimizer if a range of values is included in the query predicate.

第14题：

A system administrator needs to provision storage for a 200GB database. The database must have extremely low seek time. Which of the following is the BEST solution？（）

• A、A JBOD
• B、A RAID 50 array
• C、A NAS
• D、A single SSD

第15题：

You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database.  Which is the most effective method to access this data in your database（）

• A、Use the database link.
• B、Use the SQL*Loader utility.
• C、Use the Oracle Data Pump utility.
• D、Create an external table and leave the data in the flat file

第16题：

You work as a database administrator for Certkiller .com. In your production  database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections.  Which activity must you have completed before accomplishing this task？（）

• A、You must have started the database instance in restricted mode.
• B、You must have started the database instance inNORMALmode.
• C、You must have started the database instance with server parameter file.
• D、You must have started the database instance but must not have mounted.
• E、You must have started the database instance but must not have opened.

第17题：

 You are creating tablespaces in Oracle. Which of the following keywords or clauses permits the datafiles of a database to grow automatically in order to accommodate data growth?（）

• A、DEFAULT STORAGE 
• B、EXTENT MANAGEMENT 
• C、AUTOEXTEND 
• D、DATAFILE

第18题：

Which three operations can be performed as multipartition operations in Oracle?（）

• A、Merge partitions of a list partitioned table
• B、Drop partitions of a list partitioned table
• C、Coalesce partitions of a hash-partitioned global index.
• D、Move partitions of a range-partitioned table
• E、Rename partitions of a range partitioned table
• F、Merge partitions of a reference partitioned index

第19题：

You are designing an application for Certkiller .com and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order.Which method would you follow to achieve this objective without increasing the overhead of sorting the rows？（）

• A、 create a hash cluster to store the data
• B、 create an index cluster to store the data
• C、 create a partitioned table to store the data
• D、 create a sorted hash cluster to store the data
• E、 create a heap table with rowid to store the data

第20题：

You are designing a Windows Azure application that will store data. You have the following requirements：   - The data storage system must support the storage of more than 500 GB of data.   - Data retrieval must be possible from a large number of parallel threads without threads blocking each other.   You need to recommend an approach for storing data.  What should you recommend？（）

• A、 Use Windows Azure Queues.
• B、 Use Windows Live Mesh 2011.
• C、 Use a single SQL Azure database.
• D、 Use Windows Azure Table storage

第21题：

第22题：

第23题：

第24题：