Question # 1

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

A software package designed to store and manage databases

Choose an answer

Database

DBMS

Data model

Data

Which of the following is not true about De-normalization?

Choose an answer

It is the process of attempting to optimize the performance of a database

De-normalization is a technique to move from lower to higher normal forms of database modeling

It enhances the performance of DB

In de-normalization it is required to add redundant data.

Which of the following is INCORRECT statement concerning the database design process?

Choose an answer

During requirements collection and analysis phase, one can gather the data requirements of database users.

By referring to a high level data model, it is possible to understand the data requirements of the users, entity types, relationships and constraints.

Transformation of the high level data model into the implementation data model is called logical design or data model mapping

During the logical design phase of internal storage structures, access paths and file organization for the database files are specified.

The Entity Relation Model models

Choose an answer

Entities, Relationships and Processes

Entities and Relationships

Relationships

Entities

Controlling redundancy in a database management system DOES NOT help to

Choose an answer

avoid duplication

avoid unnecessary wastage of storage space

avoid unauthorised access to data

avoid inconsistency among data

______ is a control that presents a set of choices from which a user can select one or more items; items can be text, graphics, or both.

Choose an answer

Text input

Report

Button

List box

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

A ____ relationship exists when an association is maintained within a single entity.

Choose an answer

unary

ternary

binary

weak

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

In which of the following situations, Clustering is suitable:

Choose an answer

Frequently updating

Relatively static

Relatively deletion

Relatively dynamic

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