Question # 1

_______ 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 gives all the fields from employee table named as EMP?

Choose an answer

SELECT * from EMP;

SELECT emp* from EMP'

SELECT emp_id where EMP;

SELECT * where EMP;

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

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

Consider the following statements. A. An entity integrity constraint states that no primary key value can be null. B. A referential integrity constraint is specified between two relations. C. A foreign key cannot be used to refer to its own relation. Identify which of the above statements is/are correct

Choose an answer

Only A

Only B

B and C

A and B

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

User rights information is stored in

Choose an answer

Physical database

Catalog

Logical database

Buffer

A database system allows the following EXCEPT

Choose an answer

management and control of data towards an efficient working of an organisation

more critical functions in organisations to be computerised and the need to keep a large volume of data available in an up to the minute current state increased.

any user to access all its data

integration of data across multiple applications into a single application.

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.

A description on a particular collection of data using the given data model

Choose an answer

Database

Schema

None of the above

Relation

Which of the following is CORRECT about database management system's languages?

Choose an answer

Data definition languages are used to specify the conceptual schema only.

Data manipulation languages are used to create the databases

Data manipulation languages are used for retrieval, insertion, deletion and modification of data

Data definition langauges are only used to update data in the DBMS.

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