CS403 Database Management Systems final term current paper spring July 2011

[Vuhelper]

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 )
Write any two similarities between materialized views and indexes?

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.