Page 264 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Unit 14: Application Development and Administration

Fill in the blanks: Notes
4. ............................. performs data integration tasks.
5. Data administrators .............................. from the business perspective and must have an
understanding of the business to be truly effective.

6. ............................ is the one area in which the Oracle DBA probably spends most of his or
her time.
7. The Web is the cornerstone of ......................................
8. A Web Database follows the .............................. database model.

9. The use of a .................................... to invoke a program at a remote site leads us to the role
of databases on the Web.
10. The ............................... is an incredibly useful tool because it abstracts away the need to
learn how to communicate with every type of database out there.

14.9 Review Questions

1. Explain about database for web.
2. What is chains of communication?

3. Using Perl 5 and the DBI module to communicate with databases.
4. Explain the DBI Module and API.
5. Define the role of administrator and also the process of adding and deleting a user to the
role of data administrator.
6. How will you access database through web? Explain with the help of suitable example.
7. Create a web page and also create database connect both web page and database.
8. How will you modify table with the help of web pages? Explain
9. Explain general DBI class methods in detail.

10. How will you install Perl? Explain step by step.

Answers: Self Assessment

1. (b) 2. (a)
3. (c) 4. Data Administrator
5. view data 6. Performance tuning

7. electronic commerce 8. client-server
9. Web browser 10. DBI Module

14.10 Further Readings

Books C.J. Date, Introduction to Database Systems, Pearson Education.
Elmasri Navrate, Fundamentals of Database Systems, Pearson Education.

LOVELY PROFESSIONAL UNIVERSITY 257