Question # 1

------------- is the process of converting complex data structures into simple and stable data structures

Choose an answer

database integrity

homonyms

normalization

mutually exclusive data

Database integrity refers to the

Choose an answer

correctness of data

consistency of data

both a and b

none of these

How many table views are available in MS Access?

Choose an answer

1

3

2

4

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

Which of the following is a decision making statement

Choose an answer

break

getch ( )

if

all

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

In 3NT which form of dependency is removed ?

Choose an answer

functional

non-functional

associative

transitive

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

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

Choose an answer

Queries

Forms

Reports

Tables

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

Any array script should be:

Choose an answer

Int

Float

Double

Array

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

Choose an answer

2

8

12

16

A constraint between two attributes is called:

Choose an answer

Functional relation

Attribute dependency

Functional dependency

Functional relation constaint

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