Question # 1

How many types of loop structure are available in C?

Choose an answer

4

3

2

6

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

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

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

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

Choose an answer

Homonyms

Synonyms

Aliases

Alternate attributes

The type of expression x > y is

Choose an answer

arithmetic

logical

relational

conditional

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

Choose an answer

Insertion

Deletion

Modification

All

The 1NF describes the tabular format in which:

Choose an answer

All the key attributes are defined

No repeating groups in the table

All attributes are dependent on primary key

All

Which are basic data distribution strategies?

Choose an answer

Centralized

Partitioned

Replication

All

Which of the following anomalies result from a transitive dependency ?

Choose an answer

Insertion

Modification

Deletion

All

Which form of dependency is removed n 3NF?

Choose an answer

Functional

Non-functional

Associative

Transitive

The scope of a variable refers to its:

Choose an answer

Length

Name

Accessibility

Data type

The value of expression in switch statement must be type of

Choose an answer

int

char

float

both a and b

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

Choose an answer

synonyms

homonyms

mutually exclusive data

redundant information

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

Which can be previewed on the screen before printing?

Choose an answer

Report

Form

Sub-form

None

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