1.In an ERD (Crow's foot notation), only the maximum cardinality is specified for both directions of a relationship. T/F

2. Which of the following statements are true?

A: Each entity type becomes a table.

B: Each 1-M relationship becomes a foreign Key in the table corresponding to the child entity type.

C: Each M-N becomes a table with a combined primary key.

D:All the above.

3. What type of join returns only matched records from the tables that are being joined?

A: Inner join

B: Full Outer join

C: Left outer join

D: Theta Join

4. What is full form of SQL

A: Structured Query Language

B: Sequential Query Language

C: Serial Query Language

D: None of the above

5. A table can have only one

A: Seconder Key

B: Unique Key

C: Primary Key

D: Alternate Key

7. Which one of the below options is not a data anomaly?

A: Update Anomaly

B: Edit Anomaly

C: Insertion Anomaly

D: Deletion Anomaly

8. Is a weak entity always existence dependent?

T/F

9. if one of the columns is removed from the__ then it is not a unique combination that can define each row and trace each row

A: Primary Key

B: Candidate Key

C: Foreign Key

D: Constant Key

10. Which relational set operator is an unary operator that yields a vertical subset of a table?

A: Restrict

B: Project

C: Union

D: intersect

11. What is a management position that performs planning and policy setting for the data resources of an organization?

A: Database Admin

B: Data Analyst

C: Data Administrator

D: Dara Scientist

12. Primary key can contain null values.

T/F

13. a minimum cardinality of one indicates a mandatory relationship.

T/F

14. ______ is a top-down approach in which one higher level entity can be broken down into two lower level entity.

A: Generalization

B: Specialization

C: Categorization

D: Aggregation

16. Which is the subset of SQL commands used to define schema structure/components?

A: Data Definition Language (DDL)

B: Data Manipulation Language (DML)

C: DDL and DML

D: None of the Mentioned

17. a constraint on the number of entity instances that participate in a relationship is known as

A: Relationship

B: Entity integrity

C: Attribute

D: Cardinality

18. Self-referencing relationship place which key to reference the primary key of the same table?

A: Primary Key

B: Candidate Key

C: Foreign Key

D: Constant Key

19. Which is combining all rows from 2 tables excluding duplicates called?

A: Union

B: Restrict

C: Project

D: intersect