Solapur University Question Paper
M.C.A. (Part – I) (Semester – I) Examination, 2014
(Commerce and Management Faculty)
DATABASE MANAGEMENT SYSTEM (New)
Day and Date : Thursday, 8-5-2014 Max. Marks : 70
Time : 11.00 a.m. to 2.00 p.m.
Instructions : 1) All questions are compulsory.
2) Figure to the right indicates full marks.
1. Fill in the blanks : 10
1) ________ is memory buffer containing data and control information for a server
process.
a) System Global Area (SGA) b) Program Global Area (PGA)
c) Buffer Memory d) None of these
2) ________ executes the recovery when a user process on database fails.
a) Process Monitor (PMON)
b) Database
c) Database Write Process (DBWR)
d) All of these
3) CHECK constraint is used with
a) INSERT b) CREATE
c) DELETE d) Truncate
4) The blocks residing on the disk are referred to as ________
a) Disk buffer b) Physical block
c) Buffer block d) Logical buffer
5) A database log that is used mainly for security purpose is some times called
as ________
a) Audit Trail b) Database audit
c) System log d) Log security
P.T.O.
Seat
No.
SLR-GL – 8 -2-
6) SQL is a comprehensive database language and it is both ________
a) LLL and HLL b) DLL and HLL
c) LLL and DML d) DML and DDL
7) Network Attached Storage (NAS) is an alternative to
a) Storage Area Network (SAN) b) Local Area Network (LAN)
c) Wide Area Network (WAN) d) None of these
8) A subject S is not allowed to write an object O unless class (s) < = class (O),
this is known as
a) ACID property b) Simple security property
c) Star property d) Serializable property
9) What is the component of a DBMS that is responsible for storing, retrieving
and updating data ?
a) data dictionary b) data management engine
c) database engine d) query engine
10) The process to property define the database tables to provide flexibility,
minimize redundancy and ensure data integrity is called
a) class diagram b) data normalization
c) database design d) design rationalization
2. Answer in 1 – 2 sentences : (5×2)
i) ORDER BY clause
ii) Cursor
iii) Schema
iv) Normalization
v) DML.
3. Attempt any four from following : (4×5)
i) What do you mean by data model ? Explain the types of data model in detail.
ii) Explain the various security levels and threats to database along with control
measures.
-3- SLR-GL – 8
iii) Explain in detail shadow paging and its importance in crash recovery.
iv) Write a PL/SQL block for a reverse number.
v) Discuss function and procedure in detail along with any example.
vi) Discuss public key infrastructure in detail.
4. Attempt any two from following : (2×10)
i) What do you mean by concurrency control ? Discuss its schemes in detail .
ii) Discuss the failure classification in detail.
iii) List out Codd’s Rules.
5. What is the need of the normalization ? Explain the first three steps involved in
the normalization. Normalize the following data up to 3NF. (1×10)
Application Serial Number, FIRST Name, Surname, Middle Name, Address City,
Pin Code, Phone Number, E-mail, Course Name, Application Date, Academic
Year, Form Fee Receipt No., Form Fee Receipt Date, Form Fee Amount Payment
Mode, DD/Cheque Number.
_______________
M.C.A. (Part – I) (Semester – I) Examination, 2014
(Commerce and Management Faculty)
DATABASE MANAGEMENT SYSTEM (New)
Day and Date : Thursday, 8-5-2014 Max. Marks : 70
Time : 11.00 a.m. to 2.00 p.m.
Instructions : 1) All questions are compulsory.
2) Figure to the right indicates full marks.
1. Fill in the blanks : 10
1) ________ is memory buffer containing data and control information for a server
process.
a) System Global Area (SGA) b) Program Global Area (PGA)
c) Buffer Memory d) None of these
2) ________ executes the recovery when a user process on database fails.
a) Process Monitor (PMON)
b) Database
c) Database Write Process (DBWR)
d) All of these
3) CHECK constraint is used with
a) INSERT b) CREATE
c) DELETE d) Truncate
4) The blocks residing on the disk are referred to as ________
a) Disk buffer b) Physical block
c) Buffer block d) Logical buffer
5) A database log that is used mainly for security purpose is some times called
as ________
a) Audit Trail b) Database audit
c) System log d) Log security
P.T.O.
Seat
No.
SLR-GL – 8 -2-
6) SQL is a comprehensive database language and it is both ________
a) LLL and HLL b) DLL and HLL
c) LLL and DML d) DML and DDL
7) Network Attached Storage (NAS) is an alternative to
a) Storage Area Network (SAN) b) Local Area Network (LAN)
c) Wide Area Network (WAN) d) None of these
8) A subject S is not allowed to write an object O unless class (s) < = class (O),
this is known as
a) ACID property b) Simple security property
c) Star property d) Serializable property
9) What is the component of a DBMS that is responsible for storing, retrieving
and updating data ?
a) data dictionary b) data management engine
c) database engine d) query engine
10) The process to property define the database tables to provide flexibility,
minimize redundancy and ensure data integrity is called
a) class diagram b) data normalization
c) database design d) design rationalization
2. Answer in 1 – 2 sentences : (5×2)
i) ORDER BY clause
ii) Cursor
iii) Schema
iv) Normalization
v) DML.
3. Attempt any four from following : (4×5)
i) What do you mean by data model ? Explain the types of data model in detail.
ii) Explain the various security levels and threats to database along with control
measures.
-3- SLR-GL – 8
iii) Explain in detail shadow paging and its importance in crash recovery.
iv) Write a PL/SQL block for a reverse number.
v) Discuss function and procedure in detail along with any example.
vi) Discuss public key infrastructure in detail.
4. Attempt any two from following : (2×10)
i) What do you mean by concurrency control ? Discuss its schemes in detail .
ii) Discuss the failure classification in detail.
iii) List out Codd’s Rules.
5. What is the need of the normalization ? Explain the first three steps involved in
the normalization. Normalize the following data up to 3NF. (1×10)
Application Serial Number, FIRST Name, Surname, Middle Name, Address City,
Pin Code, Phone Number, E-mail, Course Name, Application Date, Academic
Year, Form Fee Receipt No., Form Fee Receipt Date, Form Fee Amount Payment
Mode, DD/Cheque Number.
_______________
0 comments:
Pen down your valuable important comments below