单选题Which is a restriction on a list partitioned table？（）AYou cannot create global range partitioned indexes on the table. BThe optimizer will not execute partition wise joins on the table’s partitions. CYou must include at least one element in the value list of each partition of the table, even if that element is the keyword NULL. DPartition pruning will not occur during query optimizer if a range of values is included in the query predicate.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
Excel 2003的默认工作表分别命名为()A：Sheetl，Sheet2，Sheet3，Sheet4，Sheet5B：Book1，Book2，Book3，Book4，Book5C：Table1，Table2，Table3，Table4，Table5D：List1，List2，List3，List4，List5
Excel2010的默认工作表分别命名为() A、Sheetl,Sheet2,Sheet3B、Book1,Book2,Book3C、Table1,Table2,Table3D、List1,List2,List3
Which three operations can be performed as multipartition operations in Oracle?() A. Merge partitions of a list partitioned tableB. Drop partitions of a list partitioned tableC. Coalesce partitions of a hash-partitioned global index.D. Move partitions of a range-partitioned tableE. Rename partitions of a range partitioned tableF. Merge partitions of a reference partitioned index
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?() A. ALTER TABLE SPLIT PARTITIONB. ALTER TABLE MERGE PARTITIONC. ALTER TABLE TRUNCATE PARTITIOND. ALTER TABLE ADD PARTITIONE. ALTER TABLE DROP PARTITIONF. ALTER TABLE MOVE PARTITION
Which of the following utilities can be used to list the routing table?() A.ipconficjB.nslookupC.netstatD.dig
When defining a referential constraint between the parent table T2 and the dependent table T1, which of the following is true?() A.The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.B.The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.C.The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.D.The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.
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.
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 tablesB、object tablesC、partitioned tablesD、index-organized tables （IOTs）
Excel 2010的默认工作表分别命名为（）。A、Sheetl，Sheet2，Sheet3B、Book1，Book2，Book3C、Table1，Table2，Table3D、List1，List2，List3
Which of the following utilities can be used to list the routing table?（）A、ipconficjB、nslookupC、netstatD、dig
A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month’s data?（）A、Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.B、Create 12 separate tables, create a view based on all 12, drop the table with the oldest month's data then drop and re- create the view.C、Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.D、Create a single table, extract the data to be retained using UNLOAD with a SELECT statement, drop and re-create the table then load only the data to be retained.
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）A、ALTER TABLE SPLIT PARTITIONB、ALTER TABLE MERGE PARTITIONC、ALTER TABLE TRUNCATE PARTITIOND、ALTER TABLE ADD PARTITIONE、ALTER TABLE DROP PARTITIONF、ALTER TABLE MOVE PARTITION
You executed the following code： SQL CERATE TABLE COUNTRY （COUNTRY_ID CHAR（2） CONSTRAINT COUNTRY_ID_nn NOT NULL， COUNTRY_NAME VARCHAR2（20）， CURRENCY_NAME VARCHAR2（20）， CONSTRAINT COUNTRY_ID_PK PRIMARY KEY （COUNTRY_ID）） ORGANIZATION INDEX； Which types of tables will be created automatically？（）A、 journal tableB、 clustered tableC、 mapping tableD、 partitioned table
The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（） A、the DBNEWID utilityB、the ANALYZE commandC、the RMAN LIST commandD、the RMAN REPORT commandE、the RMAN CROSSCHECK commandF、the RMAN BLOCKRECOVER command
Identify the logical structure that will never have more than one data segment created for it.（）A、external tableB、partitioned tableC、partitioned indexD、nonclustered tableE、global temporary table
Which three operations can be performed as multipartition operations in Oracle?（）A、Merge partitions of a list partitioned tableB、Drop partitions of a list partitioned tableC、Coalesce partitions of a hash-partitioned global index.D、Move partitions of a range-partitioned tableE、Rename partitions of a range partitioned tableF、Merge partitions of a reference partitioned index
You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）； Which two statements are correct？ （）A、 The FLASHBACK TABLE statement will not be written to the alert log file.B、 The EMP table that was dropped by mistake from the database will be restored.C、 The changes made to the EMP table since the specified time will be undone.D、 The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.E、 The FLASHBACK TABLE statement will be executed within a single transaction.F、 The list of transactions that have modified the EMP table since the specified time will be displayed.
单选题You executed the following code： SQL CERATE TABLE COUNTRY （COUNTRY_ID CHAR（2） CONSTRAINT COUNTRY_ID_nn NOT NULL， COUNTRY_NAME VARCHAR2（20）， CURRENCY_NAME VARCHAR2（20）， CONSTRAINT COUNTRY_ID_PK PRIMARY KEY （COUNTRY_ID）） ORGANIZATION INDEX； Which types of tables will be created automatically？（）A journal tableB clustered tableC mapping tableD partitioned table
单选题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 tablesB object tablesC partitioned tablesD index-organized tables （IOTs）
多选题You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）; Which two statements are correct？（）AThe FLASHBACK TABLE statement will not be written to the alert log file.BThe changes made to the EMP table since the specified time will be undone.CThe EMP table that was dropped by mistake from the database will be restored.DThe FLASHBACK TABLE statement will be executed within a single transaction.EThe FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.FThe list of transactions that have modified the EMP table since the specified time will be displayed.
单选题The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）Athe DBNEWID utilityBthe ANALYZE commandCthe RMAN LIST commandDthe RMAN REPORT commandEthe RMAN CROSSCHECK commandFthe RMAN BLOCKRECOVER command
多选题Which statements are true regarding system-partitioned tables？（）AOnly a single partitioning key column can be specified.BAll DML statements must use partition-extended syntax.CThe same physical attributes must be specified for each partition.DUnique local indexes cannot be created on a system-partitioned table.ETraditional partition pruning and partitionwise joins are not supported on these tables.
单选题You are designing an application for a telecom company 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？（）Acreate a hash cluster to store the dataBcreate an index cluster to store the dataCcreate a partitioned table to store the dataDcreate a sorted hash cluster to store the dataEcreate a heap table with rowid to store the data
多选题Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）AALTER TABLE SPLIT PARTITIONBALTER TABLE MERGE PARTITIONCALTER TABLE TRUNCATE PARTITIONDALTER TABLE ADD PARTITIONEALTER TABLE DROP PARTITIONFALTER TABLE MOVE PARTITION
多选题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?（）AUsing 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.BUsing 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.CUsing a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.DConverting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned columnEUsing 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.FUsing 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.
单选题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 dataB create an index cluster to store the dataC create a partitioned table to store the dataD create a sorted hash cluster to store the dataE create a heap table with rowid to store the data
多选题Which three operations can be performed as multipartition operations in Oracle?（）AMerge partitions of a list partitioned tableBDrop partitions of a list partitioned tableCCoalesce partitions of a hash-partitioned global index.DMove partitions of a range-partitioned tableERename partitions of a range partitioned tableFMerge partitions of a reference partitioned index
单选题By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） a list of changes made along with the transaction identifier of each change b） the necessary SQL statements to undo the erroneous changes Which option would you choose？（）ARMAN onlyBFlashback Table onlyCFlashback Versions Query onlyDFlashback Database and Flashback Transaction QueryEFlashback Versions Query and Flashback Transaction Query