MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 9 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
WITH_XML_DML,WHICH_OF_THE_OPERATIONS_CAN_BE_PERFORMED_ON_NODES_??$ |
| A. | Insert nodes |
| B. | Change nodes |
| C. | Delete nodes |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 2. |
Why do we use exist method in Xquery ?$ |
| A. | To determine if the XML data contains a certain node |
| B. | To examine the XML and return back a scalar value |
| C. | To Shred the XML nodes of the XML data into relational columns |
| D. | To search inside xml data types |
| Answer» B. To examine the XML and return back a scalar value | |
| 3. |
Atomization is process of extracting ________ value of an item? |
| A. | XML value |
| B. | Non numerical value |
| C. | Typed |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 4. |
Functions on numerical values in Xquery are : |
| A. | ceiling |
| B. | concat |
| C. | contains |
| D. | number |
| Answer» B. concat | |
| 5. |
Different types of errors raised during Xquery operation are : |
| A. | Static |
| B. | Dynamic |
| C. | Type |
| D. | All of the mentioned |
| Answer» E. | |
| 6. |
Every database you create has which collection by default ? |
| A. | sys |
| B. | sym |
| C. | syx |
| D. | None of the Mentioned |
| Answer» B. sym | |
| 7. |
What is every identifier in an XQuery called ? |
| A. | Name |
| B. | QName |
| C. | Qidt |
| D. | Qnam |
| Answer» C. Qidt | |
| 8. |
SQL Server provides how many Xquery methods ? |
| A. | 3 |
| B. | 4 |
| C. | 5 |
| D. | 6 |
| Answer» D. 6 | |
| 9. |
Which of the following function returns an instance of the XML data type ? |
| A. | query() |
| B. | value() |
| C. | nodes() |
| D. | None of the Mentioned |
| Answer» B. value() | |