Java on Oracle interview questions

Post date: Mar 18, 2011 10:08:51 AM

1. What is JServer and what is it used for? Oracle JServer Option is a Java Virtual Machine (Java VM) which runs within the Oracle database server’s address space. Oracle also provides a JServer Accelerator to compile Java code natively. This speeds up the execution of Java code by eliminating interpreter overhead.

2. How does one install the Oracle JServer Option?Follow these steps to activate the Oracle JServer/ JVM option:

   1. Make sure your database is started with large java_pool_size (>20M) and shared_pool_size (>50M) INIT.ORA parameter values.

   2. Run the $ORACLE_HOME/javavm/install/initjvm.sql script from SYS AS SYSDBA to install the Oracle JServer Option on a database.

   3. Grant JAVAUSERPRIV to users that wants to use Java:

      1. SQL> GRANT JAVAUSERPRIV TO SCOTT;

   4. The rmjvm.sql script can be used to deinstall the JServer option from your database.

   5. Follow the steps in the Oracle Migrations Guide to upgrade or downgrade the JServer option from one release to

• • 1. another.

3. ce code into the database? Use the “CREATE OR REPLACE JAVA SOURCE” command or “loadjava” utility. Loaded code can be viewed by selecting from the USER_SOURCE view.

4. Why does one need to publish Java in the database? Publishing Java classes on the database makes it visible on a SQL and PL/SQL level. It is important to publish your code before calling it from SQL statements or PL/SQL code.

5. What is JDBC and what is it used for? JDBC is a set of classes and interfaces written in Java to allow other Java programs to send SQL statements to a relational database management system. Oracle provides three categories of JDBC drivers: (a) JDBC Thin Driver (No local Net8 installation required/ handy for applets), (b) JDBC OCI for writing stand-alone Java applications, (c) JDBC KPRB driver (default connection) for Java Stored Procedures and Database JSP’s.

6. How does one connect with the JDBC Thin Driver?

• 1. The the JDBC thin driver provides the only way to access Oracle from the Web (applets). It is smaller and faster than the OCI drivers, and doesn’t require a pre-installed version of the JDBC drivers.

     1. 1. import java.sql.*;

        2. class dbAccess {

        3.   public static void main (String args []) throws SQLException

        4.   {

        5.         DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());

        6.         Connection conn = DriverManager.getConnection

        7.              ("jdbc:oracle:thin:@hostname:1526:orcl", "scott", "tiger");

        8.                              // @machineName:port:SID,   userid,  password

        9.         Statement stmt = conn.createStatement();

        10.         ResultSet rset = stmt.executeQuery("select BANNER from SYS.V_$VERSION");

        11.         while (rset.next())

        12.               System.out.println (rset.getString(1));   // Print col 1

        13.         stmt.close();

        14.   }

        15. }

7. How does one connect with the JDBC OCI Driver? One must have Net8 (SQL*Net) installed and working before attempting to use one of the OCI drivers.

   2. 2. 1. import java.sql.*;

         2. class dbAccess {

         3.   public static void main (String args []) throws SQLException

         4.   {

         5.         try {

         6.               Class.forName ("oracle.jdbc.driver.OracleDriver");

         7.         } catch (ClassNotFoundException e) {

         8.               e.printStackTrace();

         9.         }

         10.         Connection conn = DriverManager.getConnection

         11.              ("jdbc:oracle:oci8:@hostname_orcl", "scott", "tiger");

         12.                      // or oci7 @TNSNames_Entry,    userid,  password

         13.         Statement stmt = conn.createStatement();

         14.         ResultSet rset = stmt.executeQuery("select BANNER from SYS.V_$VERSION");

         15.         while (rset.next())

         16.               System.out.println (rset.getString(1));   // Print col 1

         17.         stmt.close();

         18.   }

         19. }

8. How does one connect with the JDBC KPRB Driver? One can obtain a handle to the default or current connection (KPRB driver) by calling the OracleDriver.defaultConenction() method. Please note that you do not need to specify a database URL, username or password as you are already connected to a database session. Remember not to close the default connection. Closing the default connection might throw an exception in future releases of Oracle.

• • • 1. import java.sql.*;

      2. class dbAccess {

      3.   public static void main (String args []) throws SQLException

      4.   {

      5.         Connection conn = (new oracle.jdbc.driver.OracleDriver()).defaultConnection();

      6.         Statement stmt = conn.createStatement();

      7.         ResultSet rset = stmt.executeQuery("select BANNER from SYS.V_$VERSION");

      8.         while (rset.next())

      9.               System.out.println (rset.getString(1));   // Print col 1

      10.         stmt.close();

      11.   }

      12. }

9. What is SQLJ and what is it used for? SQLJ is an ANSI standard way of coding SQL access in Java. It provides a Java precompiler that translates SQLJ call to JDBC calls. The idea is similar to that of other Oracle Precompilers.

10. How does one deploy SQLJ programs? Use the sqlj compiler to compile your *.sqlj files to *.java and *.ser files. The *.ser files contain vendor specific database code. Thereafter one invokes the javac compiler to compile the .java files to *.class files. The *.class and *.ser files needs to be deployed.

11. What is JDeveloper and what is it used for? JDeveloper is the Oracle IDE (Integrated Development Environment) for developing SQLJ and JDBC programs, applets, stored procedures, EJB’s, JSP’s etc.

12. What is InfoBus DAC and what is it used for? InfoBus DAC (Data Aware Controls) is a standard Java extension used in JDeveloper to create data aware forms. It replaced the JBCL interface that were used in JDeveloper V1 and V2.

13. What is a JSP and what is it used for? Java Server Pages (JSP) is a platform independent presentation layer technology that comes with SUN’s J2EE platform. JSPs are normal HTML pages with Java code pieces embedded in them. JSP pages are saved to *.jsp files. A JSP compiler is used in the background to generate a Servlet from the JSP page.

14. What is the difference between ASP and JSP? Active Server Pages (ASP) is a Microsoft standard, which is easier to develop than Java Server Pages (JSP). However ASP is a proprietary technology and is less flexible than JSP. For more information about ASP, see the Oracle ASP FAQ.

15. How does one invoke a JSP? A JSP gets invoked when you call a *.jsp file from your Web Server like you would call a normal *.html file. Obviously your web server need to support JSP pages and must be configured properly to handle them.

16. How does a JSP gets executed? The first time you call a JSP, a servlet (*.java) will be created and compiled to a .class file. The class file is then executed on the server. Output produced by the servlet is returned to the web browser. Output will typically be HTML or XML code.

17. What is a Java Stored Procedure/ Trigger? A Java Stored Procedure is a procedure coded in Java (as opposed to PL/SQL) and stored in the Oracle database. Java Stored procedures are executed by the database JVM in database memory space. Java Stored Procedures can be developed in JDBC or SQLJ. Interfacing between PL/SQL and Java are extremely easy. Please note that Java Stored procedures are by default executed with invokers rights. PL/SQL procedures are by default executed with defines rights.