Name of the Organization : Tamil Nadu Open University
Degree : Diploma in Database
Document Type : Sample Question Paper
Year : 2015
Subject : Fundamentals Of Information Technology

Website : http://www.tnou.ac.in/pqp/#1464003834724-b245cf45-d06e
Download Sample Question Papers :
DDB-01 : http://www.indianjobtalks.com/upload...4-DDB%9601.pdf
DDB-02 : http://www.indianjobtalks.com/upload...-DDB-02%20.pdf
DDB-03 : http://www.indianjobtalks.com/upload...-DDB-03%20.pdf
DDB-04 : http://www.indianjobtalks.com/upload...-DDB-04%20.pdf
DDB-05 : http://www.indianjobtalks.com/upload...-DDB-05%20.pdf

Diploma in Database Sample Question Paper :
Fundamentals Of Information Technology :
Time : 3 hours
Maximum marks : 75
PART A : (5 * 5 = 25 marks)
Answer any FIVE questions. :
1. Explain about system software.
2. Explain the functions of operating system.
3. Write short notes on Repeaters.
4. Explain about Internet capabilities.
5. Explain about System Software Utilities.
6. Write short notes on WWW.
7. Explain the role gateways in the network.

PART B : (5 * 10 = 50 marks)
Answer any FIVE questions. :
8. Discuss in detail about Computer Architecture.
9. Explain in detail about types of Operating System.
10. Discuss in detail about types of networks.
11. Discuss about web browsers.
12. What are the internet benefits to organization? Explain.
13. What are the special purpose application software? Explain.
14. Discuss in detail about problems on the internet.

Introduction To Database Management Systems :
PART A : (5 * 5 = 25 marks)
Answer any FIVE questions. :
1. What are the elements of DBMS? Explain.
2. What are the advantages of DBMS? Explain.
3. Explain sequential file organization.
4. Write short notes on relational model.
5. Explain properties of normalization.
6. Explain DDL.
7. Explain three view of data.

PART B : (5 * 10 = 50 marks)
Answer any FIVE questions.
8. Discuss in detail about three level architecture of DBMS.
9. Explain in detail about administration of DBMS.
10. Discuss in detail about Various Normalization techniques.
11. Discuss about Structure of Distributed database.
12. Discuss in detail about design of Distributed database.
13. Explain in detail about E- R Model.
14. Discuss in detail about Direct and Index Sequential file organization.

ORACLE :
Time : 3 hours
Maximum marks : 75
PART A : (5 * 5 = 25 marks)
Answer any FIVE questions.
1. Write short notes on SQL.
2. How to create view in SQL? Give an example.
3. How to drop trigger in SQL? Give an example.
4. Write short notes on atomic data model.
5. Write short notes on relational database.
6. Write short notes on Object name thesaurus.
7. Explain DDL.

PART B : (5 * 10 = 50 marks)
Answer any FIVE questions.
8. Discuss in detail about inserting records and selecting from abstract data types.
9. Explain in detail about types of triggers in PL/SQL.
10. Explain in detail about the important features of PL/SQ.
11. Discuss in detail about report creation process.
12. Explain in detail about DML command with examples.
13. Explain the Declaration and Executable commands section in PL/SQL.
14. Discuss in detail about business model with an example.