单选题Which of the following is NOT true about XML columns?()A Data can be retrieved by SQL.B Data can be retrieved by XQuery.C XML columns must be altered to accommodate additional parent and child relationships.D Access to any portion of an XML document ca

题目
单选题
Which of the following is NOT true about XML columns?()
A

Data can be retrieved by SQL.

B

Data can be retrieved by XQuery.

C

XML columns must be altered to accommodate additional parent and child relationships.

D

Access to any portion of an XML document can be direct, without reading the whole document.

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

第1题:

Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?()

A.CLOB

B.BLOB

C.Hierarchically

D.Rows and columns


参考答案:C

第2题:

Which of the following is NOT true about XML columns?()

  • A、Data can be retrieved by SQL.
  • B、Data can be retrieved by XQuery.
  • C、XML columns must be altered to accommodate additional parent and child relationships.
  • D、Access to any portion of an XML document can be direct, without reading the whole document.

正确答案:C

第3题:

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


参考答案:B, D

第4题:

Which of the following supports the XML data type?()

  • A、A unique index
  • B、A composite index
  • C、A check constraint
  • D、A generated column

正确答案:A

第5题:

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

正确答案:B,D

第6题:

Which two statements are true regarding the USING clause in table joins?()

  • A、It can be used to join a maximum of three tables 
  • B、It can be used to restrict the number of columns used in a NATURAL join 
  • C、It can be used to access data from tables through equijoins as well as nonequijoins 
  • D、It can be used to join tables that have columns with the same name and compatible data types

正确答案:B,D

第7题:

Which three statements are true regarding subqueries?()

  • A、Subqueries can contain GROUP BY and ORDER BY clauses 
  • B、Main query and subquery can get data from different tables 
  • C、Main query and subquery must get data from the same tables 
  • D、Subqueries can contain ORDER BY but not the GROUP BY clause 
  • E、Only one column or expression can be compared between the main query and subquery
  • F、 Multiple columns or expressions can be compared between the main query and subquery

正确答案:A,B,E

第8题:

Which of the following is NOT true about XML columns?()

A.Data can be retrieved by SQL.

B.Data can be retrieved by XQuery.

C.XML columns must be altered to accommodate additional parent and child relationships.

D.Access to any portion of an XML document can be direct, without reading the whole document.


参考答案:C

第9题:

Which of the following are TRUE about a store archive?()

  • A、It is an XML file containing store data assets
  • B、It uses the same file format as a ZIP file
  • C、It contains file assets to create a store or site
  • D、It can easily be copied from one machine to another
  • E、It can contain WebSphere Commerce instance configuration information

正确答案:B,C,D

第10题:

Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?()

  • A、CLOB
  • B、BLOB
  • C、Hierarchically
  • D、Rows and columns

正确答案:C

更多相关问题