Question # 1

Which of the following statements are Data Manipulation Language command?

Choose an answer

INSERT

GRANT

TRUNCATE

CREATE

_______is a control that enables users to select one option from an associated list; users can also type an option.

Choose an answer

Combo box

Button

Text box

Static area

Which of the following is NOT a component of a DFD?

Choose an answer

Dataflow

Datastore

External entities

Relationship between external entities

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 not a benefit of normalization?

Choose an answer

Minimize insertion anomolies

Minimize deletion anomolies

Minimize updation anomolies

Maximize redundancy

The main memory of a computer system is also known as

Choose an answer

ROM

RAM

PROM

Hard disk

Which of the following constraints enforces referential integrity?

Choose an answer

FOREIGN KEY

CHECK

PRIMARY KEY

UNIQUE

Which of the following is true about DELETE command?

Choose an answer

is DDL Command

Resets identity of the table

cannot activate a trigger

Can be Rolled back

Which of the following is not true regarding DB transactions?

Choose an answer

A set of database operations that are processed partly

A database transaction is a logical unit of database operations

A database transaction must be atomic

A database transaction must contains the ACID property

In a conceptual model for a university, what type of relationship exists between Grade and Student entitie

Choose an answer

1:1

1:M

M:M

Ternary

Which of the following are the general activities, which are performed during the development of application programs?

Choose an answer

Data input programs

Editing

Display

All of given

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