Question # 1

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

Choose an answer

non key attribute

key attribute

composite key

sort key

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

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

Choose an answer

Homonyms

Synonyms

Aliases

Alternate attributes

C was developed in the year:

Choose an answer

1970

1972

1976

1995

The case block ends with:

Choose an answer

End Select

End case

Break

Case else

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

Choose an answer

Synonym

Homonym

Acronym

Mutually exclusive

A constraint between two attributes is called:

Choose an answer

Functional relation

Attribute dependency

Functional dependency

Functional relation constaint

In 3NT which form of dependency is removed ?

Choose an answer

functional

non-functional

associative

transitive

The columns of a table correspond to:

Choose an answer

Table

Record

Field

Cell

Database integrity refers to the

Choose an answer

correctness of data

consistency of data

both a and b

none of these

In relational data base, a table is also called:

Choose an answer

Tuple

Relation

File

Schema

Another term for a conditional operator is:

Choose an answer

Ternary

Binary

Byte

Iteration

The conditional part of if statement consists of expression

Choose an answer

arithmetic

logical expression

relational

both b and c

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

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

Choose an answer

2

8

12

16

Which object of database is used to retrieve data from database?

Choose an answer

Queries

Forms

Reports

Tables

In 2NF, which form of dependency is removed ?

Choose an answer

associative

transitive

partial

functional

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

Choose an answer

Choose an answer