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. Select
b. Union
c. Min
d. OR
1.0 Mark(s)
6. _____________ Normal Forms allowing nontrivial functional dependencies.
a. Third
b. First
c. BCNF
d. Fourth
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. Explain the different views in Data in the database.
Or
b. Discuss the concept of outer join of two relations with an example.
5.0 Mark(s)
12. a. Explain the parts of the SQL language.
Or
b. Discuss the significances of Triggers.
5.0 Mark(s)
13. a. Describe the object structure in the object oriented data model.
Or
b. Explain the various types of inheritance in the object relational data model.
5.0 Mark(s)
14. a. Briefly discuss the issues of data servers.
Or
b. Explain the system failure modes of a distributed database system.
5.0 Mark(s)
15. a. Discuss the various types of spatial databases.
Or
b. Explain the concept of web interfaces to databases.
5.0 Mark(s)
16. a. Describe the various types of data models.
Or
b. Describe any four fundamental operations of relational algebra.
8.0 Mark(s)
17. a. Discuss any four aggregate functions of SQL.
Or
b. Describe the functional dependencies with examples.
8.0 Mark(s)
18. a. Explain the Boyce-Codd normal form and the fourth normal form.
Or
b. Discuss the reference tuples in the object relational data models.
8.0 Mark(s)
19. a. Describe the design issues of parallel systems.
Or
b. Describe the concept of deadlock handling in the distributed database systems.
8.0 Mark(s)
20. a. Describe the concept of data warehousing.
Or
b. Elaborately discuss the multimedia databases.
8.0 Mark(s)
KEYWORDS:2008 BHARATHIAR UNIVERSITY B.C.A COMPUTER APPLICATION BACHELOR OF COMPUTER APPLICATION (BCA), APR - 2008 - RELATIONAL DATABASE MANAGEMENT SYSTEM,BHARATHIAR UNIVERSITY,BHARATHIAR UNIVERSITY EXAM RESULTS,BHARATHIAR UNIVERSITY MBA,BHARATHIAR UNIVERSITY RESULTS,BHARATHIAR UNIVERSITY DISTANCE EDUCATION,BHARATHIAR UNIVERSITY SYLLABUS,BHARATHIAR UNIVERSITY MBA-CENTRE ,BHARATHIAR UNIVERSITY SCHEDULE OF EXAMINATIONS ,BHARATHIAR UNIVERSITY ADMISSION,BHARATHIAR UNIVERSITY COURSES,BHARATHIAR UNIVERSITY ACADEMIC, BHARATHIAR UNIVERSITY DEPARTMENTS,BHARATHIAR UNIVERSITY RESEARCH,BHARATHIAR UNIVERSITY MAIL,BHARATHIAR UNIVERSITY QUESTION PAPERS,BHARATHIAR UNIVERSITY COUNSELLING DATES,BHARATHIAR UNIVERSITY RE-EVALUATION RESULTS,
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. Select
b. Union
c. Min
d. OR
1.0 Mark(s)
6. _____________ Normal Forms allowing nontrivial functional dependencies.
a. Third
b. First
c. BCNF
d. Fourth
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. Explain the different views in Data in the database.
Or
b. Discuss the concept of outer join of two relations with an example.
5.0 Mark(s)
12. a. Explain the parts of the SQL language.
Or
b. Discuss the significances of Triggers.
5.0 Mark(s)
13. a. Describe the object structure in the object oriented data model.
Or
b. Explain the various types of inheritance in the object relational data model.
5.0 Mark(s)
14. a. Briefly discuss the issues of data servers.
Or
b. Explain the system failure modes of a distributed database system.
5.0 Mark(s)
15. a. Discuss the various types of spatial databases.
Or
b. Explain the concept of web interfaces to databases.
5.0 Mark(s)
16. a. Describe the various types of data models.
Or
b. Describe any four fundamental operations of relational algebra.
8.0 Mark(s)
17. a. Discuss any four aggregate functions of SQL.
Or
b. Describe the functional dependencies with examples.
8.0 Mark(s)
18. a. Explain the Boyce-Codd normal form and the fourth normal form.
Or
b. Discuss the reference tuples in the object relational data models.
8.0 Mark(s)
19. a. Describe the design issues of parallel systems.
Or
b. Describe the concept of deadlock handling in the distributed database systems.
8.0 Mark(s)
20. a. Describe the concept of data warehousing.
Or
b. Elaborately discuss the multimedia databases.
8.0 Mark(s)
KEYWORDS:2008 BHARATHIAR UNIVERSITY B.C.A COMPUTER APPLICATION BACHELOR OF COMPUTER APPLICATION (BCA), APR - 2008 - RELATIONAL DATABASE MANAGEMENT SYSTEM,BHARATHIAR UNIVERSITY,BHARATHIAR UNIVERSITY EXAM RESULTS,BHARATHIAR UNIVERSITY MBA,BHARATHIAR UNIVERSITY RESULTS,BHARATHIAR UNIVERSITY DISTANCE EDUCATION,BHARATHIAR UNIVERSITY SYLLABUS,BHARATHIAR UNIVERSITY MBA-CENTRE ,BHARATHIAR UNIVERSITY SCHEDULE OF EXAMINATIONS ,BHARATHIAR UNIVERSITY ADMISSION,BHARATHIAR UNIVERSITY COURSES,BHARATHIAR UNIVERSITY ACADEMIC, BHARATHIAR UNIVERSITY DEPARTMENTS,BHARATHIAR UNIVERSITY RESEARCH,BHARATHIAR UNIVERSITY MAIL,BHARATHIAR UNIVERSITY QUESTION PAPERS,BHARATHIAR UNIVERSITY COUNSELLING DATES,BHARATHIAR UNIVERSITY RE-EVALUATION RESULTS,