ASFF Exam Aptech

Q.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

Q.2)	The XML data type can be used to define: – 3 choices.
	A.	rowa
	B.	columns ()
	C.	parameters ()
	D.	values
	E.	variables ()

Q.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 ()

Q.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)

g

Q.5)	The XML data type enable storage of xml data in their native form, xml
	A.	True ()
	B.	False

Q.6)	XML data type variables or columns can only store complete XML documents.
	A.	True
	B.	False ()

Q.7)	Native XML storage makes it easy to map XML data into relational databases
	A.	True ()
	B.	False (correct answer)

Q.8)	XML data can provide a highly optimized querying environment by indexing.
	A.	True ()
	B.	False

Q.9)	XML views work best when data in database needs to be converted to xml
	A.	True (correct answer)
	B.	False ()

Q.10)	XML data storage in relational databases makes data management impossible.
	A.	True
	B.	False ()

Q.11)	XML document can be validated against their schemas sincean xml schema defines an xml document’s basic structure.
	A.	True ()
	B.	False

Q.12)	ALTER XML SCHEMA COLLECTION statement permits developers to modify existing schema elements and attributes.
	A.	True
	B.	False

Q.13)	This method is used to shred an xml document into relational data.
	A.	query();
	B.	value();
	C.	nodes();
	D.	modify();

Q.14)	This method is used to retrieve fragments of an xml document.
	A.	value()
	B.	data()
	C.	query()
	D.	nodes()

Q.15)	Insert, append or delete XML document nodes.
	A.	modify ()
	B.	nodes
	C.	query

Q.16)	Recreate xml fragments as specified by query.
	A.	modify ()
	B.	exist
	C.	query

Q.17)	Transpose XML values to relational database
	A.	value
	B.	exist
	C.	nodes ()
	D.	node

Q.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) (correct answer)
	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)

Q.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 (missed)
	B.	SELECT @student.value( ‘(/Student/Age)[1]’, ‘int(2)’) (missed)
	C.	SELECT StudentID FROM Students WHERE @student.exist(‘(/Age)[.=”15”]’)=0 ()
	D.	SET @student.modify( ‘insert Aaroninto Student[1]’) (missed)
	E.	SELECT StudentID FROM Students WHERE @student.exist(‘(/Age’=”15”)

Q.20)	Software entity that calls a service provider
	A.	Service Consumer ()
	B.	Service Locator
	C.	Service Broker
	D.	Services
	E.	Service Provider

Download full 40 question : here