Oracle Database Programming With Java Ideas Designs And Implementations 1st Edition Ying Bai - Solutions

Unlock the full potential of "Oracle Database Programming With Java Ideas Designs And Implementations 1st Edition" by accessing comprehensive resources tailored for both students and instructors. Explore the online answers key and solutions manual, featuring step-by-step answers and solved problems to enhance your understanding. Delve into chapter solutions and the test bank to prepare thoroughly for exams. This instructor manual and textbook offer a wealth of knowledge, with free download options available for solutions in PDF format. Whether you're tackling questions and answers or seeking detailed guidance, this resource is your go-to companion for mastering database programming with Java.

Build a new project, OracleInsertStudent, and develop code for the StudentFrame Form window to insert a new student record into the Student Table in our sample database using the Java runtime object method. The new student’s record is:• Student ID: F78569 •Student Name: Williams Ford •GPA:
Refer to Section 8.4.5 to develop a Java Web application, JavaWebOracleStudent, to query the Student Table in our sample Oracle database, CSE_DEPT, using JavaServer pages and the JSP implicit session object.
Develop a Window-based client project, WinClientStudent, to consume the Web Service project WebAppStudent built in the last exercise to query the Student Table in our sample Oracle 18c XE database, CSE_DEPT.
A static query is called a Named Query, and it is defined statically with the help of annotation or XML before the entity class is created.(True/False)
Dynamic queries belong to queries in which the query strings are provided at runtime or created dynamically. All calls of Entity Manager. createQuery(queryString) are actually creating dynamic query objects. (True/False)
The java.awt package contains all basic and fundamental graphic user interface components. However, the javax.swing package contains extensions of java.awt, which means that all components in the javax.swing package have been built in model-view-controllermode. (True/False)
Only one method can be used to load and register a JDBC Driver during a project runs, which is to use the Class.forName() method. (True/False)
When using the getConnection() method in the DriverManager class to perform a database connection, the connection is made as soon as this instruction runs. (True/False)
The executeQuery() method will definitely return a query result, but the executeUpdate() method will never return any result. (True/False)
When a query is performed and a ResultSet is created, you need to retrieve the queried result from the ResultSet object by using a suiTable getXXX() method. (True/False)
The advantage of using the getObject() method is that a returned datum, which is stored in a ResultSet object with an unknown data type, can be automatically converted from its Oracle data type to the ideal Java data type. (True/False)
The SQL92 syntax can only be used for calling an Oracle stored procedure, not for an Oracle package or stored procedure. (True/False)
One has to use the registerOutParameter() method to register any output parameter in a query statement to allow the CallableStatement to know that there is an OUT parameter in that query, and the returned value should be stored in that parameter. (True/False)
When using a Java RowSet object to query data, one has to create an instance of the RowSet Implementation class, not the RowSet class itself, since all RowSet classes are abstract classes. (True/False)
One can run and test any Oracle package with a stored procedure directly in the Oracle SQL Developer environment. (True/False)
The sequence to perform a data query from a database using a JDBC driver isa. Connect to database, load JDBC driver, perform the query, get result from ResultSetb. Perform the query, connect to database, load JDBC driver, get result from ResultSetc. Get result from ResultSet, connect to database,
One needs to use a object as an image holder, a object as a tool to display an image and a class as a monitor to coordinate image processing.a. Canvas, MediaTracker, Graphicsb. Graphics, MediaTracker, Canvasc. Canvas, Graphics, MediaTrackerd. MediaTracker, Graphics, Canvas
Generally, a connection url contains three parts, , and , for the database to be connected.a. Subname, sub-protocol, sub-protocol nameb. Protocol name, sub-protocol, subnamec. Protocol name, sub-protocol name, subnamed. Protocol, sub-protocol, subname
To identify the data type returned by the execute() method, one needs to .a. Use the getResultSet() methodb. Use the getUpdateCount() methodc. Use either of themd. Use both of them
The cursor in a ResultSet object can be moved by executing the method.a. move()b. first()c. next()d. last()
A cursor in the Oracle database can be mapped to a(n) data type.a. jdbc.oracle.CURSORb. oracle.jdbc.OracleTypes.CURSORc. oracle.jdbc.CURSORd. jdbc.CURSOR
A object, which contains all pieces of necessary information about the returned data stored in a ResultSet instance, is returned when the method is executed.a. getMetaData(), ResultSetMetaDatab. ResultSet, getMetaData()c. getResultSet, ResultSetd. ResultSetMetaData, getMetaData()
A CallableStatement can either return a object and multiple ResultSet objects by using the executeQuery() method or return nothing by using the method.a. ResultSetMetaData, getResultSet()b. Cursor, getCursor()c. Object, getObject()d. ResultSet, execute()
There are two parts in an Oracle Package: anda. Specification, bodyb. Definition, specificationsc. Body, specificationd. Specification, execution
The reason of using ResultSet, instead of CachedRowSet, to get a column with the Blob data type from an Oracle database isa. The former is easyb. The latter is fasterc. The former cannot return any column with the Blob data typed. The latter cannot return any column with the Blob data type
List five steps to build a data query from a Java database application project to a relational database using the Java runtime object method.
Develop a method by adding code into the LogIn button Click event handler in the LogInFrame class in the project OracleSelectFaculty to allow users to try the login process only three times. A warning message should be displayed and the project should exit after three failed login attempts.
UsePL-SQL to create a package, Student_Course, in the Oracle SQL Developer. The package contains a stored procedure namedSelectStudentCourse() with two positional parameters,a. The input student name, studentName, with VARCHAR2 data type.b. The output cursor, StudentCourse, containing all course_id
Use the Java CallableStatement method to develop a data query from the Student and StudentCourse Tables with the StudentFrame class in the OracleSelectFaculty project (the project file can be found in the folder ClassDB Projects\Chapter 6 that is located in the Students folder at the accompanying
To use the Java runtime method to insert an image into the Oracle database, the setString() method should be used. (True/False)
When using the JFileChooser object to select an image, the returned image is a Java File object, and one needs to convert it to a Byte[] array to be inserted into a column in a database Table. (True/False)
When converting an image file to a Byte[] array, one can use a system method, readAllBytes(). (True/False)
To avoid possible duplicated records being inserted into a database, the Insert button on a Frame Form should be enabled after a desired record has been inserted. (True/False)
By setting the Concurrency Type property as UpdaTable to a ResultSet object, that ResultSet object can be used to perform data insert, update and delete actions to a database. (True/False)
To use the UpdaTable ResultSet object to delete a record from a database, only one step is enough, which is to use the deleteRow() method of the ResultSet class. (True/False)
When using the UpdaTable ResultSet object to update a record in a database, only one step is enough, which is to call the updateRow() method. (True/False)
When perform data manipulation using the Java runtime object method, one can use either the executeUpdate() or execute() method. (True/False)
A default ResultSet object is updaTable and has a cursor that can move either forward or backward. (True/False)
To insert a new record into a database using the UpdaTable ResultSet method, one needs first to move the cursor to an insert row that is a blank row and is not a part of the ResultSet but related to the ResultSet. (True/False)
When using the UpdaTable ResultSet object to update a record in a database, two steps are needed: .a. Insert data in ResultSet, update the data in databaseb. Update data in ResultSet, copy change to databasec. Delete data from ResultSet, copy change to databased. Select data in ResultSet, update
When finished building a stored procedure with Oracle SQL Developer, one needs to save the stored procedure by .a. Going to the File > Save All menu itemb. Building the procedurec. Executing the procedured. Updating the procedure
When using an UpdaTable ResultSet to perform data manipulations, two parameters can be used to setup properties of a ResultSet object: .a. Forward-only, UpdaTableb. Scroll-sensitive, Read-onlyc. ResultSet Type, Concurrency Type of a ResultSetd. ResultSet Type, UpdaTable Type
Which of the following create ResultSet protocols is correct?a. Statement createStatement(int resultSetType, int resultSetConcurrency).b. PreparedStatement prepareStatement(String sql, int resultSetType, int resultSet Concurrency).c. CallableStatement prepareCall(String sql, int resultSetType, int
To update a record using the UpdaTable ResultSet, one needs to use steps, and they are: .a. 1, UpdateXXX()b. 2, UpdateXXX() and UpdateRow()c. 3, UpdateXXX(), UpdateCursor() and UpdateRow()d. 4, MoveToRow(), UpdateXXX(), UpdateCursor() and UpdateRow()
To insert a new record using the UpdaTable ResultSet, one needs to use steps, and they are: .a. 1, insertRow()b. 2, moveToInsertRow(), insertRow()c. 3, moveToInsertRow(), updateXXX(), insertRow()d. 4, moveToCursor(), moveToInsertRow(), updateXXX(), insertRow()
When building a stored procedure to perform a data insertion action, the order of the input parameters must be with the order of the related .a. Identical, data columnb. Different, data columnc. Same or different, data rowd. Identical, data Table
By using which of the following static constant values can we set an UpdaTable Result object that has a cursor that can move either forward or backward?a. ResultSet.TYPE_FORWARD_ONLYb. ResultSet.TYPE_SCROLL_INSENSITIVEc. ResultSet.CONCUR_UPDATabled. ResultSet.TYPE_SCROLL_SENSITIVE
By using which of the following static constant values can we set an UpdaTable Result object whose contents can be updated?a. ResultSet.TYPE_FORWARD_ONLYb. ResultSet.TYPE_SCROLL_INSENSITIVEc. ResultSet.CONCUR_UPDATabled. ResultSet.TYPE_SCROLL_SENSITIVE
When building an Oracle stored procedure to update a record in a database, each input parameter .a. Can have a different name from the associated column name in the databaseb. Can have the same name as the associated column name in the databasec. Must have the same name as the associated column
List six steps to use the Java runtime object to perform data manipulations against our target database.
List three steps to insert a new record into a database using the UpdaTable ResultSet method.
Figure 7.43 shows a stored procedure, UpdateStudent. Develop and build a new project, OracleUpdateStudent, and add code into the Update button event handler on the StudentFrame form class to call this stored procedure to update a student record for the Student Table in our sample Oracle database
When a Servlet is created, the init() method is called to do the initialization for the Web server. (True/False)
When a request is received by the Servlet, it creates two objects; request and response. Then the Servlet sends these two objects to the service() method, in which these two objects are further processed. (True/False)
Conventional Web applications are built with a Servlet as a Web container and JSF pages as Web clients. (True/False)
Unlike a common gateway interface (CGI), a Servlet can be used to create dynamic Web pages during the server-client communication process. (True/False)
To interface to the client to get user data, most of the time, the Web server calls the getParameter() method that belongs to the request object. (True/False)
The so-called implicit objects in JSP are objects that are automatically available in JSP because they are automatically instantiated as the project runs. (True/False)
Among those implicit objects, request, response and session are most popular objects and are often used in the interface between clients and servers. (True/False)
To use a Java bean, the JSP provides three basic tags: (True/False)
To embed any Java code into a HTML page, the JSP directive must be used. (True/False)
Navigation from one page to another can be done in two ways. One is directly to use code by writing a JSP tag such as or an HTML hyperlink in the JSF file. Another way that is provided by JSF is to use the application configuration resource file faces-config.xml to build navigation rules.
The tag is used to define a navigation .a. Sourceb. Terminalc. Destinationd. None of these
To bind a Java bean’s property to an associated attribute of a tag in the JSF page, one needs to use the .a. Expression language (EL) with the syntax #(managedbean.property)b. Expression language (EL) with the syntax #{managedbean.property}c. Expression language (EL) with the syntax
A typical Java bean class should contain .a. All propertiesb. All properties, setter methodsc. All properties, setter and getter methodsd. All properties, setter and getter methods as well as user-defined methods
Java beans need to be conFigured in the Web configuration file faces-config.xml so that the implementation can automatically create a new of the beans as needed.a. Statementb. Methodc. Instanced. Project
Before you can use a Servlet such as FacesServlet on the server side from a Web browser, you need to map the FacesServlet to a path in your deployment descriptor file .a. Web pagesb. WEB INF filec. Web configuration filed. web.xml
To separate presentation and business logic, we can use pages to present our GUI and the to store our data to perform business-related logic.a. HTML, Java help classb. XML, JSF pagesc. JSP, Java beansd. JSF, JSP pages
All JSF tag components are represented by a tree of components whose root is UIViewRoot, which is represented by the tag. All JSF component tags must be enclosed in this tag.a. UIComponentb. UITreec. d.
A JSP form, which is submitted to the Web server when a button is clicked, is represented by the tag. The tags representing the form components, such as textfields and buttons, must be nested inside this tag.a. <f:form>b. <h:form>c. <h:view>d. <f:view>
If the required attribute is set to true, this means that the inputText .a. Cannot be emptyb. Must be filled with something by the userc. Both of thesed. Neither of these
A Web application is a dynamic extension of a web or application server. There are two types of Web applications: and.a. Dynamic, staticb. Single-tier, multi-tierc. Web server, web clientd. Presentation-oriented, service-oriented
Provide a brief description of a Java EE three-tier Web application with EJB.
What is the difference between a Java EE with EJB and a Java EE without EJB?
What are popular Java EE components?
Provide a brief description to illustrate the interaction between a Web client and a Web application.
Provide a brief description of Java EE containers.
Unlike Java Web applications, Java Web Services provide an automatic way to search, identify and return the desired information required by the user through a set of methods installed in the Web server. (True/False)
Java Web services provide graphic user interfaces (GUIs) to enable users to access Web services via the Internet. (True/False)
Web Services can be considered a set of methods installed in a Web server and can be called by computer programs installed on the clients through the Internet. (True/False)
Two popular Java Web services are: REST-based and SOAP-based services, and both are supported by NetBeans IDE. (True/False)
Both Web service models, JAX-WS and JAX-RPC, are popular and updated models used in Web service development. (True/False)
Compared with REST-based service, SOAP-based Web services are more suiTable for heavyweight applications using complicated operations and for applications requiring sophisticated security and reliability. (True/False)
Unlike ASP.NET Web services, a Java SOAP-based Web service project is included in a Java Web application project in which the Web service can be deployed based on an appropriate container. (True/False)
To access a Web service, one does not have to call any operation defined in the Web service. (True/False)
Before one can call a Web service operation, a Web service reference must have been established for the client project. (True/False)
It is unnecessary to update a Web service each time when consuming it in a client project; however, one must deploy that Web service each time when starting it from the NetBeans IDE. (True/False)
In a SOAP-based Java Web Service, the SOAP means .a. Statement Object Access Protocolb. Simplified Object Access Protocolc. Simple Object Access Protocold. Structure Object Access Protocol
In a REST-based Java Web Service, the REST means .a. REpresentational State Transferb. REpresentational State Transmitterc. REpresentational Status Transferd. Rapid Essential State Transfer
When using a REST-based Web service, only four methods are available: .a. INPUT, OUTPUT, POST, and DELETEb. SAVE, PUT, POST, and DELETEc. GET, EXECUTE, POST, and DELETEd. GET, PUT, POST, and DELETE
The protocol used in the REST-based Web services is.a. FTPb. XMLc. HTTPd. TCP/IP
To effectively find, identify and return the target information required by computer programs, a SOAP-based Web Service needs the following components, .a. XML and WSDLb. SOAP, UDDI and WSDLc. UDDI, XML and SOAPd. WSDL, XML, UDDI and SOAP
SOAP is a simple -based protocol to help applications developed in different platforms and languages exchange information over .a. HTML, HTTPb. XML, HTTPc. FTP, TCP/IPd. XML, Internet
In WSDL terminology, each Web Service is defined as a and each Web method is defined as an abstract .a. Method, functionb. Service, operationc. Endpoint, functiond. Port, operation
SOAP is used to wrap and pack the data tagged in the format into the messages represented in the protocol.a. XML, SOAPb. HTML, HTTPc. FTP, TCP/IPd. SOAP, XML
When building a Java Web service, a that contains Web container for the must be built first.a. Web service, Web applicationb. Web client, Web consuming projectc. Web service, Web client projectd. Web application, Web service
To consume a Web service, a must be established in the client project.a. Web service referenceb. Web service operationc. Web service directoryd. All of them
Provide a brief description of the advantages of using a SOAP-based Web service.
Illustrate the structure and components of SOAP-based Web services.
Provide a brief description of the procedures of building a typical SOAP-based Web service project.

Showing 1 - 100 of 292

Oracle Database Programming With Java Ideas Designs And Implementations 1st Edition Ying Bai - Solutions

Step by Step Answers