M.C.A. (Semester III) (CBSC) Examination Oct/Nov-2017
Science
DBMS
Day Date: Saturday, 18-11-2017 Max. Marks: 70
Time: 02.30 PM to 05.00 PM
Instructions: Question No.1 and 2 are compulsory.
Attempt any 3 questions from Q.NO. 3 to Q. No. 7
Figures to the right indicate full marks.
Q.1 Select most correct alternative: 10
clause is an additional filter that is applied to the result.
Select Group-by
Having Order by
A top-to-bottom relationship among the items in a database is
established by a
Hierarchical schema Network schema
Relationship Schema All of the above
In an ER model, is described in the database by storing its
data.
Entity Attribute
Relationship Notation
The candidate key is that choose to identify each row uniquely is
called
Alternate Key Primary Key
Foreign Key None of the above
data type can store unstructured data.
RAW CHAR
NUMERIC VARCHAR
The database schema is written in
HLL DML
DDL DCL
is the process of organizing data into related tables.
Normalization Generalization
Specialization None of the above
is preferred method for enforcing data integrity.
Constrains Stored Procedure
Triggers Cursors
To change column value in a table the command can be used.
Create Insert
Alter Update
10) Which of the following is/are the DDL statements?
Create Drop
Alter All of the above
Page 2 of 2
SLR-SM-18
State whether following statements are True or False: 04
A primary key if combined with a foreign key creates Parent-Child
relationship between the tables that connect them.
The relational model is based on the concept that data is organized
and store in two-dimensional tables called relations.
A Strong entity does not have a distinguishing attribute if its own and
mostly are dependent entities, which are part of some another entity.
Data elements in the database can be modified by changing the data
dictionary.
Q.2 Write a short note on following: 06
Index
DROP command
Answer the following: 08
Explain BETWEEN predicate with example.
Explain different users of DBMS.
Q.3 Answer the following
Explain primary key and foreign key with example. 07
Explain nested queries with example. 07
Q.4 Answer the following:
Describe commit, rollback and save point with example. 07
Explain different states of transaction. 07
Q.5 Answer the following:
Write a note on log based recovery. 07
Solve the following queries based on the schema:
Emp ename, age, salary)
Works did, pcttime)
Dept dname, budget, managerid
Write an SQL statement to add "John Doe" as an employee
With eid=101, age=32 and salary=15,000.
Write an SQL statement to give every employee a 10% raise.
Write an SQL statement to delete the "Toy" department.
03
02
02
Q.6 Answer the following:
Discuss how the recovery from catastrophic failures is handled? 07
Differentiate between Network Data Model and Hierarchical Data Model. 07
Q.7 Answer the following:
Explain the properties of transaction. 07
Explain joins with example. 07