Exam Details
| Subject | rdbms | |
| Paper | ||
| Exam / Course | m.c.a./ m.c.a.(lateral) | |
| Department | ||
| Organization | Alagappa University Distance Education | |
| Position | ||
| Exam Date | May, 2017 | |
| City, State | tamil nadu, karaikudi |
Question Paper
DISTANCE EDUCATION
M.C.A./M.C.A. (Lateral) DEGREE EXAMINATION,
MAY 2017.
Third Semester
RDBMS
(2005 to 2010 Calendar year)
Time Three hours Maximum 100 marks
Answer any FIVE questions.
All questions carry equal marks.
20 100)
1. Define the following
data base
primary key
secondary key
foreign key.
What are the advantages of database?
2. Give the guidelines for preparing a good schema
and subschema.
Discuss the manipulative capabilities available in
DBMS.
3. How to navigate the relational model?
Discuss on data definition facilities available in a
relational model.
Sub. Code
33
DE-449
2
wk10
4. Explain the technique of improving efficiency in a
relational model.
What are the data control facilities available in a
relational model? Discuss them.
5. Mention the properties of relational database.
How networking system is taken care in oracle?
6. Describe the architecture of oracle database.
Discuss the logical structures in oracle database.
7. How queries are treated in oracle? Discuss on sub
queries.
Explain the technique of selecting distinct values
through queries.
8. With examples, show how a table can be modified
and renamed.
Mention the salient features of embedded SQL.
M.C.A./M.C.A. (Lateral) DEGREE EXAMINATION,
MAY 2017.
Third Semester
RDBMS
(2005 to 2010 Calendar year)
Time Three hours Maximum 100 marks
Answer any FIVE questions.
All questions carry equal marks.
20 100)
1. Define the following
data base
primary key
secondary key
foreign key.
What are the advantages of database?
2. Give the guidelines for preparing a good schema
and subschema.
Discuss the manipulative capabilities available in
DBMS.
3. How to navigate the relational model?
Discuss on data definition facilities available in a
relational model.
Sub. Code
33
DE-449
2
wk10
4. Explain the technique of improving efficiency in a
relational model.
What are the data control facilities available in a
relational model? Discuss them.
5. Mention the properties of relational database.
How networking system is taken care in oracle?
6. Describe the architecture of oracle database.
Discuss the logical structures in oracle database.
7. How queries are treated in oracle? Discuss on sub
queries.
Explain the technique of selecting distinct values
through queries.
8. With examples, show how a table can be modified
and renamed.
Mention the salient features of embedded SQL.
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