Question 1

Which of the following represents exactly two occurrence of digits?

McqOptions · Accepted Answer

McqOptions · Answer

dd

McqOptions · Answer

d{2}

McqOptions · Answer

[d][d]

McqOptions · Answer

All of the above

Question 2

Which of the following is used to create a choice?

McqOptions · Accepted Answer

element

Question 3

Which of the following is not a valid argument of the insert adjacent text() method?

McqOptions · Accepted Answer

McqOptions · Answer

Before Begin

McqOptions · Answer

After Begin

McqOptions · Answer

Before End

McqOptions · Answer

At End

Question 4

What is the value of the ready state property of the  element when the script is completely loaded?

McqOptions · Accepted Answer

McqOptions · Answer

loaded

McqOptions · Answer

finished

McqOptions · Answer

done

McqOptions · Answer

complete

Question 5

Code in XML is

McqOptions · Accepted Answer

Referred only to the attributes

McqOptions · Answer

Any part of the document whether it is elements, attribute or otherwise

McqOptions · Answer

Referred to top element in the document

McqOptions · Answer

None of these

Question 6

Which of the following declarations must every xml document that uses a DTD have?

McqOptions · Accepted Answer

McqOptions · Answer

A  declaration

McqOptions · Answer

A  declaration

McqOptions · Answer

A  declaration

McqOptions · Answer

A  declaration

Question 7

Which of the following HTML tags is used to refer to an external style sheet?

McqOptions · Accepted Answer

mystyle.CSS

McqOptions · Answer

McqOptions · Answer

McqOptions · Answer

Question 8

Which of the following is true regarding password field?

McqOptions · Accepted Answer

it is similar to hidden field except that text is shown as “.” (dot)

McqOptions · Answer

it is similar to text area except that text is shown as“ . ”(dot)

McqOptions · Answer

it is similar to text field except that text is shown as “.” (dot)

McqOptions · Answer

it is similar to selection list

Question 9

Which of the following refers to the root element of an XML document?

McqOptions · Accepted Answer

McqOptions · Answer

Document

McqOptions · Answer

document Element

McqOptions · Answer

Root

McqOptions · Answer

root Element

Question 10

Which of the following recommended XML?

McqOptions · Accepted Answer

Microsoft

McqOptions · Answer

W3C

McqOptions · Answer

Sun

McqOptions · Answer

IEEE

Question 11

Which of the following objects is the root object in HTML DOM object hierarchy?

McqOptions · Accepted Answer

McqOptions · Answer

Document

McqOptions · Answer

navigator

McqOptions · Answer

body

McqOptions · Answer

window

Question 12

Which of the following XML document are well formed?

McqOptions · Accepted Answer

Question 13

Which of the following would java script assign to an un initialized array element?

McqOptions · Accepted Answer

false

McqOptions · Answer

McqOptions · Answer

McqOptions · Answer

undefined

Question 14

Which of the following are not supported by X path?

McqOptions · Accepted Answer

Sequence manipulations functions

McqOptions · Answer

Character values functions

McqOptions · Answer

String values functions

McqOptions · Answer

Node manipulation functions

Question 15

Which of the following is not a method of the window object?

McqOptions · Accepted Answer

confirm()

McqOptions · Answer

Alert()

McqOptions · Answer

move()

McqOptions · Answer

close()

Question 16

Which of the following is not a property of the history object?

McqOptions · Accepted Answer

current

McqOptions · Answer

McqOptions · Answer

McqOptions · Answer

up

Question 17

HTML can be displayed

McqOptions · Accepted Answer

by computers

McqOptions · Answer

By users

McqOptions · Answer

automatically

McqOptions · Answer

none of these

Question 18

Which of the following is used to create table caption?

McqOptions · Accepted Answer

Question 19

Which of the following events occurs when a form is submitted?

McqOptions · Accepted Answer

McqOptions · Answer

go

McqOptions · Answer

submitted

McqOptions · Answer

finished

McqOptions · Answer

submit

Question 20

Which data method would you use to set a 4 – digit year?

McqOptions · Accepted Answer

fullYear()

McqOptions · Answer

setYear()

McqOptions · Answer

setFullYear()

McqOptions · Answer

set_full _year()

Question 21

Consider the following tables (relations).Primary keys in the tables are shown using underline. Now, consider the following query:SELECT S.Name, Sum (P.Marks)FROM Students S, Performance PWHERE S.Roll-No = P.Roll-NoGROUP BY S.NameThe number of rows returned by the above query is

McqOptions · Accepted Answer

3

McqOptions · Answer

0

McqOptions · Answer

1

McqOptions · Answer

2

Question 22

Consider a relation book (title, price) which contains the titles and prices of different books. Assuming that no two books have the same price, what does the following SQL query list?

McqOptions · Accepted Answer

Title of the seventh most expensive books.

McqOptions · Answer

Titles of the six most expensive books.

McqOptions · Answer

Title of the sixth most expensive books.

McqOptions · Answer

