Question # 1

Which of the following anomalies result from a transitive dependency ?

Choose an answer

Insertion

Modification

Deletion

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

The scope of a variable refers to its:

Choose an answer

Length

Name

Accessibility

Data type

Which format specific is used for integer data type?

Choose an answer

%d

%S

%C

%f

Which is a possible value of flag?

Choose an answer

-

+

Space

All of these

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

Choose an answer

Synonym

Homonym

Acronym

Mutually exclusive

The columns of a table correspond to:

Choose an answer

Table

Record

Field

Cell

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

Choose an answer

Insertion

Deletion

Modification

All

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

Choose an answer

database integrity

homonyms

normalization

mutually exclusive data

Which of the following is a decision making statement

Choose an answer

break

getch ( )

if

all

Which form of dependency is removed n 3NF?

Choose an answer

Functional

Non-functional

Associative

Transitive

Which form of dependency is removed in 2NF?

Choose an answer

Functional

Transitive

Associative

Partial

A constraint between two attributes is called:

Choose an answer

Functional relation

Attribute dependency

Functional dependency

Functional relation constaint

Every relation should have :

Choose an answer

Primary key

Candidate key

Secondary key

Mutually exclusiveness

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

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

Choose an answer

Non-key attribute

Key attribute

Composite key

Sort key

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

Choose an answer

Choose an answer