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

Friday 24 December 2010

Complete Solved Finalterm Paper of CS403- Database Management Systems 2010

FINALTERM  EXAMINATION
Spring 2010
CS403- Database Management Systems
Time: 90 min
Marks: 58

Student Info
Student ID:


Center:


Exam Date:





Question No: 1      ( Marks: 1 ) - Please choose one


Which one of the following E-R diagrams most correctly represents the relationship between Student and Grade entities?

      

      

      

      



Question No: 2      ( Marks: 1 ) - Please choose one


Which of the following statements are Data Definition Language command?


       ► INSERT


       UPDATE


       GRANT


       ► TRUNCATE



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


How many clustered index(es) do each database table have?

       2

       3

       5

       ► 1



Question No: 5      ( Marks: 1 ) - Please choose one


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

       ► 24

       20

       18

       15



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


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


Consider the relation Interview(CandidateNo, InterviewDate, InterviewTime, StaffNo, RoomNo)
and the following functional dependencies.
FD1 : CandidateNo, InterviewDate -> InterviewTime, StaffNo, RoomNo
FD2 : RoomNo, InterviewDate, InterviewTime -> StaffNo, CandidateNo
FD3 : StaffNo, InterviewDate -> RoomNo
Which of the following is correct?


       The relation Interview is in 3NF

       The relation Interview is in BCNF.

       The FD3 violates 3NF.

       The FD2 violates 2NF.



Question No: 10      ( Marks: 1 ) - Please choose one


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

       vertical

       List

       ► Hash

       Range



Question No: 11      ( Marks: 1 ) - Please choose one


Which of the following is one of the purposes of using DDL commands?

       inserting records into databases

       updating records into databases

       manipulating databases

       ► creating and destroying databases


Question No: 12      ( Marks: 1 ) - Please choose one


Which of the following statements creates a database named COMPANY.

       ► CREATE DATABASE company



       CREATE DB company

       ADD DATABASE copmany

       CREATE company DATABASE



Question No: 13      ( Marks: 1 ) - Please choose one


What is the impact of setting multiple indexes for the same key, in index sequential files?


       ► Multiple indexes for the same key can not be set


       ► It increases efficiency


       It decreases efficiency


       It will increase complexity as the access time will be increased




Question No: 14      ( Marks: 1 ) - Please choose one


Consider a transaction which includes following operations
Z= Z + 10
Write Z
...
Suppose that the value of Z after addition and the execution of this operation is 17. Now against the write operation the entry made in the log file will be
<Tn, Z, 33>
What does Z reflects in the above entry?


       Object being updated


       Identity of the transaction


       Object value


       ► Identity of the next transaction to be executed




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


Which of the following is not true about input forms?

       Provide an easy, effective, efficient way to enter data into a table


       Especially useful when the person entering the data is not familiar with the inner workings


       Provide different controls to add data into the tables


       ► One input forms can populate one table at a time



Question No: 17      ( Marks: 1 ) - Please choose one


Which of the following is an example of volatile memory?


       ► RAM


       ROM


       Flash memory


       CPU




Question No: 18      ( Marks: 1 ) - Please choose one


Which of following is NOT generally the aim of data partitioning and placement of data?

       Reduce Workload

       Balance Workload

       ► Merging different relations

       Speed up rate of useful works.



Question No: 19      ( Marks: 1 ) - Please choose one


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


Which of the following is Advantage of Re-Hashing technique to handle the collisions?

       Collisions don’t use primary table space

       Unlimited number of elements

       ► Fast access through use of main table space

       Overhead of multiple linked lists


Question No: 21      ( Marks: 1 ) - Please choose one


Materialized views and Indexes are NOT similar by the following way(s).

       They consume storage space

       They must be refreshed when the data in their master tables changes.

       ► They can be accessed directly using a SELECT statement

       All of the Given



Question No: 22      ( Marks: 1 ) - Please choose one


Select 'NORTH', CUSTOMER From CUST_DTLS Where REGION = 'N' Order
By
CUSTOMER Union Select 'EAST', CUSTOMER From CUST_DTLS Where
REGION = 'E' Order By CUSTOMER
The above statement:

       ► Has an error - the string should be in double quotes.

       ► Has an error - ORDER BY clause.

       Does not have an error.

       Has an error - the string in single quotes 'NORTH' and 'SOUTH'.



Question No: 23      ( Marks: 1 ) - Please choose one


A software package designed to store and manage databases


       Database

       ► DBMS

       Data model

       Data



Question No: 24      ( Marks: 1 ) - Please choose one


Who is responsible for authorizing access to the database, for coordinating and monitoring its use ?



       Database Designers

       ► Database Administrators

       End Users

       Application Programmers



Question No: 25      ( Marks: 1 ) - Please choose one


A superkey that does not contain a subset of attributes that is itself a superkey is called a ____.

       ► candidate key

       primary key

       superkey

       secondary key



Question No: 26      ( Marks: 1 ) - Please choose one


A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.

       strong  

       ► weak

       business

       relationship



Question No: 27      ( Marks: 2 )


What is the “data type”?



Question No: 28      ( Marks: 2 )


Which DML statement changes the values of one or more columns based on some conditions.

Question No: 29      ( Marks: 2 )


Name the two types of caching that are commonly used  in personal computers?


Question No: 30      ( Marks: 2 )


What is ‘Serial Execution’?



Question No: 31      ( Marks: 3 )


Write three benefits of using VIEWS.

Question No: 32      ( Marks: 3 )


Shortly explain BYTE data field?



Question No: 33      ( Marks: 3 )


State the main purpose of index in relation with the queries executions.


Question No: 34      ( Marks: 5 )


ifferentiate between the cluster index and non cluster index ?




Question No: 35      ( Marks: 5 )


Consider the two relations,
Department (Dept_Code, Dep_Name,Dept_Head) and
Employee(Emp_ID,Emp_Name, Designation, DoB, Dept).

Write SQL statement to drop the primary key of Department relation? The fields in
Employee should reflect the removal in Department table.



Question No: 36      ( Marks: 5 )


Briefly explain rollback and rollforward.


No comments:

Post a Comment