Question # 1

In 3NT which form of dependency is removed ?

Choose an answer

functional

non-functional

associative

transitive

The program structure that executes program statements in order is

Choose an answer

selection

sequence

repetition

iteration

The case block ends with:

Choose an answer

End Select

End case

Break

Case else

A rule that states each foreign key value must match a primary key value in the other relation is called:

Choose an answer

Referential integrity constraints

Key match rule

Entity key group rule

Foreign/ primary match rule

A constraint between two attributes is called:

Choose an answer

Functional relation

Attribute dependency

Functional dependency

Functional relation constaint

The goal of normalization is to:

Choose an answer

Get stable data structure

Increase number of relation

Increase redundancy

Remove constraints

The attribute on the left side of the arrow in a functional dependency is called:

Choose an answer

Candidate key

Determinant

Foreign key

Primary key

How many table views are available in MS Access?

Choose an answer

1

3

2

4

Which form of dependency is removed n 3NF?

Choose an answer

Functional

Non-functional

Associative

Transitive

Which of the following are anomalies that can be caused by redundancy in tables?

Choose an answer

Insertion

Deletion

Modification

All

Which of the following anomalies result from a transitive dependency ?

Choose an answer

Insertion

Modification

Deletion

All

Storing the same information in two different ways or forms is called

Choose an answer

database integrity

redundant information

homonyms

mutually exclusive data

The conditional part of if statement consists of expression

Choose an answer

arithmetic

logical expression

relational

both b and c

Two or more attributes with different name but same meaning create a problem:

Choose an answer

Homonyms

Synonyms

Aliases

Alternate attributes

------------- is the process of converting complex data structures into simple and stable data structures

Choose an answer

database integrity

homonyms

normalization

mutually exclusive data

More Classes

Other Links

ICS Part 2 Computer Science Chapter 4 Online Test MCQs With Answers

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer