CS403 Final term Solved Paper 2010 - 2

FINALTERM  EXAMINATION

Spring 2010

CS403- Database Management Systems (10 Aug 2010)

 

 

Question No: 1    ( M a r k s: 1 )     http://vuzs.net

 

Which of the following statements is true about the views?

► view is always a complete set of all the tables in a database

► View can not be used for retrieving data

► The results of using a view are not permanently stored in the database.

► Rows can not be updated or deleted in the view

 

Question No: 2    ( M a r k s: 1 )     http://vuzs.net

 

What is the alternate name of Data Dictionary?

► Index

► Metadata

► Data

► System Catalog

 

Question No: 3    ( M a r k s: 1 )     http://vuzs.net

 

IN function helps reduce the need to use multiple AND conditions.

►True

► False

Question No: 4    ( M a r k s: 1 )     http://vuzs.net

 

Browser based forms are developed in the following tools EXCEPT

► HTML

► Scripting language

► Front Page

► Web-based Forms

 

Question No: 5    ( M a r k s: 1 )     http://vuzs.net

 

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

► Data input programs

► Editing

► Display

► All of given

 

Question No: 6   ( M a r k s: 1 )     http://vuzs.net

 

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

► 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.

 Physical Record and Denormalization

Denormalization is a technique to move from higher to lower normal forms of

database modeling in order to speed up database access. Denormalization process is

applied for deriving a physical data model from a logical form. In logical data base

design we group things logically related through same primary key. In physical

database design fields are grouped, as they are stored physically and accessed by

DBMS. In general it may decompose one logical relation into separate physical

records, combine some or do both. There is a valid reason for denormalization that is

to enhance the performance.

Question No: 7   ( M a r k s: 1 )     http://vuzs.net

 

Which of the following gives all the fields from employee table named as EMP?

► SELECT * from EMP;

► SELECT emp* from EMP'

► SELECT emp_id where EMP;

► SELECT * where EMP;

 

Question No: 8    ( M a r k s: 1 )     http://vuzs.net

 

Which of the following types of partitioning reduces the chances of unbalanced partitions?

► Vertical

► List

► Hash

► Range

 Hash Partitioning:

It is a type of horizontal partitioning. In this type particular algorithm is applied and

DBMS knows that algorithm. So hash partitioning reduces the chances of unbalanced

 

Question No: 9    ( M a r k s: 1 )     http://vuzs.net

 

While recovering data, which of the following files does a recovery manager examines at first?

► A system file

► Log file

► Data dictionary

► Metadata

 

Question No: 10   ( M a r k s: 1 )     http://vuzs.net

 

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

► 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

Indexed Sequential Summary:

Following are salient features of Indexed sequential file structure:

Records are stored in sequence and index is maintained.

Dense and nondense types of indexes are maintained.

Track overflows and file overflow areas are ensured.

Cylinder index increases the efficiency .

 

Question No: 13    ( M a r k s: 1 )     http://vuzs.net

 

ALTER TABLE exams

RENAME COLUMN Q_description TO Question_Descp, Std_ID to Student_ID.

Syntax of ALTER TABLE is NOT correct.

 ► True

► False

 

Question No: 14    ( M a r k s: 1 )     http://vuzs.net

Which of the following SQL commands deletes a record of an employee with the employee_id 12345, from a table named PERSON.

► DELETE FROM person WHERE employee_id = ‘12345’

► DELETE WHERE person FROM employee_id = 12345

► DROP FROM person WHERE employee_id = 12345

► DELETE WHERE person WHERE employee_id = 12345

 

Question No: 15   ( M a r k s: 1 )     http://vuzs.net

Which of the following is not a form of optical disk?

 

► CD ROM

► WORM

► Erasable Optical

► EEPROM

 

Question No: 16    ( M a r k s: 1 )     http://vuzs.net

Which of the following is the correct description of cache hit?

► When data is found in the cache

► When data is removed in the cache

► The number of times the cache is accessed directly by the processor

► When data is lost from the cache

 

Question No: 17    ( M a r k s: 1 )     http://vuzs.net

 

In which of the following situations, Clustering is suitable:

► Frequently updating

► Relatively static

► Relatively deletion

► Relatively dynamic

 

Question No: 18    ( M a r k s: 1 )     http://vuzs.net

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

► Unlimited Number of elements

► Fast re-hashing

► Overhead of multiple linked lists

► Maximum number of elements must be known

 

Question No: 19    ( M a r k s: 1 )     http://vuzs.net

Which of the following is NOT a component of a DFD? Select correct option:

 

►Dataflow

►Datastore

►External entities

►Relationship between external entities

  

Question No: 20    ( M a r k s: 1 )     http://vuzs.net

Laser records data by burning microscopic holes in the surface of the disk with a

 

► Hard disk

► RAM

► Optical disk

► Floppy disk

 Optical disks record data by burning microscopic holes in the surface of the disk with

a laser. To read the disk, another laser beam shines on the disk and detects the holes

by changes in the reflection pattern.

Question No: 21    ( M a r k s: 1 )     http://vuzs.net

 

Which of the following concepts is applicable with respect to 3NF?

► Full functional dependency

► Any kind of dependency

► Transitive dependency

► Partial functional dependency

 

Question No: 22    ( M a r k s: 1 )     http://vuzs.net

 

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

► Consistency

► Process based

► Data structure based

► User friendly

 

Question No: 23    ( M a r k s: 2 )

 

Give 2 similarities between Materialized views and indexes.

 

Question No: 24    ( M a r k s: 2 )

 

What are the forms of cache normally used in desktop computers

 

Question No: 25    ( M a r k s: 3 )

 

Write the properties of Sequence File

 

Question No: 26    ( M a r k s: 3 )

 

What is meant by database recovery services?

 

Question No: 27    ( M a r k s: 5 )

 

Write four steps to recover from a deadlock between the transactions

 

Question No: 28    ( M a r k s: 5 )

 

 

Consider a table named COMPANY with fields COMPANY_NAME,

 

DESCRIPTION, ORDER_NUMBER. Write an SQL statement to display company names in reverse alphabetical order.

 

Question No: 29    ( M a r k s: 5 )

 

Write five advantages of using VIEWS.