ECAT Computer Science MCQS Set 7

ECAT Computer Science MCQS Page 7


Which can be previewed on the screen before printing?
Report
Form
Sub-form
None

In relational database, table is also called:
Relation
Table
File
Schema

Which of the following are anomalies that can be caused by redundancy in tables?
All
Insertion
Deletion
Modification

Any array script should be:
Int
Float
Double
Array

The number of bytes used by ‘int’ data type in C are:
2
8
12
16

We can make two way decisions with the help of
if-else
if
nested
all

The attribute on the left side of the arrow in a functional dependency is called:
Determinant
Candidate key
Foreign key
Primary key

Which of the following anomalies result from a transitive dependency ?
All
Insertion
Modification
Deletion

Database integrity refers to the
both a and b
correctness of data
consistency of data
none of these

Storing the same information in two different ways or forms is called
redundant information
database integrity
homonyms
mutually exclusive data

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

Which form of dependency is removed in 2NF?
Partial
Functional
Transitive
Associative

Be the first to comment

Leave a Reply

Your email address will not be published.


*