Working With XML Data MCQ

Test your knowledge with important Working With XML Data MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Working With XML Data MCQs at Bissoy

• Which of the following function is contained by both full text search and Xquery?
  ক

  search()

  খ

  contain()

  গ

  contains()

  ঘ

  query()
• Following content of XML elements are indexed in full text?
  ক

  Content of the XML value

  খ

  Non numerical value in content of XML attributes

  গ

  The content of XML elements.

  ঘ

  None of the mentioned
• Sample applications to illustrate XML functionality in SQL Server are _____________
  ক

  Implementing XML in SQL Server

  খ

  XmlOnlineCatalog

  গ

  XmlSurvey

  ঘ

  All of the mentioned
• Different xml modes available for xml clauses are __________
  ক

  RAW

  খ

  AUTO

  গ

  PATH

  ঘ

  All of the mentioned
• Statement for dropping XML index is __________
  ক

  DROP INDEX

  খ

  DELETE INDEX

  গ

  REMOVE INDEX

  ঘ

  None of the Mentioned
• What is the purpose of the primary XML index?
  ক

  Persisted representation of data

  খ

  Shredded representation of data

  গ

  Structured representation of data

  ঘ

  None of the Mentioned
• SQL Server lets you define how many types of secondary XML indexes?
  ক

  3

  খ

  4

  গ

  5

  ঘ

  6
• Which of the following indexes can be created on XML columns?
  ক

  Primary

  খ

  Secondary

  গ

  Full-text

  ঘ

  All of the Mentioned
• Which of the following is not a xml data type method?
  ক

  query()

  খ

  value()

  গ

  nodes()

  ঘ

  none of the Mentioned
• SQL Server 2008 has made several extensions to the XML Schema support which includes?
  ক

  Support for lax validation

  খ

  Added support for list and union types

  গ

  Improved handling of xs:time

  ঘ

  All of the mentioned
• Can we use untyped XML data type in the following situations?
  ক

  You have schema for your XML data and you want the server to validate your XML data according to the XML schema

  খ

  You want to take advantage of storage and query optimizations based on type information

  গ

  You want to take better advantage of type information during compilation of your queries

  ঘ

  You do not have a schema for your XML data
• Which operation cannot be performed on XML schema collection?
  ক

  DROP

  খ

  DELETE

  গ

  CREATE

  ঘ

  UPDATE
• Which of the following statement would import additional schema or schema components into an existing collection object?
  ক

  IMPORT XML SCHEMA COLLECTION

  খ

  ALTER XML SCHEMA COLLECTION

  গ

  UPDATE XML SCHEMA COLLECTION

  ঘ

  ADD XML SCHEMA COLLECTION
• Contents of sys.xml_schema_collections are _____________
  ক

  Number of disk pages occupied

  খ

  Indexing Capabilities

  গ

  Predefined namespaces

  ঘ

  None of the Mentioned
• The space use of XML indexes can be found in the table-valued function named?
  ক

  sys.dm_db_index_physical_stats

  খ

  sys.dm_db_index_phy_stats

  গ

  sys.dm_db_index_plan_stats

  ঘ

  sys.dm_db_index_table_stats
• What is index type for XML index entries?
  ক

  3

  খ

  4

  গ

  5

  ঘ

  6
• Which of the following following is used for retrieving XML Schema Collections?
  ক

  XML_SCHEMA_SPACE

  খ

  XML_SCHEMA_NAMESPACE

  গ

  XML_SCHEMA_NAMES

  ঘ

  None of the Mentioned
• What are Catalog Views for XML?
  ক

  Schema collections

  খ

  View Collections

  গ

  Unstructured data

  ঘ

  None of the Mentioned
• XML datatype was introduced in which of the following versions of SQL Server?
  ক

  SQL Server 2000

  খ

  SQL Server 2005

  গ

  SQL Server 2008

  ঘ

  SQL Server 2012
• Which of the following part of the XML data stored in an XML column is very important for locking?
  ক

  Granularity

  খ

  Degree of Structure

  গ

  Hierarchy

  ঘ

  None of the mentioned
• Reasons to use native XML features in SQL Server instead of managing your XML data in the file system would be:
  ক

  You need language support for query and data modification for cross-domain applications

  খ

  You want the server to guarantee that the data is well formed and also optionally validate your data according to XML schema

  গ

  You want indexing of XML data for efficient query processing and good scalability, and the use of a first-rate query optimizer

  ঘ

  All of the mentioned
• XML View Technology is useful in the following situations?
  ক

  Your application needs system catalog views to administer your XML data and XML schema

  খ

  Indexing Capabilities

  গ

  You want to bulk load XML data and decompose them into the underlying tables by using the XML view

  ঘ

  None of the Mentioned
• In which of the following scenario, using XML native storage would be inappropriate?
  ক

  Fixed schema

  খ

  You want to query and modify your XML data

  গ

  You want to index the XML data for faster query processing

  ঘ

  Your application needs system catalog views to administer your XML data and XML schema
• The choice of XML technology, native XML versus XML view, generally depends upon the following factors?
  ক

  Storage options

  খ

  Query capabilities

  গ

  Indexing

  ঘ

  All of the Mentioned
• Which of the following is not a XML storage option?
  ক

  Native storage as XML data type

  খ

  Mapping between XML and relational storage

  গ

  Small object storage

  ঘ

  None of the Mentioned
• Which of the reasons will force you to use XML data model in SQL Server?
  ক

  Your data is sparse or you do not know the structure of the data

  খ

  Your data represents containment hierarchy

  গ

  Order is inherent in your data

  ঘ

  All of the Mentioned