Search Papers On This Blog. Just Write The Name Of The Course

Friday 24 December 2010

CS403- Database Management Systems Complete Finalterm Paper 2010

FINALTERM  EXAMINATION
Spring 2010
CS403- Database Management Systems (Session - 2)
Ref No:
Time: 90 min
Marks: 58

Student Info
 StudentID:

 Center:
 
 ExamDate:
 


    
Question No: 1    ( Marks: 1 )    - Please choose one
 Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?

       ► User accessible catalog

       ► Data processing

       ► Authorization service

       ► Recovery service

   
Question No: 2    ( Marks: 1 )    - Please choose one
 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: 3    ( Marks: 1 )    - Please choose one
 Which of the following is true about TRUNCATE?
       Can be Rolled back.

       Activates Triggers.

       is DML Command.

       Resets identity of the table.

   
Question No: 4    ( Marks: 1 )    - Please choose one
 Which of the following is the correct way to find out the size of cartesian product incase of CROSS JOIN?
       the number of columns in the first table multiplied by the number of columns in the second table.

       the number of columns in the first table multiplied by the number of rows in the second table.

       the number of rows in the first table multiplied by the number of columns in the first table.

       the number of rows in the first table multiplied by the number of rows in the second table.

   
Question No: 5    ( Marks: 1 )    - Please choose one
 Suppose there are 8 rows and 4 columns in TABLE1 and 3 rows and 4 coulmns in TABLE2; what is the size of the cartesian product incase of CROSS JOIN between these two tables?
       ► 24
       ► 32
       ► 12
       ► 16
   
Question No: 6    ( Marks: 1 )    - Please choose one
 Which of the following is not one of the properties of Transaction?
       ► atomicity
       ► consistency
       ► redundancy
       ► durability
  
Question No: 7    ( Marks: 1 )    - Please choose one
 Which of the following is INCORRECT about VIEWS?
       ► It is not possible to left out the data which is not required for a specific view.

       ► A database view displays one or more database records on the same page.

       ► Views can be used as security mechanisms

       ► Views are generally used to focus the perception each user
has of the database.

   
Question No: 8    ( Marks: 1 )    - Please choose one
 Each course section is assigned a particular faculty member, and each course section corresponds to a particular course. Conceptually, what is the relationship between faculty and course (not course section).
       ► 1:1
       ► 1:M
       ► M:M
       ► Ternary
   
Question No: 9    ( Marks: 1 )    - Please choose one
 Which of the following is used to add or drop columns in an existing table?

       ► ALTER
       ► HAVING
       ► SELECT
       ► THEN
 
Question No: 10    ( Marks: 1 )    - Please choose one
 Which of the following is a correct way of selecting all the columns from a table called PERSONS?
       SELECT FROM * Persons

       SELECT * FROM Persons

       SELECT * WHERE Persons

       SELECT WHERE * Persons

   
Question No: 11    ( Marks: 1 )    - Please choose one
 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

   
Question No: 12    ( Marks: 1 )    - Please choose one
 Consider the given relations Student and Instructor as given below. Please note that
Fname and Lname also denote the First Name and Last Name respectively.


Which of the following statements is correct with respect to the two relations given above?

       The two relations are not union-compatible since their attribute names differ.
       The two relations are union-compatible since they have the same type of tuples.
       The set operations such as CARTESIAN PRODUCT and DIVISION can be applied on these
two relations.

       To find out the students who are not instructors, it is necessary to perform the operation
Student ÷ Instructor.

   
Question No: 13    ( Marks: 1 )    - Please choose one
 Which of the following serves as a milestone or reference point in the log file?

       ► Constraints

       ► Relations

       ► Check points

       ► Transactions identities

   
Question No: 14    ( Marks: 1 )    - Please choose one
 Which of the following is not true regarding DB transactions?

       ► A set of database operations that are processed partly
       ► A database transaction is a logical unit of database operations

       ► A database transaction must be atomic

       ► A database transaction must contains the ACID property

   
Question No: 15    ( Marks: 1 )    - Please choose one
 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: 16    ( Marks: 1 )    - Please choose one
 Browser based forms are developed in the following tools EXCEPT

       ► HTML

       ► Scripting language

       ► Front Page

       ► Web-based Forms

   
Question No: 17    ( Marks: 1 )    - Please choose one
 Which of the following is not a form of optical disk?

       ► CD ROM

       ► WORM

       ► Erasable Optical

       EEPROM

   
Question No: 18    ( Marks: 1 )    - Please choose one
 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: 19    ( Marks: 1 )    - Please choose one
 In which of the following situations, Clustering is suitable:
       ► Frequently updating
       ► Relatively static
       ► Relatively deletion
       ► Relatively dynamic
  
Question No: 20    ( Marks: 1 )    - Please choose one
 Only one type of constraint can be enforced in any table by CREATE command
       ► True
       ► False
   
Question No: 21    ( Marks: 1 )    - Please choose one
 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: 22    ( Marks: 1 )    - Please choose one
 Consider the following relation R and its sample data. (Consider that these are the only tuples for the given relation)

Which of the following statements is NOT correct?

       The functional dependency ProjNo -> DeptNo holds over R.
       The functional dependency (EmpNo, ProjNo) -> DeptNo holds over R.
       The functional dependency DeptNo -> ProjNo holds over R.
       The functional dependency EmpNo -> DeptNo holds over R.
   
Question No: 23    ( Marks: 1 )    - Please choose one
 An entity type is

       ► 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
   
Question No: 24    ( Marks: 1 )    - Please choose one
 An entity can be logically connected to another by defining a ____.
       ► hyperlink
       ► common attribute
       ► primary key
       ► superkey
   
Question No: 25    ( Marks: 1 )    - Please choose one
 You can’t modify more than one table at a time through a view.
       ► True
       ► False
 
Question No: 26    ( Marks: 1 )    - Please choose one
 Which of the following is one of the purposes of using DML commands?



       ► Creating databases
       ► Destroying databases
       ► Inserting data in tables
       ► Non of the above
   
Question No: 27    ( Marks: 2 )
 
   
Question No: 28    ( Marks: 2 )
 Define domain of an attribute.
   
Question No: 29    ( Marks: 2 )
 Write the main feature of volatile storage media?
   
Question No: 30    ( Marks: 2 )
 Suppose you want to delete a table row by row and record an entry in the transaction log for each deleted row. Which DML command will you use?
   
Question No: 31    ( Marks: 3 )
 Write three benefits of using VIEWS.
   
Question No: 32    ( Marks: 3 )
 SELECT * FROM Persons
WHERE FirstName LIKE '%da%';

what does the above statement return?
   
Question No: 33    ( Marks: 3 )
 What is the difference between a primary key and a unique key with reference to clustered and nonclustered indexes?

   
Question No: 34    ( Marks: 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: 35    ( Marks: 5 )
 Name the five main components of Database management systems software.

   
Question No: 36    ( Marks: 5 )
 Give 4 similarities between Materialized views and indexes.


No comments:

Post a Comment