Relational Database Design Set 2
Computer Science Engineering (CSE),
Bachelor of Science in Computer Science FY (BSc CS),
Bachelor of Science in Computer Science SY (BSc CS),
Bachelor of Science in Information Technology SY (BSc IT),
Bachelor of Computer Applications (BCA),
Bachelor of Business Administration in Computer Applications (BBA [CA]),
Bachelor of Science in Information Technology (BSc IT),
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:
- 2
- 7
- 10
- 12
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?
- A
- E
- B, C
- D
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.
- On
- 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.