Question # 1

In relational database, table is also called:

Choose an answer

Table

Relation

File

Schema

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

Choose an answer

synonyms

homonyms

mutually exclusive data

redundant information

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

Database integrity refers to the

Choose an answer

correctness of data

consistency of data

both a and b

none 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

The type of expression x > y is

Choose an answer

arithmetic

logical

relational

conditional

Which of the following anomalies result from a transitive dependency ?

Choose an answer

Insertion

Modification

Deletion

All

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

Choose an answer

Homonyms

Synonyms

Aliases

Alternate attributes

The columns of a table correspond to:

Choose an answer

Table

Record

Field

Cell

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

How many table views are available in MS Access?

Choose an answer

1

3

2

4

Every relation should have :

Choose an answer

Primary key

Candidate key

Secondary key

Mutually exclusiveness

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

Choose an answer

database integrity

homonyms

normalization

mutually exclusive data

A constraint between two attributes is called:

Choose an answer

Functional relation

Attribute dependency

Functional dependency

Functional relation constaint

Which is a possible value of flag?

Choose an answer

-

+

Space

All of these

The value of expression in switch statement must be type of

Choose an answer

int

char

float

both a and b

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

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

Choose an answer