Relational Database Design Set 2

Learning Mode Previous Next

On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Relational Database Design Set 2

Q1 | The relation employee(ID,name,street,Credit,street,city,salary) is decomposed intoemployee1 (ID, name)employee2 (name, street, city, salary) This type of decomposition is called

Lossless decomposition

Lossless-join decomposition

All of the mentioned

None of the mentioned

Q2 | Inst_dept (ID, name, salary, dept name, building, budget) is decomposed intoinstructor (ID, name, dept name, salary) department (dept name, building, budget) This comes under

Lossy-join decomposition

Lossy decomposition

Lossless-join decomposition

Both Lossy and Lossy-join decomposition

Q3 | There are two functional dependencies with the same set of attributes on the left side of the arrow:A->BC A->BThis can be combined as

A->BC

A->B

B->C

None of the mentioned

Q4 | Consider a relation R(A,B,C,D,E) with the following functional dependencies:ABC -> DE andD -> AB The number of superkeys of R is:

Q5 | Which, if any, of the two queries above will correctly (in SQL2) get the desired set ofemployee ID’s?

Both I and II

I only

II only

Neither I nor I

Q6 | Suppose now that R(A,B:) and S(A,B:) are two relations with r and s tuples, respectively(again, not necessarily distinct). If m is the number of (not necessarily distinct) tuples in theresult of the SQL query: R intersect S; Then which of the following is the most restrictive, correct condition on the value of m?

m = min(r,s)

0 <= m <= r + s

min(r,s) <= m <= max(r,s)

0 <= m <= min(r,s)

Q7 | Which of the following is not a key?

B, C

Q8 | If a relation is in BCNF, then it is also in

1 NF

2 NF

3 NF

All of the above

Q9 | What action does ⋈ operator perform in relational algebra

Output specified attributes from all rows of the input relation and remove duplicate tuples from the output

Outputs pairs of rows from the two input relations that have the same value on all attributes that have the same name

Output all pairs of rows from the two input relations (regardless of whether or not they have the same values on common attributes)

Return rows of the input relation that satisfy the predicate

Q10 | Statement 1: A tuple is a row in a relation Statement 2: Existence of multiple foreign keys in a same relation is possible

Both the statements are true

Statement 1 is correct but Statement 2 is false

Statement 1 is false but Statement 2 is correct

Both the statements are false

Q11 | The____condition allows a general predicate over the relations being joined.

Using

Set

Where

Q12 | Which of the join operations do not preserve non matched tuples?

Left outer join

Right outer join

Inner join

Natural join

Q13 | The normal form which satisfies multivalued dependencies and which is in BCNF is

4 NF

3 NF

2 NF

All of the mentioned

Q14 | Which of the following is a tuple-generating dependencies?

Functional dependency

Equality-generating dependencies

Multivalued dependencies

Non-functional dependency

Q15 | The main task carried out in the __________ is to remove repeating attributes toseparate tables.

First Normal Form

Second Normal Form

Third Normal Form

Fourth Normal Form

Q16 | Which forms has a relation that possesses data about an individual entity?

2NF

3NF

4NF

5NF

Q17 | Which of the following has each related entity set has its own schema and there is anadditional schema for the relationship set?

A many-to-many relationship set

A multivalued attribute of an entity set

A one-to-many relationship set

None of the mentioned

Q18 | Fifth Normal form is concerned with

Functional dependency

Multivalued dependency

Join dependency

Domain-key

Q19 | n which of the following, a separate schema is created consisting of that attribute andthe primary key of the entity set.

A many-to-many relationship set

A multivalued attribute of an entity set

A one-to-many relationship set

None of the mentioned

Q20 | In 2NF

No functional dependencies (FDs) exist

No multivalued dependencies (MVDs) exist

No partial FDs exist

No partial MVDs exist

Q21 | Which of the following is related to information?

Data

Communication

Knowledge

All of these

Q22 | Data is:

A piece of fact

Metadata

Information

None of these.

Q23 | Which of the following is element of the database?

Data

Constraints and schema

Relationships

All of these.

Q24 | What represent a correspondence between the various data elements?

Data

Constraints

Relationships

Schema

Q25 | Which of the following is an advantage of using database system?

Security enforcement

Avoidance of redundancy

Reduced inconsistency

All of these.

Previous Next