Question # 1

Which form of dependency is removed n 3NF?

Choose an answer

Functional

Non-functional

Associative

Transitive

The entity integrity rule states that:

Choose an answer

No primary key attribute can be null

Each entity must have a primary key

Primary key must have only one attribute

None

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

Choose an answer

Insertion

Deletion

Modification

All

The conditional part of if statement consists of expression

Choose an answer

arithmetic

logical expression

relational

both b and c

The goal of normalization is to:

Choose an answer

Get stable data structure

Increase number of relation

Increase redundancy

Remove constraints

We can make two way decisions with the help of

Choose an answer

if

nested

if-else

all

------------ 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

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

Choose an answer

Queries

Forms

Reports

Tables

The program structure that executes program statements in order is

Choose an answer

selection

sequence

repetition

iteration

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

A functional dependency between two or more non-key attributes is called:

Choose an answer

Partial functional dependency

Partial non-key dependency

Transitive dependency

None

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

Choose an answer

non key attribute

key attribute

composite key

sort key

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

Choose an answer

database integrity

redundant information

homonyms

mutually exclusive data

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

The case block ends with:

Choose an answer

End Select

End case

Break

Case else

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