单选题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?（）AA syntax error will result as you cannot specify more than one partition in the same statementBAll data in p1 and p3 partitions are removed and the table definition is changedCAll data in p1 and p3 partitions are removed, but the table definition remains unchangedDOnly the first partition (p1) will be dropped as only one can be dropped at any time
单选题
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 statement
B
All data in p1 and p3 partitions are removed and the table definition is changed
C
All data in p1 and p3 partitions are removed, but the table definition remains unchanged
D
Only the first partition (p1) will be dropped as only one can be dropped at any time
参考解析
解析：
暂无解析
相关考题：
Which of the following financial statements reports information as of a specific date? () A. income statementB. statement of owner's equityC. statement of cash flowsD. balance sheet
Consider the following:Which statement best describes the meaning of the value for the key_len column?() A.It shows the total size of the index rowB.It shows how many columns in the index are examinedC.It shows the number of characters indexed in the keyD.It shows how many bytes will be used from each index row
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
在下列查询语句中，与SELECT TABl*FROM，TABl WHERE InStr([简历]，”篮球”)o功能相同的语句是（ ）。A.SELECT TABl．*FROM TABl WHERE TABl．简历Like”篮球”B.SELECT TABl．*FROM TABl WHERE TABl．简历Like”*篮球”C.SELECT TABl．*FROM TABl WHERE TABl．简历Like”*篮球*”D.SELECT TABl．*FROM TABl WHERE TABl．简历Like”篮球*”
Consider the following table called EMPLOYEES: ID FIRSTNAME LASTNAME JOB LEVELCLERK 3If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1() A.0B.1C.3D.6
As Alice believed him to be a man of integrity, she refused to consider the possibility that his statement was＿＿． A. irrelevant B. facetious C. fictitious D. illogical
In JUNOS software, how is route summarization at the L1/L2 border configured?（）A、by specifying the area-range statementB、by creating aggregate routes and applying policiesC、by specifying the route-summarization statementD、by specifying the area-range restrict statement
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.
Ⅲ. There are four choices following each statement. Mark the choice that can best complete the statement: If a linguistic study describes and analyzes the language people actually use, it is said to be （）A、prescriptiveB、analyticC、descriptiveD、linguistic
执行指令DJNZ R1，TABL1，下面描述正确的是（）。A、 R1中的内容如不等于零，程序跳转到TABL1处执行B、 R1中的内容减1如不等于零，程序跳转到TABL1处执行C、 R1中的内容加1如有溢出，程序跳转到TABL1处执行D、 R1中的内容减1如等于零，程序跳转到TABL1处执行
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 of the following is required to connect a partitioned p5-550 to a modem？（）A、A modem adapterB、An async adapter and serial cableC、An Ethernet adapterD、A 9-pin to 25-pin converter and serial cable
In JUNOS software， how is route summarization at the L1/L2 border configured？（）A、By specifying the area-range statement.B、By creating aggregate routes and applying policies.C、By specifying the route-summarization statement.D、By specifying the area-range restrict statement.
You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）A、Immediately following statement execution B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued C、After the ALTER TABLE SET UNUSED COLUMN command is issued D、After the ALTER TABLE MODIFY command is issued
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
单选题Consider the following table called EMPLOYEES: ID FIRSTNAME LASTNAME JOB LEVEL CLERK 3 If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1（）A 0B 1C 3D 6
单选题In JUNOS software， how is route summarization at the L1/L2 border configured？（）ABy specifying the area-range statement.BBy creating aggregate routes and applying policies.CBy specifying the route-summarization statement.DBy specifying the area-range restrict statement.
单选题Your application regularly issues the following statement: SELECT * FROM BANK_ACCT WHERE ACCT_BALANCE BETWEEN 1000 and 10000; Which of the following database objects would be inappropriate for use with this statement?（）AMaterialized views BIndexes CIndex-organized tables DHash clusters
单选题Which of the following resources can be referenced in the LOCK statement?（）ARowBTableCColumnDTable space
单选题Consider the following scenario for your database: Which statement is true regarding the backup of the TOOLS tablespace?（）A The RMAN backup fails because the TOOLS tablespace is read-onlyB The RMAN skips the backup of the tablespace because backup optimization is enabledC The RMAN makes backup because optimization can be enabled only for backups to diskD The RMAN makes the backup because no backup of the tablespace exists within the seven day window
单选题Which of the following network modifications should be implemented to extend the wirelessnetwork range and allow out-of-range users to share the Internet connection?（）ACreate a new VLAN for the out-of-range users.BAdd a wireless access point for the out-of-range users.CUpgrade the out-of-range users’ SSID searching software.DEnable network sharing on the users’ computers that are within range.
多选题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.
单选题In JUNOS software, how is route summarization at the L1/L2 border configured?（）Aby specifying the area-range statementBby creating aggregate routes and applying policiesCby specifying the route-summarization statementDby specifying the area-range restrict statement
单选题You need to create a partitioned table to store historical data and you issued the following command： CREATE TABLE purchase_interval PARTITION BY RANGE （time_id） INTERVAL （NUMTOYMINTERVAL（1，’month’）） STORE IN （tbs1，tbs2，tbs3） （ PARTITION p1 VALUES LESS THAN（TO_DATE（’1-1-2005’， ’dd-mm-yyyy’））， PARTITION p2 VALUES LESS THAN（TO_DATE（’1-1- 2007’， ’dd-mm-yyyy’））） AS SELECT * FROM purchases WHERE time_id TO_DATE（’1-1-2007’，’dd-mm-yyyy’）； What is the outcome of the above command？（）A It returns an error because the range partitions P1 and P2 should be of the same range.B It creates two range partitions （P1， P2）. Within each range partition， it creates monthwise subpartitions.C It creates two range partitions of varying range. For data beyond ’1-1-2007，’ it creates partitions with a width of one month each.D It returns an error because the number of tablespaces （TBS1，TBS2，TBS3）specified does not match the number of range partitions （P1，P2） specified.
多选题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
单选题Which of the following radar contacts will present the most immediate danger?（）.AA vessel on the starboard bow whose bearing is changing and range is decreasingBA vessel on the starboard bow whose bearing is steady and range is increasingCA vessel on the port bow whose bearing is steady and range is decreasingDA vessel on the port bow whose bearing is changing to the left and range decreasing