Advance Features Of Sqlserver 2005 For Aptech (Accp 20007)
This is theory test for advance sql server 2005. It is good for you and I.
- 1.This refer to parts of XML documents. These parts need not include the root element.
- A.
XML Views
- B.
XML fragments
- C.
Native XML storage
- 2.The XML data type can be used to define:- 3 choices.
- A.
Rowa
- B.
Columns
- C.
Parameters
- D.
Values
- E.
Variables
- 3.Until an xml data type variables. parameter, or column is not associated with an xml schema it is called:
- A.
Typed XML data
- B.
Untyped XML data
- 4.Which statement of code is type xml data?
- A.
CREATE TABLE student( ID varchar(20) not null, Address xml (CONTENT studentAddress) null, Class xml )
- B.
CREATE TABLE student( ID varchar(20) not null, Address xml null, Class xml not null )
- 5.The XML data type enable storage of xml data in their native form, xml
- A.
True
- B.
False
- 6.XML data type variables or columns can only store complete XML documents.
- A.
True
- B.
False
- 7.Native XML storage makes it easy to map XML data into relational databases
- A.
True
- B.
False
- 8.XML data can provide a highly optimized querying environment by indexing.
- A.
True
- B.
False
- 9.XML views work best when data in database needs to be converted to xml
- A.
True
- B.
False
- 10.XML data storage in relational databases makes data management impossible.
- A.
True
- B.
False
- 11.XML document can be validated against their schemas sincean xml schema defines an xml document's basic structure.
- A.
True
- B.
False
- 12.ALTER XML SCHEMA COLLECTION statement permits developers to modify existing schema elements and attributes.
- A.
True
- B.
False
- 13.This method is used to shred an xml document into relational data.
- A.
Query();
- B.
Value();
- C.
Nodes();
- D.
Modify();
- 14.This method is used to retrieve fragments of an xml document.
- A.
Value()
- B.
Data()
- C.
Query()
- D.
Nodes()
- 15.Insert, append or delete XML document nodes.
- A.
Modify
- B.
Nodes
- C.
Query
- 16.Recreate xml fragments as specified by query.
- A.
Modify
- B.
Exist
- C.
Query
- 17.Transpose XML values to relational database
- A.
Value
- B.
Exist
- C.
Nodes
- D.
Node
- 18.You want to create a table store long distance train travel details. The table stores the journey, passenger and reservation details in the form of untyped XML data. Which one of the following codes will help you achieve this ?
- A.
CREATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails varchar NOT NULL, PassengerDetails varchar NOT NULL, ReservationDetails varchar NOT NULL)
- B.
CREATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails XML, PassengerDetails XML (CONTENT Passenger) NOT NULL, ReservationDetails varchar NOT NULL)
- C.
CRATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails XML, PassengerDetails XML, ReservationDetails XML)
- D.
CREATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails XML (CONTENT Journey) NOT NULL, PassengerDetails XML (CONTENT Passenger) NOT NULL, ReservationDetails XML (CONTENT Reservation) NOT NULL)
- 19.Which of these codes snippets about XML data type methods are true and which of these statements are false ?
- A.
SELECT StudentID FROM Students WHERE @student.exist(‘(/Age)[.=”15”]’)=1
- B.
SELECT @student.value( ‘(/Student/Age)[1]’, ‘int(2)’)
- C.
SELECT StudentID FROM Students WHERE @student.exist(‘(/Age)[.=”15”]’)=0
- D.
SET @student.modify( ‘insert Aaroninto Student[1]’)
- E.
SELECT StudentID FROM Students WHERE @student.exist(‘(/Age’=”15”)
- 20.Software entity that implements a service specification.
- A.
Service Consumer
- B.
Service Locator
- C.
Service Broker
- D.
Services
- E.
Service Provider
- 21.Service provider that can pass on service requests to one or more additional service providers.
- A.
Service Consumer
- B.
Service Locator
- C.
Service Broker
- D.
Services
- E.
Service Provider
- 22.Service provider that acts as a registry and allows for lookup of service provider interfaces and service location
- A.
Service Consumer
- B.
Service Locator
- C.
Service Broker
- D.
Services
- E.
Service Provider
- 23.Function in which consumers communicate through contract
- A.
Service Consumer
- B.
Service Locator
- C.
Service Broker
- D.
Services
- E.
Service Provider
- 24.SOA is an architecture that encourages tightly coupled communication between software services.
- A.
True
- B.
Fasle
- 25.Service-Oriented architecture is essentially a collection of services that communicate with each other
- A.
True
- B.
False
Questions: 25 | Attempts: 3556 | Last updated: Dec 30, 2020
-
Sample QuestionAssuming UserProfile is a table containing a column Proession which accepts NULL value. What is the result of the below query. SET ANSI_NULLS OFF SELECT Profession FROM UserProfile WHERE (Profession <> NULL)
Questions: 84 | Attempts: 1756 | Last updated: Dec 13, 2012
-
Sample QuestionThe Stored Procedure - 2 true choices.
Questions: 10 | Attempts: 875 | Last updated: Jun 29, 2019
-
Sample QuestionYou are designing for a large grocery store chain. The partial database schema is shown in the Partial Database Schema Exhibit. The script that was used to create the Customers table is shown in the Script for Customers Table Exhibit. The store managers want to track customer demographics so they can target advertisements and coupon promotions to customers. These advertisements and promotions will be based on the past purchases of existing customers. The advertisements and promotions will target buying patterns by one or more of these demographics: gender, age, postal code, and region. Most of the promotions will be based on gender and age. Queries will be used to retrieve the customer demographics information. You want the query response time to be as fast as possible. What should you do?
Back to top