Question # 1

Which of the following statements are Data Definition Language command?

Choose an answer

INSERT

UPDATE

GRANT

TRUNCATE

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)

A software package designed to store and manage databases

Choose an answer

Database

DBMS

Data model

Data

Which of the following is incorrect with respect to indexed sequential files?

Choose an answer

New records are added to an overflow file

Record in main file that precedes it is updated to contain a pointer to the new record

The overflow is merged with the main file during a batch update

Multiple indexes for the same key field cannot be setup

Which of the following is NOT a feature of a good interface?

Choose an answer

Consistency

Process based

Data structure based

User friendly

What is the impact of setting multiple indexes for the same key, in index sequential files?

Choose an answer

Multiple indexes for the same key can not be set

It increases efficiency

It decreases efficiency

It will increase complexity as the access time will be increased

Browser based forms are developed in the following tools EXCEPT

Choose an answer

HTML

Scripting language

Front Page

Web-based Forms

Which of the following is not true about relational tables?

Choose an answer

Column values are of the same kind

Each row is unique

Each column must have a unique name.

The sequence of rows is significant.

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

Choose an answer

candidate key

primary key

superkey

secondary key

Suppose there are 4 fields in a table named CUST (customer_id, first_name, last_name, phone). Which of the following gives all the information of the customers in the table whose last name is ALI?

Choose an answer

SELECT * FROM CUST WHERE last_name='ALI';

SELECT * FROM CUST WHERE last_name=ALI;

SELECT * FROM CUSTOMER WHERE name=ALI;

SELECT * FROM CUSTOMER WHERE last_name=ALI;

Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of

Choose an answer

Physical data independence

Concurrency control.

Logical data independence.

Functional dependency

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