Reliance Jio DBMS Quiz-1

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

Consider attributes ID , CITY and NAME . Which one of this can be considered as a super key ?

The subset of super key is a candidate key under what condition ?

A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.

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

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.

An ________ on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.

The user defined data type can be created using

 Values of one type can be converted to another domain using which of the following ?

Which of the following closely resembles Create view ?

In contemporary databases the top level of the hierarchy consists of ______, each of which can contain _____.

Which of the following statements creates a new table temp instructor that has the same schema as instructor.

The____condition allows a general predicate over the relations being joined

Which of the join operations do not preserve non matched tuples.

Which are the join types in join condition:

Which join refers to join records from the right table that have no matching key in the left table are include in the result set:

How non clustered index point to the data?

What are composite indexes ?