Question # 1

Incase of Context-level Diagram, the system is represented by

Select correct option:

Choose an answer

One process atleast

Two processes atleast

One process only

Any number of processes

How many clustered index(es) do each database table have?

Choose an answer

2

3

4

1

While recovering data, which of the following files does a recovery manager examines at first?

Choose an answer

A system file

Log file

Data dictionary

Metadata

Identify the INCORRECT statement among the given.

Choose an answer

An entity may be an object with a physical existence like a car, a house or an Employee

One cannot consider something which has conceptual existence like a course in a degree program as an entity

Age can be considered as a single value attribute of a person.

An entity type describes the schema or intension for a set of entities which share the same structure.

In SQL queries, while creating tables or relations in database, key columns may be specified by

Choose an answer

Data type

Null

Not Null

Owner

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 .

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 statements creates a database named COMPANY.

Choose an answer

CREATE DATABASE company

CREATE DB company

ADD DATABASE copmany

CREATE company DATABASE

Which of the following statements are Data Definition Language command?

Choose an answer

INSERT

UPDATE

GRANT

TRUNCATE

If K is a foreign key in relation R1, then

Choose an answer

every tuple of R1 has a distinct value for K

k can not have a null value for tuples in R1

K is a key for some other relation.

K is a primary key for R1.

Identify the correct statement about ANSI/SPARC architecture.

Choose an answer

The external level is not concerned with individual user perceptions

The internal level, in a database system, will always be relational

Any given database has exactly one conceptual schema and one physical schema, but it may have several external schemas.

A data definition language is used to define the internal schema

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