Question # 1

The goal of normalization is to:

Choose an answer

Get stable data structure

Increase number of relation

Increase redundancy

Remove constraints

------------------- is created when two different names are used for the same information

Choose an answer

synonyms

homonyms

mutually exclusive data

redundant information

Which format specific is used for integer data type?

Choose an answer

%d

%S

%C

%f

A constraint between two attributes is called:

Choose an answer

Functional relation

Attribute dependency

Functional dependency

Functional relation constaint

In relational database, table is also called:

Choose an answer

Table

Relation

File

Schema

In 3NF, a non key attribute must not depend on a

Choose an answer

non key attribute

key attribute

composite key

sort key

In 2NF, which form of dependency is removed ?

Choose an answer

associative

transitive

partial

functional

Which form of dependency is removed in 2NF?

Choose an answer

Functional

Transitive

Associative

Partial

Which of the following is a decision making statement

Choose an answer

break

getch ( )

if

all

A relation is in 2NF if it is in 1NF and all its non-key attributes are:

Choose an answer

Dependent on part of the primary key

Dependent on the entire primary key

Independent on the primary key

Independent of any other relation

------------ is a constraint on primary values that states that no attribute of a primary key should contain nulls

Choose an answer

referential integrity

entity integrity

normalization

acronyms

A relation is in third normal form if it is in second normal form and:

Choose an answer

Dependent on part of the key

Dependent on the whole key

Independent of the key

Has no transitive dependencies

Database integrity refers to the

Choose an answer

correctness of data

consistency of data

both a and b

none of these

The type of expression x > y is

Choose an answer

arithmetic

logical

relational

conditional

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

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

Choose an answer

Homonyms

Synonyms

Aliases

Alternate attributes

The program structure that executes program statements in order is

Choose an answer

selection

sequence

repetition

iteration

More Classes

Other Links

Computer Science Ics Part 2 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

Choose an answer

Choose an answer