www.ThinkITI.com

Home
MCQ
Search
Free Apps
Important
Study Groups
Contact Us
Policy

Home
MCQ
Objective Questions
Engineering
Computer Science
Computer Science Set-1
Databases
70

Databases MCQ with Answers

70) In E-R Diagram derived attribute are represented by

Ellipse

Dashed ellipse

Rectangle

Triangle

Answer is:

Dashed ellipse

Databases MCQ with Answers

For more MCQ's Click Here

Related Databases MCQ with Answers

72) An instance of relational schema R (A, B, C) has distinct values of A including NULL values. Which one of the following is true

A is a candidate key

A is not a candidate key

A is a primary Key

Both (A) and (C)

Answer is:

A is not a candidate key

73) Consider the join of a relation R with relation S. If R has m tuples and S has n tuples,then the maximum size of join is:

mn

m+n

(m+n)/2

2(m+n)

Answer is:

mn

74) The natural join is equal to :

Cartesian Product

Combination of Union and Cartesian product

Combination of selection and Cartesian product

Combination of projection and Cartesian product

Answer is:

Combination of selection and Cartesian product

75) Which one of the following is not true for a view:

View is derived from other tables.

View is a virtual table.

A view definition is permanently stored as part of the database.

View never contains derived columns.

Answer is:

A view definition is permanently stored as part of the database.

Databases MCQ with Answers

For more MCQ's Click Here