Exam Details
Subject | rdbms | |
Paper | ||
Exam / Course | b.sc. (cs)/b.sc. (cs) (lateral) | |
Department | ||
Organization | Alagappa University Distance Education | |
Position | ||
Exam Date | May, 2018 | |
City, State | tamil nadu, karaikudi |
Question Paper
DISTANCE EDUCATION
B.Sc. (CS)/B.Sc. (Computer Science) (Lateral) DEGREE
EXAMINATION, MAY 2018.
RDBMS
(2007 onwards)
Time Three hours Maximum 100 marks
Answer any FIVE questions.
× 20 100)
1. Discuss about the Data base schema.
Describe about different user interfaces.
2. Explain Semantic issues, Navigation and efficiency
in relational model.
Discuss on data definition and data control
facilities.
3. Explain the overview of Oracle database
architecture.
Discuss about Client/Server systems.
4. List and explain all aggregate functions available in
oracle with appropriate syntax and example.
5. Explain SQL DDL and DML commands in detail
with examples.
Write the benefits of Oracle.
Sub. Code
35
DE-3621
2
wk10
6. Explain the following with examples:
Copying another table.
Dropping a table.
Discuss on Embedded SQL statements.
7. How is table modified and renamed? Explain with
examples.
Describe the languages supported by Oracle
precompiler.
8. Explain the features and advantages of DBMS in
detail.
Describe the concepts of Relational Model.
—————————
B.Sc. (CS)/B.Sc. (Computer Science) (Lateral) DEGREE
EXAMINATION, MAY 2018.
RDBMS
(2007 onwards)
Time Three hours Maximum 100 marks
Answer any FIVE questions.
× 20 100)
1. Discuss about the Data base schema.
Describe about different user interfaces.
2. Explain Semantic issues, Navigation and efficiency
in relational model.
Discuss on data definition and data control
facilities.
3. Explain the overview of Oracle database
architecture.
Discuss about Client/Server systems.
4. List and explain all aggregate functions available in
oracle with appropriate syntax and example.
5. Explain SQL DDL and DML commands in detail
with examples.
Write the benefits of Oracle.
Sub. Code
35
DE-3621
2
wk10
6. Explain the following with examples:
Copying another table.
Dropping a table.
Discuss on Embedded SQL statements.
7. How is table modified and renamed? Explain with
examples.
Describe the languages supported by Oracle
precompiler.
8. Explain the features and advantages of DBMS in
detail.
Describe the concepts of Relational Model.
—————————
Other Question Papers
Subjects
- application programs
- computer graphics
- internet programming
- lab ii — (c++ programming)
- lab iii — application programs
- lab iv (visual basic and oracle)
- lab v — java programming
- object oriented programming and c++
- operating systems
- rdbms
- visual programming