vu cs403 Mid Term - Quiz No.1

vu cs403 Database Management Systems Quiz

This quiz belongs to book/course code vu cs403 Database Management Systems of vu organization. We have 18 quizzes available related to the book/course Database Management Systems. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Mid Term. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.

NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.

Question 1: Â statement among the following on the above diagram.

The relationship type Y is of cardinality ratio 1 : N.

The participation of Z in the Y relationship type is partial.

The diagram depicts existence dependencies.

The participation of X in the Y relationship type is total.

Question 2: Consider the following statements.
A. An entity integrity constraint states that no primary key value can be null.
B. A referential integrity constraint is specified between two relations.
C. A foreign key cannot be used to refer to its own relation.
Identify which of the above statements is/are correct.

Only A

Only B

B and C

A and B

Question 3: Consider the following statements.
A. An entity integrity constraint states that no primary key value can be null.
B. A referential integrity constraint is specified between two relations.
C. A foreign key cannot be used to refer to its own relation.
Identify which of the above statements is/are correct.

Only B

Only A

A and B

B and C

Question 4: Which of the following is true for the relational model?

Degree of a relation is the number of rows in a relation.

Null value is a blank or zero value given to an attribute value when its value is inapplicable or its value is unknown.

Complex key is a key consisting of more than one attribute.

Constraint is a rule that restricts the values in a database.

Question 5: Which of the following is true about relational schema?

The sequence of columns is significant.

The sequence of rows is significant.

Contains only derived attributes.

Values are atomic.

Question 6: In a conceptual model for a university, what type of relationship exists between Grade and Student entities?

0.0423611111111111

M:M

1:M

Ternary

Question 7: Given are the relations of student and Instructor
Which relational algebra operation could have been applied on the pair of relations Student and Instructor to obtain the above data?

Student ∩ Instructor

Instructor ÷ Student

Instructor – Student

Student – Instructor

Question 8: Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of

Physical data independence.

Concurrency control.

Logical data independence.

Functional dependency.

Question 9: Select the correct statement among the following.

Role names are not technically necessary in relationship types when all the participating entity types are distinct.

When different entity types participate only once in a single relationship type it is called a recursive relationship.

Cardinality ratios for binary relationship are displayed on Entity Relationship Diagrams by using a diamond shape notation.

Partial participation which is also called existence dependency is displayed as a double line connecting the participating entity type to the relationship.

Question 10: Which of the following is not a benefit of normalization?

Minimize insertion anomalies

Minimize deletion anomalies

Minimize updation anomalies

Maximize redundancy