Titles of the seven most expensive books.

Question 23

For the following sample database table staff. The SQL query:SELECT COUNT(Staff no) AS mycount, SUM(Salary) AS mysum FROM Staff WHERE Designation=’Manager’Returns the result

McqOptions · Accepted Answer

mycount=5, mysal=47000

McqOptions · Answer

mycount=2, mysal=47000

McqOptions · Answer

mycount=2, mysal=98000

McqOptions · Answer

mycount=5, mysal=98000

Question 24

Match the following :Codes :      (a)   (b)  (c)  (d)

McqOptions · Accepted Answer

(iii)  (iv)  (i)   (ii)

McqOptions · Answer

(iii)  (iv)  (ii)   (i)

McqOptions · Answer

(iv)  (iii)  (ii)   (i)

McqOptions · Answer

(ii)  (iii)  (iv)   (i)

Question 25

An entity has:(i) a set of properties(ii) a set of properties and values for all the properties(iii) a set of properties and the values for some set of properties may non-uniquely identify an entity(iv) a set of properties and the values for some set of properties may uniquely identify an entityWhich of the above are valid?

McqOptions · Accepted Answer

McqOptions · Answer

(i) only

McqOptions · Answer

(ii) only

McqOptions · Answer

(iii) only

McqOptions · Answer

(iv) only

Question 26

The E-R model is expressed in terms of:(i) Entities(ii) The relationship among entities(iii) The attributes of the entities

McqOptions · Accepted Answer

(ii) and (iii)

McqOptions · Answer

(i) and (iii)

McqOptions · Answer

(i), (ii) and (iii)

McqOptions · Answer

None of the above

Question 27

An Entity - relationship diagram is a tool to represent:

McqOptions · Accepted Answer

Process model

McqOptions · Answer

Data model

McqOptions · Answer

Event model

McqOptions · Answer

Customer model

Question 28

(i) DML includes a query language based on both relation algebra and tuple calculus(ii) DML includes a query language based on tuple calculus(iii) DML includes a query language based on relational algebra(iv) DML includes a query language based on none of the relational algebra and tuple calculusWhich one is correct?

McqOptions · Accepted Answer

(ii) only

McqOptions · Answer

(i) only

McqOptions · Answer

(iii) only

McqOptions · Answer

(iv) only

Question 29

Which of the following is not a type of Database Management System?

McqOptions · Accepted Answer

McqOptions · Answer

Hierarchical

McqOptions · Answer

Network

McqOptions · Answer

Relational

McqOptions · Answer

Sequential

Question 30

A schema describes:

McqOptions · Accepted Answer

McqOptions · Answer

data elements

McqOptions · Answer

records and files

McqOptions · Answer

record relationship

McqOptions · Answer

all of the above

Question 31

Database systems that store each relation in a separate operating system file may use the operating system’s authorization scheme, instead of defining a special scheme themselves. In this case, which of the following is false?

McqOptions · Accepted Answer

It is difficult to differentiate among the update, delete and insert authorizations.

McqOptions · Answer

The administrator enjoys more control on the grant option.

McqOptions · Answer

Cannot store more than one relation in a file.

McqOptions · Answer

Operations on the database are speeded up as the authorization procedure is carried out at the operating system level.

Question 32

Which of the following is the process by which a user’s access to physical data in the application is limited, based on his privileges?

McqOptions · Accepted Answer

All of these

McqOptions · Answer

Authorization

McqOptions · Answer

Authentication

McqOptions · Answer

Access Control

Question 33

Thoma’s-write rule is .................

McqOptions · Accepted Answer

One phase locking protocol

McqOptions · Answer

Two phase locking protocol

McqOptions · Answer

Timestamp ordering protocol

McqOptions · Answer

Sliding window protocol

Question 34

The dependency preservation decomposition is a property to decompose database schema D, in which each functional dependency X->Y specified in F,

McqOptions · Accepted Answer

None of these

McqOptions · Answer

appeared directly in one of the relation schemas Ri in the decomposed D.

McqOptions · Answer

could be inferred from dependencies that appear in some Ri.

McqOptions · Answer

both a and b

Question 35

Specialization is …………… process.

McqOptions · Accepted Answer

bottom up

McqOptions · Answer

top-down

McqOptions · Answer

both a and b

McqOptions · Answer

none of these

Question 36

Linear probing suffers from a problem known as

McqOptions · Accepted Answer

Both a and b

McqOptions · Answer

Secondary clustering

McqOptions · Answer

Primary clustering

McqOptions · Answer

None of these

Question 37

Consider the relation schema R = (A,B,C,D,E,F) on which the following functional dependencies hold:A → BB, C → DE → CD → AWhat are the candidate keys of R?

McqOptions · Accepted Answer

McqOptions · Answer

AE and BE

McqOptions · Answer

AE, BE and DE

McqOptions · Answer

AEF, BEF and BCF

McqOptions · Answer

AEF, BEF and DEF

Question 38

