adplus-dvertising
frame-decoration

Question

______ is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

a.

Entity Integrity Constraints

b.

Referential Integrity Constraint

c.

Domain Integrity Constraints

d.

Domain Constraints

Answer: (b).Referential Integrity Constraint

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. ______ is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

Similar Questions

Discover Related MCQs

Q. Which of the following is a physical storage media ?

Q. Which of the following creates a virtual relation for storing the query ?

Q. Which of the following is the syntax for views where v is view name ?

Q. Select course_id
from physics_fall_2009
where building= ’Watson’;

Here the tuples are selected from the view.Which one denotes the view ?

Q. Materialised views make sure that

Q. Updating the value of the view

Q. SQL view is said to be updatable (that is, inserts, updates or deletes can be applied on the view) if which of the following conditions are satisfied by the query defining the view?

Q. Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause ?

Q. A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called

Q. Relational schema and other metadata about relations are stored in a structure called the ____________ .

Q. ___________ is the collection of memory structures and Oracle background processes that operates against an Oracle database.

Q. A ________ is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.

Q. A tablespace is further broken down into ________

Q. __________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth.

Q. ________ is the smallest unit of allocation in an Oracle database.

Q. DML is provided for

Q. The language used in application programs to request data from the DBMS is referred to as the

Q. The way a particular application views the data from the database that the application uses is a

Q. The DBMS language component which can be embedded in a program is

Q. A DBMS query language is designed to