Question # 1

Which of the following are the general activities, which are performed during the development of application programs?

Choose an answer

Data input programs

Editing

Display

All of given

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

Which of the following statements are Data Definition Language command?

Choose an answer

INSERT

UPDATE

GRANT

TRUNCATE

Which of the following is disadvantage of chaining technique to handle the collisions?

Choose an answer

Unlimited Number of elements

Fast re-hashing

Overhead of multiple linked lists

Maximum number of elements must be known

Who is responsible for authorizing access to the database, for coordinating and monitoring its use ?

Choose an answer

Database Designers

Database Administrators

End Users

Application Programmers

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

In which of the following situations, Clustering is suitable:

Choose an answer

Frequently updating

Relatively static

Relatively deletion

Relatively dynamic

GRANT SELECT, UPDATE(Designation) ON Employee TO Amali,Hiruni WITH GRANT OPTION; What does this SQL statement do?

Choose an answer

Grant permission to Amali,only to retrieve data from Employee table and grant permission to Hiruni, only to update the designation from Employee table.

Grant permission to Hiruni in order to grant, select and update permission to Amali.

Grant permission to Amali & Hiruni to update designation of employees in the Employee table

Grant permission to Amali and Hiruni to update all data except designation in Employee table

Database management systems, operating systems, applications and utilities are all examples of ____.

Choose an answer

hardware

software

computer infrastructure

input and output

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 following is true about TRUNCATE?

Choose an answer

Can be Rolled back.

Activates Triggers

is DML Command.

Resets identity of the table

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