Question # 1

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

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

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

Choose an answer

Physical data independence

Concurrency control.

Logical data independence.

Functional dependency

As part of database naming conventions, attribute names should use suffixes such as ID, NUMBER or CODE for the _______.

Choose an answer

primary key

foreign key

index

determinant

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 true about application programs?

Choose an answer

develop before the database design

Tools selection is made after the development database

meant to perform different operations by the user

must to design before the designing and developing database

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;

Which of the given techniques is/are used to improve query performance in database?

Choose an answer

Good File organization

Indexing

Both Indexing and Good File organization

Select only one record per query

Which of the following is an example of volatile memory?

Choose an answer

RAM

ROM

Flash memory

CPU

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

Choose an answer

User accessible catalog

Data processing

Authorization service

Recovery service

_______is a control that enables users to select one option from an associated list; users can also type an option

Choose an answer

Combo box

Button

Text box

Static area

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