Karnataka State Open University (KSOU) 2009 Diploma Information Technology Database Management System I & II - Question Paper

Illllllllllllllllll    DIT 13

Diploma in Information Technology Annual (DIT) Examination, August 2009 DATABASE MANAGEMENT SYSTEM I & II

Illllllllllllllllll    DIT 13

Max. Marks : 90

Instruction : Answer all questions in Part - A, any five in Part - B and any three in Part - C.

PART - A

(10x2+5x1=25)

1.    What is a Data base ?

2.    What is a Report ?

3.    Name the main functions of a DBMS.

4.    What are Triggers ?

5.    What is Privileges and Roles ?

6.    What is the difference between Static and Dynamic files ?

7.    What is a Form ?

8.    What are Remote Procedure calls ?

9.    What is a Program Global Area ?

10.    What is Distributed Data base ?

11.    Explain the following terms :

1)    DBA

2)    ODBC

3)    SADB

4)    DML

5)    DDL

1.    Explain the ORACLE memory structures in detail.

2.    Explain the features of Import and Export of files in DBMS.

3.    What is record organization ? Explain the variable and fixed length record.

4.    What is hashing ? Describe different hashing with suitable examples.

5.    Narrate the ODBC and describe how it works.

6.    Explain the steps required to create and design queries in MS-ACCESS.

7.    What are the methods used to grant and cancel privileges in RDBMS ?

8.    What is the difference between SQL and PL/SQL ? Programmers prefer PL/SQL to SQL - Give reasons.

PART - C

Write short notes on any three of the following :

1.    Client/Server system

2.    Two tier Data base design

3.    Remote Procedure calls

4.    JDBC API Components

5.    Index Sequential File.

Attachment: karnataka-state-open-university--ksou--2009-diploma-information-technology-34207-1.pdf

Earning:   Approval pending.