CS403- Database Management Systems current final term papers solve 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 will be deleted relating to a table if you use TRUNCATE command?

► all rows in a table

► indexes

► table structure and its columns

► constraints



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

Which of the following is not true about relational tables?

► Column values are of the same kind.

► Each row is unique.

► Each column must have a unique name.

► The sequence of rows is significant.



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

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

► In de-normalization it is required to add redundant data.

► It enhances the performance of DB



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

What is the maximum limit of keys in context with Indexed sequential files?

► 7

► 255

► 1

► 235



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

Structural constraints of a relationship type refer to

► identifying the owner entity type relevant to a given entity type

► whether the existence of an entity depends on it being related to another entity via the

relationship type.

► the role that a participating entity from the entity type plays in each relationship instance.

► the constraints applicable in granting access to tables, columns and views in a database

schema.



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

Which of the given techniques is/are used to improve query performance in database?

► Good File organization

► Indexing

► Both Indexing and Good File organization

► Select only one record per query



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

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

_______ is a control that users click to perform an action, set or toggle a state, or set an option.

► Button

► Text box

► Input form

► Report



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

_______is a control that enables users to select one option from an associated list; users can also type an option.

► Combo box

► Button

► Text box

► Static area



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

Partitions may become unbalanced in:

► Range partitioning

► Hash partitioning

► List partitioning

► Vertical partitioning



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

Only one type of constraint can be enforced in any table by CREATE command

► True

► False



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

ALTER TABLE exams

ALTER COLUMN Q_description varchar(50)

Syntax of ALTER TABLE is NOT correct.

► True

► False



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

In which of the following, Materialized Views are suitable

► Data warehousing

► Decision support

► Mobile computing

► All of the Given



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

A software package designed to store and manage databases

► Database

► DBMS

► Data model

► Data



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

A ____ relationship exists when an association is maintained within a single entity.

► unary

► ternary

► binary

► weak



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

Which of the following is NOT one of the ways of resolving deadlocks?

► Undoing all the updates made by the particular transaction which is the cause of deadlock.

► A message is passed to the victim and depending on the system the transaction may or may not be started again automatically.

► Picking a list of all previously completed transactions and undoing all the updates.

► Rollback `victim' transaction and restart it.



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 )

Name the two types of ordered Indices.

Dense Index
Sparse Index



Question No: 28 ( Marks: 2 )

State any two problems that can come up as a result of inconsistent database.

Uncommitted update
Inconsistent Analysis



Question No: 29 ( Marks: 2 )

Write the main purpose of NOT operator.

It used to negate any logical expression

Example:

Select * from students where Name is Null

Above command will bring all entries where name columns are having null value.

Select * from students where Name is NOT Null;

It will be reverse of our previous command and bring all those records which are not null in name colums.

It simply reverser any expression.



Question No: 30 ( Marks: 2 )

What is ‘Serial Execution’?

It is type of exaction where transitions are run in a sequence.

If we have two transactions first it will complete all the steps of first transaction and then steps of 2nd transaction will step.

A single transaction can consists of multiple steps. Those steps will run in a sequential order.

Question No: 31 ( Marks: 3 )

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

Index help to better recovery and retrieval of record from the database..
By building index on any attribute will help the queries to improve query performance.
multiple indexes provide flexibility to retrieve the data from various attributes.



Question No: 32 ( Marks: 3 )

What is the prupose of IN operator?

It us used to check whether any value fall in given set of values or not.
work whichwe perform with the help of multiple or condisiton can be easy done via IN operator.

Example: select * from Emp where Dept in (10,20,30);

By the use of IN operator we can get all records for dept = 10 ,20 and 30

We can combine No in operator with In operator to reverse the expression



Question No: 33 ( Marks: 3 )

What effect can be occurred if a transaction lacks durability?

Data can be inconsistence state, suppose if crash happened and in recovery rollback or commit is not possible in absence of durability.



Question No: 34 ( Marks: 5 )

Write the basic syntax of creating an INDEX.

CREATE INDEX indexname ON TableName (Last_Name);



Question No: 35 ( Marks: 5 )

What is the purpose of creating VIEWS in DBMS?

1.views can be used as security mechanism.
2.Present the data to user of their interest
3.Stop the access to unnecessary access to data to irrelevant person
4.simplify presentation complex extracted data for example data extracted from the multiple tables to the user.
5.updated automatically when any change occur to underlying tables

Question No: 36 ( Marks: 5 )

Write an SQL statement which displays a list of persons from the table named PERSON. The complete information of only those person should be displayed whose first name is ALI and the last name is AHMED;

SELECT * FROM Person where FirstName = ‘ALI’ and Lastname = ‘AHMED’;