Tilka Manjhi Bhagalpur University 2007 M.C.A CS - 31 DBMS & ORACLE - Question Paper

COPYRIGHT RESERVED CS - 31

2007

Time : three hours

Full Marks : 80

Candidate are needed to provide their answers in
Their own words as far as possible.

The ques. are of equal value .
ans any 5 ques. in which
Q. No. one is compulsory.

1. Choose the accurate ans :

A. Collection of relationship of the identical kind is called a :
a. Relationship
b. Entity
c. E-R diagram
d. All

B. The data that is stored on secondary storage device is called .
a. Physical database
b. logical database
c. Both (a) & (b)
d. None

C. The model or abstraction of the objects of connection to the database is called
a. Conceptual database
b. Physical database
c. Logical database
d. All

D. Centralized control of the database is exerted by a person or group of person under the supervision of a high level administrator is called :
a. User
b. DBA
c. Programmer
d. All

E. The subset of the DML used to pose a query is known as :
a. Query language
b. DML
c. Programming language
d. All

F. The locking is done by a subsystem of the database management system usually
a. Locking
b. Locking manager
c. Locking system
d. All

G. A volatile storage failure can occur due to the spontaneous shut down of the computer , a few time referred to as :
a. System crash
b. Boot failure
c. Both (a) & (b)
d. None

H. Each row may contain multiple set of value for a few of the column , these multiple values in a signal row are also called :
a. Non- atomic values
b. Atomic values
c. Normalized
d. None

2. What is DBMS ? define the classification of DBMS user and DBMS Facilities and also define the advantage & disadvantage of DBMS ?

3. What is E-R diagram ?Draw a E-R diagram of Railway Reservation with the subsequent term :
a. Association
b. Relationship
c. Aggregation
d. Genralization

4. What is normalization ? define the 1NF to 5NF with example and obtain out a 3NF decomption of the subsequent relation scheame (Faculity ,Dean , Department ,chairperson , Rank ,Student )What are its advantage over unnormalizied table ?

5. Describe the 2 phase locking with an example and define the issue of concurrent transactions.

6. What is recovery ? How you can recovery any database ? define any one.

7. Describe the properties of a transaction and transaction states with a diagram .

8. Write short notes on any 2
a. Serialisiblity
b. Time stump - based order
c. DBA
d. Projection, selection,union,intersection, difference ,Cartesian product

9. Express the subsequent queries in SQL :
a. Display the employees whose job title is the identical as that of employee 7369.
b. Display the employee number and any other column (JOB) and any condition of employees
c. Display the 4 most senior employee in the company .
d. Display the JOB with the least avg. salary .
e. Display all the department that have a minimum salary greater than that of department 20 .
f. Display the row if an employee is a President and earns more than $ 1500 or if the employee is a salesman .
g. Display the most junior and most senior employee and obtain out the 2nd highest salary of these .
h. Write the queries for update , insert , delete , alter a table .

Earning:   Approval pending.