单选题什么是SQL/XML?()ASQL/XML是DB2数据库的通信协议BSQL/XML是XQuery标准的一部分,提供各种发布函数以将XML数据转换成为关系表单,反之亦然CSQL/XML是pureXML技术的另一种叫法DSQL/XML是对SQL标准的扩展,提供各种发布函数以将XML数据转换成为关系表单,反之亦然
单选题
什么是SQL/XML?()
A
SQL/XML是DB2数据库的通信协议
B
SQL/XML是XQuery标准的一部分,提供各种发布函数以将XML数据转换成为关系表单,反之亦然
C
SQL/XML是pureXML技术的另一种叫法
D
SQL/XML是对SQL标准的扩展,提供各种发布函数以将XML数据转换成为关系表单,反之亦然
参考解析
解析:
暂无解析
相关考题:
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.
什么是SQL/XML?()A、SQL/XML是DB2数据库的通信协议B、SQL/XML是XQuery标准的一部分,提供各种发布函数以将XML数据转换成为关系表单,反之亦然C、SQL/XML是pureXML技术的另一种叫法D、SQL/XML是对SQL标准的扩展,提供各种发布函数以将XML数据转换成为关系表单,反之亦然
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.
XML是英文eXtended Markup Language的缩写,称之为()。研究纯XML数据库,称作()(Native XML DBMS。依托于关系数据库来实现XML数据库的功能,称作()(XML-Enabled DBMS)。类似SQL Server这样的数据库管理系统目前均支持()及其相关的操作。更重要的是在SQL的新标准中(SQL2003)也增加了有关XML的描述,也就是说支持()已经成为关系数据库的标准。
单选题Which of the following is NOT true about XML columns?()AData can be retrieved by SQL.BData can be retrieved by XQuery.CXML columns must be altered to accommodate additional parent and child relationships.DAccess to any portion of an XML document can be direct, without reading the whole document.
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named named Dworks in the instance. The Dworks table has a table named BillDetails which has a clustered primary key named BillId on the BillId column. The BillDetails table has a single XML column named GoodsDetails. The XML column has an XML index and XML data are stored in this XML column. A new column named GoodsID is added to the BillDetails table. GoodsID must be included in the primary key. So what action should you perform to achieve this goal?()AYou should drop the XML index on the table. Modify the primary key. Recreate the XML index BYou should alter the XML index and set the ALLOW_ROW_LOCKS = OFF option. Alter the primary key and set the ALLOW_ROW_LOCKS = ON option. CYou should move the XML data to a temporary table. Clear the XML data from the original table by setting the GoodsDetails column to NULL. Modify the primary key. Repopulate the ProductSpecs column. DYou should disable the XML index on the GoodsDetails column. Modify the primary key.Enable the XML index on the ProductSpecs column.
填空题XML是英文eXtended Markup Language的缩写,称之为()。研究纯XML数据库,称作()(Native XML DBMS。依托于关系数据库来实现XML数据库的功能,称作()(XML-Enabled DBMS)。类似SQL Server这样的数据库管理系统目前均支持()及其相关的操作。更重要的是在SQL的新标准中(SQL2003)也增加了有关XML的描述,也就是说支持()已经成为关系数据库的标准。
单选题You are creating an online catalog application that will display product information on the company Web site. The product data is stored in a SQL Server 2005 database. The data is stored as relational data but must be passed to the application as an XML document by using FOR XML. You test your application and notice that not all of the items matching your query appear in the XML document. Only those products that have values for all elements in the schema appear. You need to modify your Transact-SQL statement so that all products matching your query appear in the XML document. What should you do?()AAdd an XML index to the table that contains the product data.BAdd the XSINIL argument to the ELEMENTS directive in the query.CAdd a HAVING clause to the query.DAdd the replace value of clause to the query.
单选题You create a Web application to process XML documents. The Web application receives XML document files from several sources, reads them, and stores them in a Microsoft SQL Server database. The Web application parses all incoming data files to ensure that they conform to an XML schema. You need to find all validation errors in the XML document. What should you do? ()ALoad the XML data by using an instance of the XmlDocument class and specify a location for the application schema.BConfigure the ValidationEventHandler in the XmlReaderSettings of the XmlReader object.CRead the XML file into a DataSet object and set the EnforceConstraints property to True.DRead the XML file into a DataSet object. Handle the DataSet.MergeFailed event to parse the data that does not conform to the XML schema.
问答题什么是XML?