Relational Database Quiz

The primary key indexing techniques do not allow

• Duplicate data

• Multiple attributes

• Sets of relations

• Many to many relation

The column of a table is referred to as

• Tuple

• Attribute

• Entity

• Degree

Relations produced from an E-R model will always be in

• 1NF

• 2NF

• 3NF

• 4NF

What is the cardinality of a table with 1000 rows & 10 columns?

• 10

• 100

• 1000

• None of these

The operation of a certain relation X, produces Y such that Y contains only selected attributes of X, such an operation is

• Projection

• Selection

• Union

• Difference

DDL stands for

• Data-dictionary language

• Dictionary defined language

• Data defined language

• Data definition language

What operator performs pattern matching in SQL?

• Except

• Intersect

• Like

• All of these

An attribute of one table matching the primary key of another table is called as

• Secondary key

• Foreign key

• Candidate key

• Surrogate key

Which one of the following is the example of Dynamic Hashing?

• Open Address Hashing

• Chain Hashing

• Linear Hashing

• All of these

Which of the following is an attribute that holds multiple values for a single entity?

• Simple

• Composite

• Derived

• Multi-valued