Exam Details
| Subject | rdbms | |
| Paper | ||
| Exam / Course | m.c.a./ m.c.a.(lateral) | |
| Department | ||
| Organization | Alagappa University Distance Education | |
| Position | ||
| Exam Date | December, 2017 | |
| City, State | tamil nadu, karaikudi |
Question Paper
DISTANCE EDUCATION
M.C.A./M.C.A. (Lateral) DEGREE EXAMINATION,
DECEMBER 2017.
Third Semester
RDBMS
(2005 to 2010 Calendar Year)
Time Three hours Maximum 100 marks
Answer any FIVE questions.
All questions carry equal marks.
x 20 100)
1. Explain the concept of Database with an example.
Explain in detail about Schema and Subschema.
2. Describe the features and advantages of DBMS.
Explain the mapping operations on Relational
Model.
3. Discuss on Data Definition facilities in DBMS.
Explain the concept of Relational model.
4. Explain the Architecture of Oracle Database.
Explain in detail about Client/Server systems.
5. Explain the following: i. Physical files ii. Network
systems.
Explain Data Access SQL Commands in Oracle.
Sub. Code
33
DE-2752
2
Sp 6
6. How to join multiple tables in Oracle? Explain.
Explain Subqueries in Oracle with examples.
7. Explain the following: Create table Update
table.
Explain indexes in Oracle.
8. Explain the need for database objects in Oracle.
Write a detailed note on Embedded SQL
statements.
M.C.A./M.C.A. (Lateral) DEGREE EXAMINATION,
DECEMBER 2017.
Third Semester
RDBMS
(2005 to 2010 Calendar Year)
Time Three hours Maximum 100 marks
Answer any FIVE questions.
All questions carry equal marks.
x 20 100)
1. Explain the concept of Database with an example.
Explain in detail about Schema and Subschema.
2. Describe the features and advantages of DBMS.
Explain the mapping operations on Relational
Model.
3. Discuss on Data Definition facilities in DBMS.
Explain the concept of Relational model.
4. Explain the Architecture of Oracle Database.
Explain in detail about Client/Server systems.
5. Explain the following: i. Physical files ii. Network
systems.
Explain Data Access SQL Commands in Oracle.
Sub. Code
33
DE-2752
2
Sp 6
6. How to join multiple tables in Oracle? Explain.
Explain Subqueries in Oracle with examples.
7. Explain the following: Create table Update
table.
Explain indexes in Oracle.
8. Explain the need for database objects in Oracle.
Write a detailed note on Embedded SQL
statements.
Other Question Papers
Subjects
- .net frame works
- .net lab
- accounting and financial management
- agent based intelligent system
- c-sharp (c#)
- communication skills
- compiler design
- computer applications
- computer networks
- data mining and warehousing
- data warehousing and mining
- distributed computing
- image processing and analysis
- internet programming
- lab : vi — algorithm and shell programming
- lab v — rdbms
- lab vii –– internet programming
- lab viii — network lab
- lab x — compiler design
- lab–ix : visual c++
- middleware technology
- mobile communications
- multimedia systems
- multimedia tools lab
- network lab
- neural networks
- object oriented analysis and design
- open source architecture
- open source programming lab
- operating systems
- rdbms
- resource management techniques
- software engineering
- software project management
- unix and shell programming
- visual programming
- visual programming lab
- web technology
- web technology lab