Question # 1

_______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

Controlling redundancy in a database management system DOES NOT help to

Choose an answer

avoid duplication

avoid unnecessary wastage of storage space

avoid unauthorised access to data

avoid inconsistency among data

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.

ALTER TABLE exams

RENAME COLUMN Q_description TO Question_Descp, Std_ID to Student_ID. Syntax of ALTER TABLE is NOT correct.

Choose an answer

True

False

Not Sure

ALTER TABLE exams ALTER COLUMN Q_description varchar(50) Syntax of ALTER TABLE is NOT correct.

Choose an answer

True

False

Not Sure

Identify the correct statement with respect to normalization

Choose an answer

Normalization is a formal technique that can be used only at the starting phase of the database design

Normalization can be used as a top-down standalone database design technique

The process of normalization through decomposition must achieve the lossless join property at any cost whereas the dependency reservation property is sometimes sacrificed.

Which of the following serves as a milestone or reference point in the log file?

Choose an answer

Constraints

Relations

Check points

Transactions identities

Which of the following is true about relational schema?

Choose an answer

The sequence of columns is significant

The sequence of rows is significant.

Contains only derived attributes.

Values are atomic

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

Which of the following concepts is applicable with respect to 3NF

Choose an answer

Full functional dependency

Any kind of dependency

Transitive dependency

Partial functional dependency

Which of the following is true about application programs?

Choose an answer

develop before the database design

Tools selection is made after the development database

meant to perform different operations by the user

must to design before the designing and developing database

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