Question # 1

A constraint between two attributes is called:

Choose an answer

Functional relation

Attribute dependency

Functional dependency

Functional relation constaint

Which form of dependency is removed n 3NF?

Choose an answer

Functional

Non-functional

Associative

Transitive

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

The goal of normalization is to:

Choose an answer

Get stable data structure

Increase number of relation

Increase redundancy

Remove constraints

The type of expression x > y is

Choose an answer

arithmetic

logical

relational

conditional

In 3NT which form of dependency is removed ?

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

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

Choose an answer

Synonym

Homonym

Acronym

Mutually exclusive

The conditional part of if statement consists of expression

Choose an answer

arithmetic

logical expression

relational

both b and c

In relational data base, a table is also called:

Choose an answer

Tuple

Relation

File

Schema

The case block ends with:

Choose an answer

End Select

End case

Break

Case else

The value of expression in switch statement must be type of

Choose an answer

int

char

float

both a and b

Which are basic data distribution strategies?

Choose an answer

Centralized

Partitioned

Replication

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