Question # 1

Which of the following concept is applicable with respect to 2NF?

Choose an answer

Non-transitive dependency

Full functional dependency

Partial dependency

Transitive dependency

Which of the following is INCORRECT statement concerning the database design process?

Choose an answer

During requirements collection and analysis phase, one can gather the data requirements of database users.

By referring to a high level data model, it is possible to understand the data requirements of the users, entity types, relationships and constraints.

Transformation of the high level data model into the implementation data model is called logical design or data model mapping

During the logical design phase of internal storage structures, access paths and file organization for the database files are specified.

A ____ relationship exists when an association is maintained within a single entity.

Choose an answer

unary

ternary

binary

weak

Consider two sets A and B. A contains 2 elements and B contains 3. How many elements do their cartesian product contains?

Choose an answer

6

9

5

4

_______ is a control that users click to perform an action, set or toggle a state, or set an option.

Choose an answer

Button

Text box

Input form

Report

Which of the following is one of the purposes of using DML commands?

Choose an answer

Creating databases

Destroying databases

Inserting data in tables

Non of the above

In which of the following, Materialized Views are suitable

Choose an answer

Data warehousing

Decision support

Mobile computing

All of the Given

What is the alternate name of Data Dictionary?

Choose an answer

Index

Metadata

Data

System Catalog

Identify the INCORRECT statement among the given.

Choose an answer

An entity may be an object with a physical existence like a car, a house or an Employee

One cannot consider something which has conceptual existence like a course in a degree program as an entity

Age can be considered as a single value attribute of a person.

An entity type describes the schema or intension for a set of entities which share the same structure.

Which of the following is not true about De-normalization?

Choose an answer

It is the process of attempting to optimize the performance of a database

De-normalization is a technique to move from lower to higher normal forms of database modeling

It enhances the performance of DB

In de-normalization it is required to add redundant data.

Which of the following is true about TRUNCATE?

Choose an answer

Can be Rolled back.

Activates Triggers

is DML Command.

Resets identity of the table

More Classes

Other Links

CS-403 Final Term Exams Preparation Virtual University 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