Question # 1

How many types of loop structure are available in C?

Choose an answer

4

3

2

6

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

The columns of a table correspond to:

Choose an answer

Table

Record

Field

Cell

The number of bytes used by 'int' data type in C are:

Choose an answer

2

8

12

16

In 3NT which form of dependency is removed ?

Choose an answer

functional

non-functional

associative

transitive

Which form of dependency is removed in 2NF?

Choose an answer

Functional

Transitive

Associative

Partial

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

Choose an answer

synonyms

homonyms

mutually exclusive data

redundant information

The 1NF describes the tabular format in which:

Choose an answer

All the key attributes are defined

No repeating groups in the table

All attributes are dependent on primary key

All

The program structure that executes program statements in order is

Choose an answer

selection

sequence

repetition

iteration

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 is a possible value of flag?

Choose an answer

-

+

Space

All of these

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

Choose an answer

non key attribute

key attribute

composite key

sort key

The goal of normalization is to:

Choose an answer

Get stable data structure

Increase number of relation

Increase redundancy

Remove constraints

Which form of dependency is removed n 3NF?

Choose an answer

Functional

Non-functional

Associative

Transitive

C was developed in the year:

Choose an answer

1970

1972

1976

1995

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