Bharathiar University 2008-4th Sem B.C.A Computer Application Bachelor of , - - Relational Database Management System - Question Paper

Bachelor of Computer Application (BCA), APR - 2008

Relational Database Management System (Sem 4)

1. DML stands for _____________.
a. Data Multiplicative Language
b. Data Manipulated Language
c. Data Manipulation Language
d. Data Multi-level Language
1.0 Mark(s)
2. Logic design of the database is called _____________.
a. Database schema
b. Data values
c. Database instance
d. Relationship schema
1.0 Mark(s)
3. QBE stands for _____________.
a. Query Based Example
b. Query By Elements
c. Query Based Entity
d. Query By Example
1.0 Mark(s)
4. _____________ is an elementary form of integration constraints.
a. Value constraints
b. Domain constraints
c. Relational constraints
d. Variable constraints
1.0 Mark(s)
5. _____________ is an aggregate function.
a. choose
b. Union
c. Min
d. OR
1.0 Mark(s)
6. _____________ Normal Forms allowing nontrivial functional dependencies.
a. Third
b. First
c. BCNF
d. 4th
1.0 Mark(s)
7. The transformation of a nested relation into a INF is
a. Nesting
b. Combining
c. Normalizing
d. Unnesting
1.0 Mark(s)
8. ODBC stands for _____________.
a. Open DataBase Control
b. Open DataBase Collections
c. Open DataBase Connectivity
d. Open DataBase Concepts
1.0 Mark(s)
9. Multimedia data are usually stored in _____________ configuration.
a. ROM
b. Secondary memories
c. Hard disk
d. RAID
1.0 Mark(s)
10. _____________ is a hypertext language.
a. XML
b. SGML
c. WML
d. HGML
1.0 Mark(s)

11. a. discuss the various views in Data in the database.

Or

b. explain the concept of outer join of 2 relations with an example.
5.0 Mark(s)

12. a. discuss the parts of the SQL language.

Or

b. explain the significances of Triggers.
5.0 Mark(s)

13. a. define the object structure in the object oriented data model.

Or

b. discuss the different kinds of inheritance in the object relational data model.
5.0 Mark(s)

14. a. Briefly explain the problems of data servers.

Or

b. discuss the system failure modes of a distributed database system.
5.0 Mark(s)

15. a. explain the different kinds of spatial databases.

Or

b. discuss the concept of web interfaces to databases.
5.0 Mark(s)

16. a. define the different kinds of data models.

Or

b. define any 4 fundamental operations of relational algebra.
8.0 Mark(s)

17. a. explain any 4 aggregate functions of SQL.

Or

b. define the functional dependencies with examples.
8.0 Mark(s)

18. a. discuss the Boyce-Codd normal form and the 4th normal form.

Or

b. explain the reference tuples in the object relational data models.
8.0 Mark(s)

19. a. define the design problems of parallel systems.

Or

b. define the concept of deadlock handling in the distributed database systems.
8.0 Mark(s)

20. a. define the concept of data warehousing.

Or

b. Elaborately explain the multimedia databases.
8.0 Mark(s)

Earning:   Approval pending.