The SQL expressionSelect distinct T, branch_name from branch T, branch S where T.assets>S.assets and S.branch_city=”Mumbai” finds the names of

McqOptions · Accepted Answer

All branches that have greater assets than all branches in Mumbai

McqOptions · Answer

All branches that have greater assets than some branch located in Mumbai

McqOptions · Answer

The branch that has greatest asset in Mumbai

McqOptions · Answer

Any branch that has greater assets than any branch in Mumbai

Question 39

Which of the following is  true ?

McqOptions · Accepted Answer

BCNF and 3NF are totally different

McqOptions · Answer

A relation in 3NF is always in BCNF

McqOptions · Answer

A relation in BCNF is always in 3NF

McqOptions · Answer

A relation in BCNF is in 2NF but not in 3NF

Question 40

SQL command to delete a column from an existing table:

McqOptions · Accepted Answer

Drop table

McqOptions · Answer

Alter table

McqOptions · Answer

Delete table

McqOptions · Answer

Delete column

Question 41

Which of the following statements is true, when structure of database file with 20 records is modified?

McqOptions · Accepted Answer

? BOF ( ) Prints F

McqOptions · Answer

? EOF ( ) Prints T

McqOptions · Answer

? BOF ( ) Prints T

McqOptions · Answer

? EOF ( ) Prints F

Question 42

With QBE, inserting records from one or more source tables into a single target table can be achieved by:

McqOptions · Accepted Answer

Update action query

McqOptions · Answer

Append action query

McqOptions · Answer

Insert action query

McqOptions · Answer

Make table action query

Question 43

B+ tree are preferred to binary tree in Database because

McqOptions · Accepted Answer

Disk data transfer rates are much less than memory data transfer rate

McqOptions · Answer

Disk capacity are greater than memory capacities

McqOptions · Answer

Disk access is much slower than memory access

McqOptions · Answer

Disks are more reliable than memory

Question 44

Consider a hash table of size seven, with starting index zero, and a hash function (7x+3) mod 4. Assuming the hash table is initially empty, which of the following is the contents of the table when the sequence 1, 3, 8, 10 is inserted into the table using closed hashing? Here “__” denotes an empty location in the table.

McqOptions · Accepted Answer

1, 3, 8, 10, __, __, __

McqOptions · Answer

3, 10, 1, 8, __, __, __

McqOptions · Answer

1, __, 3, __, 8, __, 10

McqOptions · Answer

3, 10, __, __, 8, __, __

Question 45

In a relational schema, each tuple is divided in fields called:

McqOptions · Accepted Answer

Queries

McqOptions · Answer

Relations

McqOptions · Answer

Domains

McqOptions · Answer

All the above

Question 46

For a database relation R(a, b, c, d) where the domains of a, b, c and d include only atomic values, and only the following functional dependencies and those that can be inferred from them hold:a → cb → dThe relation is in ...............

McqOptions · Accepted Answer

Second normal form but not in third normal form

McqOptions · Answer

First normal form but not in second normal form

McqOptions · Answer

Third normal form

McqOptions · Answer

BCNF

Question 47

Which of the following statement/s is/are true?(i) Facebook has the world’s largest Hadoop Cluster.(ii) Hadoop 2.0 allows live stream processing of Real time data.Choose the correct answer from the code given below:

McqOptions · Accepted Answer

Neither (i) nor (ii)

McqOptions · Answer

(i) only

McqOptions · Answer

(ii) only

McqOptions · Answer

Both (i) and (ii)

Question 48

Consider a hash table of size m = 10000 and the hash function h(k) = ∟m(kA mod 1)'┘ for A = (√5–1)/2. The location to the key k = 123456 is

McqOptions · Accepted Answer

43

McqOptions · Answer

46

McqOptions · Answer

47

McqOptions · Answer

41

Question 49

Generalization is ………… process.

McqOptions · Accepted Answer

both a & b

McqOptions · Answer

top-down

McqOptions · Answer

bottom up

McqOptions · Answer

None of these

Question 50

The normalization of 1NF relations to 2NF involves:

McqOptions · Accepted Answer

Removal of full dependencies

McqOptions · Answer

Removal of partial dependencies

McqOptions · Answer

Removal of transitive dependencies

McqOptions · Answer

Removal of multi-valued dependencies

152.	Which of the following is used to create a choice?
A.	<xsd:multi>element
B.	<xsd:choice>element
C.	<xsd:select>element
D.	<xsd:single>element
Answer» C. <xsd:select>element

151.	Which of the following represents exactly two occurrence of digits?
A.	dd
B.	d{2}
C.	[d][d]
D.	All of the above
Answer» E.

153.	Which of the following is not a valid argument of the insert adjacent text() method?
A.	Before Begin
B.	After Begin
C.	Before End
D.	At End
Answer» E.

Explore topic-wise MCQs in UGC-NET.

Which of the following represents exactly two occurrence of digits?

Which of the following is used to create a choice?

Which of the following is not a valid argument of the insert adjacent text() method?