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

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

Rs. 200.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.

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

b.

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

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)

f Page
Sign In