github

Made bySaurav Hathi

CSE - Practice Test -23

Q1:

Data integrity constraints are used to ________________.

Tags:
Section:
Databases
Options:
Q2:

Which of the following is NOT a superkey in a relational schema with attributes V, W, X, Y, Z and primary key V Y?

Tags:
Section:
Databases
Options:
Q3:

A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.

Tags:
Section:
Databases
Options:
Q4:

Relational database schema normalization is NOT for:

Tags:
Section:
Databases
Options:
Q5:

Fora given basic ER and relational models, which of the following is INCORRECT?

Tags:
Section:
Databases
Options:
Q6:

A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.

Tags:
Section:
Databases
Options:
Q7:

An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.

Tags:
Section:
Databases
Options:
Q8:

Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

Tags:
Section:
Databases
Options:
Q9:

A relational database consists of a collection of

Tags:
Section:
Databases
Options:
Q10:

In a relation between the entities, the type and condition of the relation should be specified. That is called as______attribute.

Tags:
Section:
Databases
Options:
Q11:

Which of the following can be a multivalued attribute ?

Tags:
Section:
Databases
Options:
Q12:

The function that an entity plays in a relationship is called that entity’s _____________

Tags:
Section:
Databases
Options:
Q13:

An ________ is a set of entities of the same type that share the same properties, or attributes.

Tags:
Section:
Databases
Options:
Q14:

A logical schema_________.

Tags:
Section:
Databases
Options:
Q15:

Data independence means_______________.

Tags:
Section:
Databases
Options: