CBSE-NET (UGC) Computer Science (Paper-II & Paper-III): Questions 39 - 42 of 100

Get 1 year subscription: Access detailed explanations (illustrated with images and videos) to 100 questions. Access all new questions we will add tracking exam-pattern and syllabus changes. View Sample Explanation or View Features.

Rs. 150.00 or

Question number: 39

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

Appeared in Year: 2015

Match List-Ⅰ List-Ⅱ▾

Question

Match the following database terms to their functions: (December)
List-Ⅰ List-Ⅱ

(A)

Referential Integrity

(i)

Contains metadata describing database structure.

(B)

Data Dictionary

(ii)

Enforces match of primary key to foreign key

(C)

External Schema

(iii)

Reduces data redundancy in a database

(D)

Normalization

(iv)

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

Choices

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

a.

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

b.

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

c.

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

d.

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

Question number: 40

» Computer Structure and Organisation » Harddisk Structure

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.

49 msec

b.

48 msec

c.

57 msec

d.

17 msec

Question number: 41

» Software Engineering » Software Development Models

Appeared in Year: 2015

MCQ▾

Question

Which of the following is not a software process model? (December)

Choices

Choice (4) Response

a.

Iterative

b.

Timeboxing

c.

Glassboxing

d.

Prototyping

Question number: 42

» Discrete Mathematics » Prepositional Logic

Appeared in Year: 2015

MCQ▾

Question

Consider the compound propositions given below as:

(1)p˅~(p˄q)

(2)(p˄~q)˅~(p˄q)

(3)p˄(q˅r)

Which of the above propositions are tautologies? (December)

Choices

Choice (4) Response

a.

(1), (2) and (3)

b.

(2) and (3)

c.

(1) and (2)

d.

(1) and (3)

Sign In