Database Concepts Quiz

A relational database consists of a collection of.

• Tables

• Fields

• Records

• Keys

The term attribute refers to a ___________ of a table.

• Record

• Column

• Tuple

• Key

The tuples of the relations can be of ________ order.

• Any

• Same

• Sorted

• Constant

An attribute that is not part of any candidate key is known as.

• Sub-prime attribute

• Non-prime attribute

• Sub-candidate key

• Non-candidate key

The degree of the relationship is.

• Number of Tables in a relationship

• Number of entities in a relationship

• Number of Row & Columns in a relationship

• Number of participating entities in a relationship

In an Entity-Relationship diagram “Double Rectangles” represents.

• Relationship Set

• Weak Entity Sets

• Derived Attributes

• Multi-valued Attributes

The minimal set of super key is called.

• Primary key

• Secondary key

• Candidate key

• Foreign key

A transaction completes its execution is said to be.

• Saved

• Loaded

• Rolled

• Committed

Which of the following option is use to retrieval of data.

• Stack

• Data Structure

• Linked list

• Query

Which of the following is an unary operation.

• Selection operation

• Generalized selection

• Primitive operation

• Projection operation