M.C.A.(Science) (Sem-III) (CGPA)Examination, 2017
DATABASE MANAGEMENT SYSTEM
Day Date: Tuesday, 25-04-2017 Max. Marks: 70
Time: 02.30 PM to 05.00 PM
Instructions Q.1 and Q.2 are compulsory
Attempt any Three Questions from Q.3 to Q.7
Figures to the right indicate full marks.
Q.1 Choose the correct alternatives 10
A top-to-bottom relationship among the items in a database
is established by a …………….
Hierarchical schema Network schema
Relational Schema All of the above
Data independence means………
Programs are not dependent on the physical attributes of
data
Programs are not dependent on the logical attributes of
data
Both A and B
None of these
Transaction processing is associated with everything below
except.
Producing detail, summery, or exception reports
Recording a business activity
Confirming an action or triggering a response
Maintaining data
…….. is the complex search criteria in the where clause.
Sub string Drop Table E
Predict Predicate
………… is preferred method for enforcing data integrity.
Constraints Stored Procedure E
Packages Cursors
To eliminate duplicate rows……….is used
NODUPLICATE ELIMINATE E
DISTINCT None of these
……. Character function can be used to return a specified
portion of a character String.
INSTR SUBSTRING E
Page 2 of 2
SUBSTR POS
…….. provides option for entering SQL queries as execution
time, rather than at the development stage.
PL/SQL SQL*Plus E
SQL Dynamic SQL
A…….. represents the number of entities to which another
entity can be associated
Mapping cardinality Table E
Schema Information
10) A…… allows to make copies of the database periodically to
help in the cases of crashes disasters.
Recovery utility Backup utility E
Monitoring utility Data loading utility
State whether following statement are true or false: 04
The view is used to provide the security.
You can return more than one value using stored procedure.
Database contains only one table.
When no any applicable value that time stored the null value.
Q.2 Answer the following 14
Define concept of aggregation? Explain two application of
aggregation.
Why there is need of sub-queries with example
Q.3 Answer the following: 14
Explain concurrency control method showing serial and
concurrent transaction.
Write PL/SQL block to generate auto generated primary key
using trigger.
Q.4 Answer the following 14
What is cursor? Explain with suitable example.
What is Deadlock? Explain deadlock prevention mechanism.
Q.5 Answer the following 14
What is stored procedure? Explain IN, OUT parameters with
suitable example.
Explain the term with examples
1. Relation 2. Domain 3. Tuple
Q.6 Answer the following 14
What is Transaction? Write about different states of example.
Explain concept of Crash Recovery.
Q.7 Answer the following
Explain different Join operation of relation algebra with example.
What are roles? How roles and privileges are granted and revoke.