wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

6INFOMAN (Recitation)

Total questions: 20

Worksheet time: 10mins

Name
Class
Date
1.

It is the process of organizing data to minimize redundancy in the design of a relational database management system (RDBMS).

a)

Database Normalization

b)

Database Subquery

c)

Relational Database Model

d)

DBMS Keys

2.

it states that the domain of an attribute must include only atomic values and that the value of any attribute in a tuple must be a single value from the domain of that attribute.

a)

Boyce - Codd Normal Form

b)

1NF

c)

2NF

d)

3NF

3.

it is a specific type of field in a relational database that can identify each unique record independently of any other data

a)

Composite Key

b)

Surrogate Key

c)

Candidate Key

d)

Superkey

4.

it expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.

a)

Determination

b)

Relationship

c)

Dependency

d)

Cardinality

5.

All superkeys are candidate keys.

a)

True

b)

False

c)

Maybe

d)

No Answer

6.

it means that the value of one or more attributes determines the value of one or more other attributes

a)

Relational Database

b)

Composite Key

c)

Functional Dependence

d)

Tuple

7.

is a key that is composed of more than one attribute.

a)

Compound Key

b)

Composite Key

c)

Superkey

d)

Surrogate Key

8.

it provides a detailed description of all tables in the database created by the user and designer.

a)

Data Dictionary

b)

Logical Data Model

c)

Relational Data Model

d)

Attribute

9.

The real test of redundancy is not how many copies of a given attribute are stored, but whether the elimination of an attribute will eliminate information.

a)

True

b)

False

c)

Maybe

d)

No Answer

10.

it sometimes called an inner query or nested query is a query within another SQL query.

a)

SQL View

b)

Inner Join

c)

SQL Subquery

d)

Join Clause

11.

it consists of one or more attributes that determine other attributes.

a)

Entity

b)

Data Model

c)

Attribute

d)

DBMS Keys

12.

is an attribute whose value is calculated from other attributes.

a)

Derived Attribute

b)

Required Attribute

c)

Optional Attribute

d)

Calculated Attribute

13.

is the state in which knowing the value of one attribute makes it possible to determine the value of another.

a)

Dependency

b)

Relationship

c)

Cardinality

d)

Determination

14.

it refers to the way data are physically stored and processed in a database

a)

Entity Integrity

b)

Physical View

c)

Logical View

d)

Referential Integrity

15.

TRUE or FALSE: The following image is the right syntax for SQL Inner Join.

a)

TRUE

b)

FALSE

c)

Maybe

d)

No Answer

16.

He is considered to be the Father of Relational Databases

a)

Edgar Codd

b)

Edgar Boyce

c)

Ray Boyce

d)

Ray Codd

17.

TRUE or FALSE: The following image will copy or duplicate a table in a database.

a)

TRUE

b)

FALSE

c)

Maybe

d)

No Answer

18.

is a thing, person, place, unit, object or any item about which the data should be captured and stored in the form of properties, workflow and tables. Usually it is the database table.

a)

Process

b)

Relationship

c)

Attribute

d)

Entity

19.

is the condition in which each row (entity instance) in the table has its own unique identity.

a)

Referential Integrity

b)

Dependency

c)

Entity Integrity

d)

Determinant

20.

To avoid nulls, some designers use special codes, known as ______.

a)

Required

b)

Flags

c)

Keys

d)

Normalization