Test: Relational Model - Computer Science Engineering (CSE) MCQ

Selects all tuples from the Cartesian product of book and borrow

Selects all the tuples from the natural join of book and student wherever the year is greater than or equal to 2009

Selects all the tuples from the natural join of book and borrow wherever the year is lesser than 2009 

Selects all tuples from the Cartesian product of book and borrow wherever the year is greater than or equal to 2009

By writing it in bold letters

By underlining it using a dashed line

By writing it in capital letters

By underlining it using a bold line

Output specified attributes from all rows of the input relation. Remove duplicate tuples from the output

Output 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)

Returns the rows of the input relation that satisfy the predicate

A foreign key is a primary key of a relation which is an attribute in another relation

A foreign key is a superkey of a relation which is an attribute in more than one other relations

A foreign key is an attribute of a relation that is a primary key of another relation

A foreign key is the primary key of a relation that does not occur anywhere else in the schema

A superkey is an attribute or a group of multiple attributes that can uniquely identify a tuple

A superkey is a tuple or a set of multiple tuples that can uniquely identify an attribute

Every superkey is a candidate key

A superkey is an attribute or a set of attributes that distinguish the relation from other relations

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

Row

Column

Value

Tuple

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

The logical design of the database system

The entire set of attributes of the Database put together in a single relation

The state of the database system at any given point of time

The initial values inserted into the Database immediately after its creation

True

False