Chapter 26. Using Java with PL/SQL

Beginner

Q:

26-1.

(c). Oracle8i’s Java Virtual Machine is called Aurora (Aur-ora…get it?)

Q:

26-2.

The statements are:

  1. False. Java stored procedures are fundamentally different from Java applets because they are compiled and stored in the database.

  2. False. Oracle8i allows you to call Java procedures from PL/SQL, allowing you to take advantage of the hundreds of prebuilt (and third-party) classes.

  3. True. You can call Java stored procedures from SQL or PL/SQL via PL/SQL wrappers, from Java applets via JDBC or SQLJ, from Pro*C via OCI (the Oracle Call Interface), and from Visual Basic or Oracle Forms via ODBC (Open Database Connectivity).

  4. False. Java is a true object-oriented language; PL/SQL, while it has some OO properties, is primarily a procedural language.

  5. True. The Java foundation classes contain a rich set of operations, such as file I/O and networking, that you can exploit in your PL/SQL programs.

  6. False. Java and PL/SQL are equals in the database.

  7. False. Java is controlled by Javasoft, a division of Sun Microsystems. While Java is more open than PL/SQL, it is still (for now, at any rate) under the control of a single entity.

  8. True. Java was designed as a “write once, run anywhere” language, so it’s fairly easy to run on a variety of platforms with very little effort.

  9. False. Java programs are compiled into an intermediate form called bytecode that is interpreted by a Java Virtual Machine such as Aurora.

  10. True. Java, like C and C++, is case-sensitive.

Q:

26-3.

(b). ...

Get Oracle PL/SQL Programming: A Developer's Workbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.