Answer to Question #250217 in Databases | SQL | Oracle | MS Access for John

Question

THEORY: QUESTION 1

Explain to Top Management the various program categories that will enable you to operate a database in Oracle. Discuss at least three of these program categories.

THEORY: Question 2 (Marks: 10)

Identify and briefly explain the five features of PL/SQL that allow the developer to write effective code to manipulate a database.

Answer 1

1)

The program categories that can aid the operation of databases such as Oracle include enterprise manager, SQL *Plus, and resource manager.

The enterprise manager is a set of programs that offer an integrated solution to operate the database in a heterogeneous environment.

The SQL *PLUS is a set of tools or programs that enables the execution of SQL statements and PL/SQL blocks.  

The resource manager is crucial in ensuring the distribution of resources by controlling the execution schedule in the database. 

2)

The integration of SQL with PL/SQL offers support for both dynamic and static SQL. Dynamic SQL supports the embedding of DDL queries in PL/SQL blocks.

PL/SQL allows sending a whole block of statements to the database at once, reducing the network traffic and providing high performance.  

The ability of PL/SQL to query, update, and transform data in the database makes its application high productive. 

PL/SQL possesses features; like exception handling, hiding of data, and encapsulation that saves design and debugging times. 

PL/SQL applications are fully portable.