Question # 1

Identify the correct statement with respect to normalization

Choose an answer

Normalization is a formal technique that can be used only at the starting phase of the database design

Normalization can be used as a top-down standalone database design technique

The process of normalization through decomposition must achieve the lossless join property at any cost whereas the dependency reservation property is sometimes sacrificed.

Which of the following is NOT a feature of Indexed sequential files?

Choose an answer

Records are stored in sequence and index is maintained

Dense and nondense types of indexes are maintained

Track overflows and file overflow areas can not be ensured.

Cylinder index increases the efficiency

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

Browser based forms are developed in the following tools EXCEPT

Choose an answer

HTML

Scripting language

Front Page

Web-based Forms

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

Suppose there are 8 rows and 4 columns in TABLE1 and 3 rows and 4 columns in TABLE2; what is the size of the cartesian product incase of CROSS JOIN between these two tables?

Choose an answer

24 ( The number of rows in the first table multiplied by the number of rows in the second table )

32

12

16

Which of the following is true about DELETE command?

Choose an answer

is DDL Command

Resets identity of the table

cannot activate a trigger

Can be Rolled back

Suppose there are 4 fields in a table named WORKER (Id, first_name, last_name, joining_year). Which of the following gives all the information of the workers who have joined after 1965?

Choose an answer

SELECT * FROM WORKER WHERE joining_Year>1965;

SELECT * FROM WORKER WHERE joining_Year>'1965';

SELECT * FROM WORKER AND joining_Year>'1965';

SELECT * WHERE joining_Year>1965;

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

Select the correct statement among the following on proper naming of schema constructs:

Choose an answer

Entity type name applies to all the entities belonging to that entity type and therefore a plural name is selected for entity type.

In the narrative description of the database requirements, verbs tend to indicate the names of relationship types.

The nouns arising from a database requirement description can be considered as names of attributes

Additional nouns which are appearing in the narrative description of the database requirements represent the weak entity type names.

An entity type is

Choose an answer

defined when the database is actually constructed

a specific type such as an integer, text, date, logical etc

a coherent set of similar objects that we want to store data on (e.g. STUDENT, COURSE, CAR)

defined by the database designer

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