Q. When the foreign key refers to a tuple which does not exists in subjected relation then the constraint violated is

View solution

Q. The basic operations that can be performed on relations are

View solution

Q. In relational database schemas, the state constraints are also known as

View solution

Q. The tuples in relation are sensitive to

View solution

Q. The state in which the database does not follow integrity constraints is classified as

View solution

Q. The type of constraint which states that not even a single value with primary key can be a null value is classified as

View solution

Q. The values which cannot be divided further are classified as

View solution

Q. On a relational database, the kind of constraint which must be specified and does not contain large classes of constraints is considered as

View solution

Q. The definition of relation in which values and attributes are ordered in tuple is classified as

View solution

Q. The constraint violated when key value in tuple already exists in some other relation's tuple is called

View solution

Q. The normal form which consider all the types of constraints and dependencies is classified as

View solution

Q. The tuples that are represented in one of two relations and are lost if the JOIN operation is performed are called

View solution

Q. The inclusion dependencies that are preceding are used to represent

View solution

Q. The template conclusion is a set of tuples that must be included in the relations in the template dependency called

View solution

Q. The other name of project-join normal form is

View solution

Q. The types of template dependencies are

View solution

Q. The decomposition of one relation say R into two relations is classified as

View solution

Q. The type of algorithm in which decomposition of relation schema is constructed from other specific set of functional dependencies is classified as

View solution

Q. The conclusion of the template is a condition which must be held on tuples hypothesis in the template dependency called

View solution

Q. The constraints that are applied on individual tuples and are verified whenever any tuple is modified or new tuple is inserted are called

View solution