The operation that displays all the tuples that exist in both the relations and discards the rest of the tuples
SELECT
PROJECT
UNION
INTERSECTION
A _____ is a collection of multiple related fields that can be treated as a unit.
Record
field
domain
None of these
All attribute combinations inside a relation that can serve as primary key are known as
Candidate Key
Alternate Key
Foreign Key
A candidate key that is not the primary key is called
The number of tuples in a relation is called the _____ of a relation.
Degree
Cardinality
The operation that is used to extract specific tuples from a given relation that satisfy a given condition for a relation
The advantages of DBMS are
Data redundancy
Data Security
Data integrity
All of the above
In relational data model , collection of logically records are known as
Relation
Table
Both (1) & (2)
The operation that displays all the tuples of both the relations as the output with the duplicate tuples eliminated.
The columns of a relation are referred to
tuples
attributes
