MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 10 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. |
XML_DATATYPE_WAS_INTRODUCED_IN_WHICH_OF_THE_FOLLOWING_VERSIONS_OF_SQL_SERVER_??$ |
| A. | SQL Server 2000 |
| B. | SQL Server 2005 |
| C. | SQL Server 2008 |
| D. | SQL Server 2012 |
| Answer» C. SQL Server 2008 | |
| 2. |
Which_of_the_following_feature_of_SQL_Server_was_used_before_XML_technology_for_semi_structured_data?$ |
| A. | Stored Procedure |
| B. | Dynamic management views |
| C. | In memory database |
| D. | None of the mentioned |
| Answer» B. Dynamic management views | |
| 3. |
Which of the following part of the XML data stored in an XML column is very important for locking ? |
| A. | Granularity |
| B. | Degree of Structure |
| C. | Hierarchy |
| D. | None of the mentioned |
| Answer» B. Degree of Structure | |
| 4. |
Reasons to use native XML features in SQL Server instead of managing your XML data in the file system would be: |
| A. | You need language support for query and data modification for cross-domain applications |
| B. | You want the server to guarantee that the data is well formed and also optionally validate your data according to XML schema |
| C. | You want indexing of XML data for efficient query processing and good scalability, and the use of a first-rate query optimizer |
| D. | All of the mentioned |
| Answer» E. | |
| 5. |
What is hybrid model in SQL Server ? |
| A. | Combination of relational and XML data type columns |
| B. | Combination of relational and non relational data type columns |
| C. | Using XML with views |
| D. | Using XML with triggers |
| Answer» B. Combination of relational and non relational data type columns | |
| 6. |
XML View Technology is useful in the following situations: |
| A. | Your application needs system catalog views to administer your XML data and XML schema |
| B. | Indexing Capabilities |
| C. | You want to bulk load XML data and decompose them into the underlying tables by using the XML view |
| D. | None of the Mentioned |
| Answer» D. None of the Mentioned | |
| 7. |
In which of the following scenario,using XML native storage would be inappropriate ? |
| A. | Fixed schema |
| B. | You want to query and modify your XML data |
| C. | You want to index the XML data for faster query processing |
| D. | Your application needs system catalog views to administer your XML data and XML schema |
| Answer» B. You want to query and modify your XML data | |
| 8. |
The choice of XML technology, native XML versus XML view, generally depends upon the following factors: |
| A. | Storage options |
| B. | Query capabilities |
| C. | Indexing |
| D. | All of the Mentioned |
| Answer» E. | |
| 9. |
Which of the following is not a XML storage option ? |
| A. | Native storage as XML data type |
| B. | Mapping between XML and relational storage |
| C. | Small object storage |
| D. | None of the Mentioned |
| Answer» D. None of the Mentioned | |
| 10. |
Which of the reasons will force you to use XML data model in SQL Server ? |
| A. | Your data is sparse or you do not know the structure of the data |
| B. | Your data represents containment hierarchy |
| C. | Order is inherent in your data |
| D. | All of the Mentioned |
| Answer» E. | |