单选题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 state

题目

单选题

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 syntax error will result as you cannot specify more than one partition in the same statement

All data in p1 and p3 partitions are removed and the table definition is changed

All data in p1 and p3 partitions are removed, but the table definition remains unchanged

Only the first partition (p1) will be dropped as only one can be dropped at any time

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

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

参考答案：B

第2题：

在下列查询语句中，与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”篮球*”

正确答案：C
本题考查的是InStr函数。InStr函数的格式为：InStr(字符表达式1，字符表达式2[，数值表达式])其功能是检索字符表达式2在字符表达式l中最早出现的位置，返回整数，若没有符合条件的数，则返回0。本题的查询的条件是在简历字段中查找是否出现了“篮球”字样。应使用关键词“Like”；在“篮球”的前后都加上“*”，代表要查找的是“篮球”前面或后面有多个或0个字符的数据，这样也就是查找所有简历中包含“篮球”的记录。

第3题：

Which of the following financial statements reports information as of a specific date? ()

A. income statement

B. statement of owner's equity

C. statement of cash flows

D. balance sheet

参考答案：D

第4题：

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.

正确答案:C

第5题：

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

答案：C

解析：

考查形容词辨析。空格要填入的是一个形容词，修饰“他的陈述（his statement)”, 句意为“因为Alice相信他是一个正直的人，所以她不认为他的言论存在＿可能性”。as表示因果关系，前半句对“他”的描述是“正直的人”，后半句中refused表示否定，前后应该意思一致，因此空格应该表达和integrity相对的含义。irrelevant“不相干的，不切题的”,facetious“诙谐的，爱开玩笑的”，fictitious`嘘构的，编造的”，illogical“不合逻辑的，不合常理的”。所以正确答案为C。

第6题：

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

参考答案：A, B, F

第7题：

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.0

B.1

C.3

D.6

参考答案：D

第8题：

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 row

B.It shows how many columns in the index are examined

C.It shows the number of characters indexed in the key

D.It shows how many bytes will be used from each index row

参考答案：D

第9题：

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

正确答案:B

第10题：

Ⅲ. 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、prescriptive
B、analytic
C、descriptive
D、linguistic

正确答案:C

Consider the following statement on a RANGE partitioned tabl

题目

相似问题和答案

更多相关问题

相关内容