CIT843 NOUN E-exam Past Question & Answers

The minimum set of keys that could be used as the primary key is called __
Answer: candidate key

The cartesian product of two relations R1 and R2 is denoted by:
Answer: R1 X R2

A/An_____ operation combines the product, selection, and projection operations
Answer: join

One of these is a data definition language command
Answer: drop

A system supplied value for a column that will serve as a table\’s primary key is known as _
Answer: Surrogate key

In the E-R diagram, attributes are _
Answer: Listed inside the entity rectangle

A primary key comprising more than one attribute is known as _
Answer: composite key

_ relational algebra operation retrieves a subset of columns from a relational subset removing duplicate tuples from the result
Answer: projection

__ provide a method for maintaining referential integrity in data and for navigating between different instances of an entity
Answer: foreign keys

Show More

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Adblock Detected

Please Enable Ads to have a smooth reading and using time