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
19

Databases MCQ with Answers

19) The following functional dependencies are given:
AB -> CD, AF —> D, DE --> F, C —> G, F —› E, G --> A
Which one of the following options is false?

{CF}+ = {ACDEFG}

{BG}± = {ABCDG}

{AE }+ = {ACDEFG}

{AC = {ACDFG}

Answer is:

{AE }+ = {ACDEFG}

Databases MCQ with Answers

For more MCQ's Click Here

Related Databases MCQ with Answers

21) Consider the following relational schemes for a library for a library database:
Book (Title, Author, Catalog_no, Publisher, Year, Price)
Collection (Title, Author, Catalog_no)
Which ofthe following functional dependencies:
I. Title Author —› Catalog no.
II. Catalog_no ---> Title Author Publisher Year
III. Publisher Title Year --> Price.
Assume {Author, Title) is the key for both schemes: Which of the following statements is true?

Both Book and collection are in BCNF

Both Book and collection are in 3NF only

Book is in 2NF and Collection is in 3NF

Both Book and Collection are in 2NF only

Answer is:

Book is in 2NF and Collection is in 3NF

22) Manager's salary details are hidden from the employee. This is

conceptual level data hiding

physical level data hiding

external level data hiding

none of these

Answer is:

conceptual level data hiding

23) The employee salary should not be greater than Rs. 2000. This is

integrity constraint

referential constraint

over-defined constraint

feasible constraint

Answer is:

integrity constraint

24) Which of the following contains a complete record of all activity that affected the contents of a database during a certain period off time

Report writer

Query language

Data manipulation language

Transaction log

Answer is:

Transaction log

Databases MCQ with Answers

For more MCQ's Click Here