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:
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
PLEASE COMMENT ABOUT YOUR VISIT AND MY SITE
Note: Only a member of this blog may post a comment.