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
80

Databases MCQ with Answers

80) The method of access which uses key transformation is known as

Direct

Hash

Random

Sequential

Answer is:

Hash

Databases MCQ with Answers

For more MCQ's Click Here

Related Databases MCQ with Answers

82) Consider a relational table with a single record for each registered student with the following attributes.
1. Registration Num: Unique registration of each registered student.
2. UID Unique identity number, unique at the national level for each citizen.
3. Name: Name of the student.
4. BankAccount Num: Unique account number at the bank. A student can have multiple account or joint accounts.This attribute stores the primary account number.
5. Hostel_Room: Room number of th

BankAccount Num is a candidate key.

Registration Num can be a primary key

UID is candidate key if all students are from same country.

If S is a super key such that S ∩ UID is NULL then S ∪ UID is also a super key.

Answer is:

BankAccount Num is a candidate key.

83) The following functional dependencies hold for relation R(A, B, C) and S(B, D, E) B —> A, A —> C , the relation R contains 200 tuples and relation S contains 100 tuples. What is maximum number of tuples possibles in natural join R and S ?

100

200

300

400

Answer is:

100

84) Which structure is the hierarchical model based

Tree

Graph

Linked List

None of the above

Answer is:

Tree

85) In the relational model, the number of attributes and number of tuples in a relation are termed as and ____respectively

Cardinality, domain

Degree, cardinality

Domain degree

Cardinality, degree

Answer is:

Degree, cardinality

Databases MCQ with Answers

For more MCQ's Click Here