Question # 1

Which key word is available in SQL to enforce referential integrity?

Choose an answer

Check

Primary Key

Set Default

Unique

Which of the following is NOT a feature of Context DFD?

Choose an answer

one process (which represents the entire system)

all sources/sinks (external entities)

data flows linking the process to the sources and sinks (external entities)

sub-processes (which explain and decomposed the major process into small processes)

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

Laser records data by burning microscopic holes in the surface of the disk with a

Choose an answer

Hard disk

RAM

Optical disk

Floppy disk

Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss? Select correct option:

Choose an answer

User accessible catalog

Data processing

Recovery service

Authorization service

Description on particular collection of data using data model

Choose an answer

Schema

Relation

Data base

None of the above

The ____ constraint specifies whether each entity supertype occurrence must also be a member of at least one subtype

Choose an answer

specialization

uniqueness

inheritance

completeness

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

Which of the following SQL keywords is not used with DDL statements?

Choose an answer

Table

Update

Create

Alter

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 component of a DFD?

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