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.
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.
相关考题：
Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3;What is the outcome of executing the above statement?() A.A syntax error will result as you cannot specify more than one partition in the same statementB.All data in p1 and p3 partitions are removed and the table definition is changedC.All data in p1 and p3 partitions are removed, but the table definition remains unchangedD.Only the first partition (p1) will be dropped as only one can be dropped at any time
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
You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.What should you do?A．Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.B．Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.C．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.D．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.
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.
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 columnE、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.
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 have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals： SQL EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’，’SALES’，GRANULARITY=’GLOBAL’）； You need statistics to be collected more quickly. What can you do to achieve this？（）A、 Set DYNAMIC_SAMPLING to level 4B、 Set the STATISTICS_LEVEL parameter to BASICC、 Set the INCREMENTAL value to TRUE for the partition tableD、 Increase the value of STALE_PERCENT for the partition table
Which statements are true regarding system-partitioned tables？（） A、 Only a single partitioning key column can be specified.B、 All DML statements must use partition-extended syntax.C、 The same physical attributes must be specified for each partition.D、 Unique local indexes cannot be created on a system-partitioned table.E、 Traditional partition pruning and partitionwise joins are not supported on these tables.
You created the DEPT table by using the following command： CREATE TABLE scott.dept （deptno NUMBER（3）， dname VARCHAR2（15）， loc VARCHAR2（15） ） STORAGE （INITIAL 100K NEXT 50K MAXEXTENTS 10 PCTINCREASE 5 FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）A、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.B、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.C、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.D、 You cannot shrink the SCOTT.EMP table.
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.
Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）A、A syntax error will result as you cannot specify more than one partition in the same statementB、All data in p1 and p3 partitions are removed and the table definition is changedC、All data in p1 and p3 partitions are removed, but the table definition remains unchangedD、Only the first partition (p1) will be dropped as only one can be dropped at any time
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 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
You are responsible for managing the database schema for an order entry application in a SQL Server 2005 database. After a design review, a member of the development staff asks you to add a new column named CommissionRate to the Product table. Because the actual commission rates for all products are not known at this time, each product has a default commission rate of 12 percent. The rate can be modified as necessary. You add the new column. You need to configure the table to assign the default value as efficiently as possible. What should you do?（）A、 Create an INSERT trigger to assign the default value to each item in the table. B、 Create a CHECK constraint to validate the data and to assign the default value to each item in the table. C、 Create an UPDATE trigger to update the default value for each new item in the table. D、 Create a DEFAULT constraint to assign the default value specifying the WITH VALUES argument.
You are designing an application that will use Windows Azure Table storage to store millions of data points each day. The application must retain each day’s data for only one week. You need to recommend an approach for minimizing storage transactions. What should you recommend？（）A、 Use a separate table for each date. Delete eachtable when it is one week old.B、 Use a separate table for each week. Delete each table when it is one week old.C、 Use a single table， partitioned by date. Use Entity Group Transactions to delete data when it is one week old.D、 Use a single table， partitioned by week. Use Entity Group Transactions to delete data when it is one week old.
多选题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?（）AThe partitions can be moved online to new tablespaces.BGlobal indexes must be rebuilt manually after moving the partitions.CThe partitions can be compressed in the same tablespaces.DThe partitions can be compressed in the new tablespaces.ELocal indexes must be rebuilt manually after moving the partitions.
单选题You want to create a temporary table while executing a procedure in a form. Which statement is true?（）AYou cannot create a table form within Forms. BYou must use the FORMS_DDL built-in to create the table. CYou must use the DBMS_DYNAMIC_DDL package to create the table. DYou can write the CREATE TABLE statement directly into the trigger.
多选题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 that will use Windows Azure Table storage to store millions of data points each day. The application must retain each day’s data for only one week. You need to recommend an approach for minimizing storage transactions. What should you recommend？（）A Use a separate table for each date. Delete eachtable when it is one week old.B Use a separate table for each week. Delete each table when it is one week old.C Use a single table， partitioned by date. Use Entity Group Transactions to delete data when it is one week old.D Use a single table， partitioned by week. Use Entity Group Transactions to delete data when it is one week old.
单选题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
多选题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.
多选题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.
单选题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.
单选题You find that some queries on a table are taking a long time to execute because there are no indexes created on the table. You decide to invoke the SQL Access Advisor to determine the appropriate index to be created. Which package will you use to invoke the SQL Access Advisor？（）ADBMS_SERVER_ALERTBDBMS_ADVISORCDBMS_RESOURCE_MANAGERDDBMS_REPAIR
多选题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