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.
—————————


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