This is theory test for advance sql server 2005. It is good for you and I.
XML Views
XML fragments
Native XML storage
Rowa
Columns
Parameters
Values
Variables
Typed XML data
Untyped XML data
CREATE TABLE student( ID varchar(20) not null, Address xml (CONTENT studentAddress) null, Class xml )
CREATE TABLE student( ID varchar(20) not null, Address xml null, Class xml not null )
True
False
True
False
True
False
True
False
True
False
True
False
True
False
True
False
Query();
Value();
Nodes();
Modify();
Value()
Data()
Query()
Nodes()
Modify
Nodes
Query
Modify
Exist
Query
Value
Exist
Nodes
Node
CREATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails varchar NOT NULL, PassengerDetails varchar NOT NULL, ReservationDetails varchar NOT NULL)
CREATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails XML, PassengerDetails XML (CONTENT Passenger) NOT NULL, ReservationDetails varchar NOT NULL)
CRATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails XML, PassengerDetails XML, ReservationDetails XML)
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)
SELECT StudentID FROM Students WHERE @student.exist(‘(/Age)[.=”15”]’)=1
SELECT @student.value( ‘(/Student/Age)[1]’, ‘int(2)’)
SELECT StudentID FROM Students WHERE @student.exist(‘(/Age)[.=”15”]’)=0
SET @student.modify( ‘insert Aaroninto Student[1]’)
SELECT StudentID FROM Students WHERE @student.exist(‘(/Age’=”15”)
Service Consumer
Service Locator
Service Broker
Services
Service Provider
Service Consumer
Service Locator
Service Broker
Services
Service Provider
Service Consumer
Service Locator
Service Broker
Services
Service Provider
Service Consumer
Service Locator
Service Broker
Services
Service Provider
True
Fasle
True
False
Wait!
Here's an interesting quiz for you.