Exam Aptech Portal

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)

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

1.___________________property of the OpenFileDialog class opens the selected file with read-only permissions.

Filter

Title

OpenFile

FileOk

Which of the following are the advantages of using MDI application?

1. Systematic Organization

2. Increased Efficiency

3. Less Memory Usage

4. Easy Implementation

1, 2, 3

2, 3, 4

1, 3, 4

1, 2, 3, 4

An object of the _______ class cannot be created.

MenuStrip

Menu

ContextMenuStrip

The ___________ property of the StatusStrip class specifies or retrieves a value that indicates whether the StatusStrip contains a handle in its lower right corner.

CanOverflow

SizingGrip

GripStyle

The ____________ property of the Command object retrieves the text of a command statement to be used against a data provider.

Connection

CommandText

Conmmand Type

The _______ method of the DataAdapter class adds a DataTable in a DataSet.

FillSchema()

FillLoadOption // property how the data is filles in the dataset

RefillSchema()

The _____________ method of the DataAdapter class executes a set of executable commands.

IsNull()

RunLoad()

ExecuteBatch()

The _________ method of the DataTable class copies a DataRow into a DataTable.

SetOrdinal()

ImportRow

GetFieldType()

The _____________ method of the DataTableReader class gets the data type of a particular column

FillSchema()

ExecuteBatch()

GetFieldType()

10.

The two-way data binding binds a property to a field in a _____________ manner.

read/write

Write-only

Read-only

11.

No public constructors are defined in the _________ class.

DataGridViewColumn

DataGridViewBand

DataGridViewRow

12.

The ________ class allows the user to bind a property of the specified control with the property of an object.

BindStyle

BindingSource

Bindin

13.

In the case of re-installing __________ technology based applications, only the modified parts of the application are updated to save time and effort.

ClickOne

ClickOnce

ClickOn

ClickOnly

14.

A form is a ____________ that holds and manages controls and is used to create GUI based Windows applications.

collection

frame

property

container

15.

Which of the following controls belong to the category, Value setting controls?

RadioButton

CheckBox

GridView

ImageList

Có 3 Value setting controls :CheckedListbox

16.

The ________________ control is used to display mutually exclusive options.

CheckedListBox

Checkbox

RadioButton

TreeView

17.

The methods of the ________________ class are used to check an item, retrieve the checked state of an item, and clear all the selected items.

Checkbox

RadioButton

CheckedListBox

UncheckedListBox

18.

Selection List Controls enable selection of values from specified ranges with the help of the ________________ keys.

Up-Down arrow

Page Up – Page Down

Ctrl-Shift

Left-Right arrow

19.

The ListView control is similar to the _____ icon on the standard toolbar of Windows Explorer.

File

Edit

Views

Tools

20.

The _______________ control appears as a text box along with a drop-down calendar and displays the current date in a particular format.

DateTimePicker

MonthCalendar

DropDownList

Timer

21.

The _______________ control appears as drop-down grid of rows and columnsdisplaying the dates of a particular month.

DateTimePicker

MonthCalendar

Timer

DropDownList

22.

The ____________ property of the CrystalReportViewer class specifies or retrieves theindex of the active view in the viewer control while the ___________ property specifies or retrieves the report to be bound to the control.

ActiveViewIndex

DisplayGroupTree

SelectionFormula

ReportSource

23.

Which of the following properties of the MonthCalendar class specifies or retrieves a value, which indicates the color of days in months which are partially displayed in the control?

TitleBackColor

TitleForeColor

TrailingForeColor

ShowTodayCircle

24.

Which of the following are the limitations of Interval property?

1. Less Frequency

2. Long Interval // short Interval

3. Inaccuracy

4. Inexact Precision

1, 2, 3

2, 3, 4