NTA-NET (Based on NTA-UGC) Computer Science (Paper-II): Questions 38 - 40 of 2104

Access detailed explanations (illustrated with images and videos) to 2104 questions. Access all new questions we will add tracking exam-pattern and syllabus changes. Unlimited Access for Unlimited Time!

View Sample Explanation or View Features.

Rs. 550.00 or

How to register?

Question number: 38

» Relational Database Design and SQL » E-R Diagrams and Transformation to Relational Design

Edit

Appeared in Year: 2015

MCQ▾

Question

Which of the following provides the best description of an entity type? (December)

Choices

Choice (4)Response

a.

A value given to a particular attribute (e. g. height-230 cm)

b.

A thing that we wish to collect data about zero or more, possibly real world examples of it may exist.

c.

A specific concrete object with a defined set of processes (e. g. Jatin with diabetes)

d.

A template for a group of things with the same set of characteristics that may exist in the real world

Question number: 39

» Relational Database Design and SQL » Normalization-INF, 2NF, 3NF, BCNF and 4NF

Edit

Appeared in Year: 2015

Match List-Ⅰ List-Ⅱ▾

Question

Match the following database terms to their functions: (December)

List-ⅠList-Ⅱ

(A)

External Schema

(i)

Define view (s) of the database for particular user (s)

(B)

Referential Integrity

(ii)

Enforces match of primary key to foreign key

(C)

Normalization

(iii)

Reduces data redundancy in a database

(D)

Data Dictionary

(iv)

Contains metadata describing database structure.

Choices

Choice (4)Response
  • (A)
  • (B)
  • (C)
  • (D)

a.

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

b.

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

c.

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

d.

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

Question number: 40

» Computer Structure and Organisation » Harddisk Structure

Edit

Appeared in Year: 2015

MCQ▾

Question

Consider a disk with 16384 bytes per track having a rotation time of 16 msec and average seek time of 40 msec. What is the time in msec to read a block of 1024 bytes from this disk? (December)

Choices

Choice (4)Response

a.

48 msec

b.

57 msec

c.

17 msec

d.

49 msec

Developed by: