Question # 1

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

Which of the following is true about NOT NULL constraint?

Choose an answer

enforce domain integrity

limit the values that can be placed in a column

prevents any actions that would destroy links between tables with the corresponding data values

enforces the uniqueness of the values in a set of columns

Select the correct statement among the following

Choose an answer

When different entity types participate only once in a single relationship type it is called a recursive relationship

Role names are not technically necessary in relationship types when all the participating entity types are distinct

Cardinality ratios for binary relationship are displayed on Entity Relationship Diagrams by using a diamond shape notation

Partial participation which is also called existence dependency is displayed as a double line connecting the participating entity type to the relationship .

_______ 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 serves as a milestone or reference point in the log file?

Choose an answer

Constraints

Relations

Check points

Transactions identities

A super key that does not contain a subset of attributes that is itself a super key is called a ____.

Choose an answer

candidate key

primary key

superkey

secondary key

Which of the following is not a form of optical disk?

Choose an answer

CD ROM

WORM

Erasable Optical

EEPROM

Which of the following statements is true about the views?

Choose an answer

view is always a complete set of all the tables in a database

View can not be used for retrieving data

The results of using a view are not permanently stored in the database.

Rows can not be updated or deleted in the view

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

Select the correct statement among the following on proper naming of schema constructs:

Choose an answer

Entity type name applies to all the entities belonging to that entity type and therefore a plural name is selected for entity type.

In the narrative description of the database requirements, verbs tend to indicate the names of relationship types.

The nouns arising from a database requirement description can be considered as names of attributes.

Additional nouns which are appearing in the narrative description of the database requirements represent the weak entity type names.

Which of the following is NOT a component of a DFD? Select correct option:

Choose an answer

Dataflow

Datastore

External entities

Relationship between external entities

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