Question # 1

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

Which can be previewed on the screen before printing?

Choose an answer

Report

Form

Sub-form

None

The scope of a variable refers to its:

Choose an answer

Length

Name

Accessibility

Data type

The conditional part of if statement consists of expression

Choose an answer

arithmetic

logical expression

relational

both b and c

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

Choose an answer

Insertion

Deletion

Modification

All

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

Choose an answer

non key attribute

key attribute

composite key

sort key

Different attributes in two different tables having same name are called:

Choose an answer

Synonym

Homonym

Acronym

Mutually exclusive

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

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

Choose an answer

Non-key attribute

Key attribute

Composite key

Sort key

Which format specific is used for integer data type?

Choose an answer

%d

%S

%C

%f

The case block ends with:

Choose an answer

End Select

End case

Break

Case else

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

Every relation should have :

Choose an answer

Primary key

Candidate key

Secondary key

Mutually exclusiveness

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

Choose an answer

database integrity

redundant information

homonyms

mutually exclusive data

Which of the following is a decision making statement

Choose an answer

break

getch ( )

if

all

We can make two way decisions with the help of

Choose an answer

if

nested

if-else

all

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