M.C.A. (Semester III) (CBCS) Examination Nov/Dec-2018
Science
DBMS
iI
Time 2½ Hours Max. Marks: 70
Instructions: All questions are compulsory.
Figures to the right indicate full marks.
Q.1 Choose the correct answer 14
An abstraction concept for building composite object from their component
object is called
Specialization Normalization
Generalization Aggregation
4NF is designed to cope with
Transitive dependency Join dependency
Multi valued dependency None of these
Rollback of transactions is normally used to
recovers from transaction failure updates the transaction
retrieves old records repeats a transaction
The rule that a value of a foreign key must appear as a value of some specific
table is called a
Referential constraint Index
Integrity constraint Functional dependency
Every weak entity set can be converted into a storage entity set by
using generalization adding appropriate attributes
using aggregation none of the above
What is not true about a view?
It is a definition of a restricted portion of the database
It is a security mechanism
It is always updatable like any other table
All are true
If a transaction T has obtained an exclusive lock on item then T can
read Q write Q
both read and write Q write Q but not read Q
DROP is a statement in SQL.
Query Embedded SQL
DDL DCL
If two relations R and S are joined,
Then the non-matching tuples of both R and S are ignored in
left outer join right outer join
full outer join inner join
10) In SQL, testing whether a subquery is empty is done using
DISTINCT UNIQUE 8
NULL EXISTS
Page 2 of 2
SLR-SN-14
11) The key to represent relationship between tables is called
primary key composite key
foreign key secondary key
12) data type can store unstructured data.
Integer RAW
%TYPE None of the above
13) The database schema is written in
DDL DML
DCL None of the above
14) In an ER model, is described in the database by storing its data
Entity Attribute
Relationship Notation
Q.2 Answer the following (any four) 08
What is index?
What is strong entity?
What is trigger?
Define normalization.
What is PL/SQL?
Write short notes on (any two) 06
Composite key
Locks
ORDER BY clause
Q.3 Answer the following (any two) 08
Explain ALTER command with example.
Explain different advantages of DBMS.
Write a note on Client/Server.
Answer the following (Any one) 06
Explain Boyce Codd's normal form
Describe distributed database.
Q.4 Answer the following (any two) 10
Explain SELECT Clause with all options
Differentiate between SQL and PL/SQL
Explain UPDATE and DELETE command with example
Answer the following (Any one) 04
Describe commit, rollback with example.
Explain replication concept.
d
Q.5 Answer the following (any two) 14
Consider a following table:
Student (Roll NUMBER, Name CHAR(30), Course VARCHAR2(20),
Fees Number(6,2))
Apply following restrictions and write down the SQL command:
Add column named as Year with data type NUMBER and having size It
must be greater than 2000.
Increase the column size by 40 of Name with data type VARCHAR 2
Create the table Student_New with same structure using SELECT
Command
03
02
02
Draw an entity relationship diagram for Library Management System.
Explain ACID properties.