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.
