Questions and Answers of Database Systems Design Implementation

Provides a brief description of how to establish a Web service reference for a given client project to enable the latter to consume that Web service.
Explain the operational sequence of adding a Web service operation into a method in a client project to enable the latter to call that operation.
Using the structure shown in Figure 9.117, build a Web service project, WebAppStudent, and replace the Java runtime object with the Java managed bean to perform a data query against the Student Table
Develop a Web-based client project, WebClientStudent, to consume the Web Service project WebAppStudent built in Exercise 6 to query the Student Table in our sample Oracle 18c XE database,
The database development process involves project planning, problem analysis, logical design, physical design, implementation and maintenance. (True/False)
Duplication of data creates problems with data integrity. (True/False)
If the primary key consists of a single column, then a Table in 1NF is automatically in 2NF. (True/False)
A Table is in first normal form if there are no repeating groups of data in any column. (True/False)
When a user perceives the database as made up of Tables, it is called a network model. (True/False)
The entity integrity rule states that no attribute that is a member of the primary (composite) key may accept a null value. (True/False)
When creating data Tables for the Oracle database, a blank field can be kept as a blank without any value in it. (True/False)
To create data Tables in an Oracle Server database, the data type for an image field can be a binary large object (BLOB). (True/False)
The name of each data Table in an Oracle Server database must be prefixed by the keyword or (True/False)
Each relational database Table can contain multiple primary keys but only one unique foreign key. (True/False)
There are many advantages to using an integrated database approach over a file processing approach. These includea. Minimizing data redundancyb. Improving securityc. Data independenced. All of the
The entity integrity rule implies that no attribute that is a member of the primary key may accept aa. Null valueb. Integer data typec. Character data typed. Real data type
Reducing data redundancy will lead toa. Deletion anomaliesb. Data consistencyc. Loss of efficiencyd. None of the above
keys are used to create relationships among various Tables in a databasea. Primaryb. Candidatec. Foreignd. Composite
In a small university, the Computer Science Department has six faculty members. However, each faculty member belongs to only the computer science department. This type of relationship is calleda.
Client server databases have several advantages over file server databases. These includea. Minimizing chances of crashesb. Provision of features for recoveryc. Enforcement of securityd. Efficient
One can create the foreign keys between Tablesa. Before any Table can be createdb. When some Tables are createdc. After all Tables are createdd. With no limitations
To create foreign keys between Tables, first one must select the Table that contains a key and then select another Table that has a keya. Primary, foreignb. Primary, primaryc. Foreign, primaryd.
The data type nvarchar(50) in an Oracle Server database is a string witha. Limited length up to 50 lettersb. Fixed length of 50 bytesc. A certain number of lettersd. Varying length
For data Tables in an Oracle Server database, a blank field must bea. Indicated by NULL Avoidedb. Kept as a blankc. Indicated either by NULL or a blankd. Indicated by NULL
What are the advantages to using an integrated database approach over a file processing approach?
Define entity integrity and referential integrity. Describe the reasons for enforcing these rules.
Entities can have three types of relationships, one-to-one, one-to-many and many-to-many. Define each type of relationship. Draw ER diagrams to illustrate each type of relationship.
List all steps to create foreign keys between data Tables for the Oracle 18c Express Edition database in the Oracle SQL Developer Modeler. Illustrate those steps by using a real example, for
List all steps to create foreign keys between data Tables for the Oracle 18c Express Edition database in the Oracle SQL Developer Modeler. Illustrate those steps by using a real example, for
JDBC is standard Java Database Connectivity, and the JDBC API can be considered the Java Database Connectivity Application Programming Interface.(True/False)
The JDBC API is not the only component included in a JDBC.(True/False)
The JDBC API is composed of a set of classes and interfaces used to interact with databases from Java applications.(True/False)
JDBC drivers are implementation dependent, which means that different applications need different drivers.(True/False)
The core of the JDBC 4.0 API provides standard JDBC components that are located in the java.sql package, and some additional components such as JNDI and JTS are defined in the JDBC 4.0 Standard
One can establish a database connection by directly calling the Driver class method connect().(True/False)
To load and register a JDBC driver, two popular methods can be used: either using the Class.forName() method or creating a new instance of the Driver class.(True/False)
Three components can be used to build an Oracle statement: Statement, Prepared-Statement and CallableStatement.(True/False)
To pick up the execution results, one can use the executeQuery() and executeUpdate() methods. The former returns an integer, and the latter returns a ResultSet.(True/False)
There are four types of JDBC drivers, and a Type IV driver is a pure Java driver with fast running speed and high efficiency in data actions.(True/False)
Generally, the JDBC API perform the following three functionsa. Connect to database, load JDBC driver, perform the queryb. Perform the query, connect to database, load JDBC driverc. Get result from
To establish a connection with a DataSource object, you need toa. Create a DataSource object, set properties and use this objectb. Set properties, set up a connection and perform queriesc. Create a
To build and run an Oracle statement, the following components can be utilizeda. Statementb. Statement, PreparedStatementc. Statement, PreparedStatement, CallableStatementd. None of them
To execute an Oracle statement to get a query result, the method(s) should be used.a. executeQuery()b. executeUpdate()c. execute() and executeUpdate()d. executeQuery() and execute()
To perform an insert, update or delete operation, the method(s) should be used.a. executeUpdate()b. executeQuery()c. executeQuery() and execute()d. executeQuery() and executeUpdate()
The method can be used to either pick up a query result or update a datum.a. executeUpdate()b. execute()c. executeQuery()d. None of them
A distributed transaction is defined as accessing data source(s) at location(s).a. Single, singleb. Multiple, samec. Multiple, differentd. Single, multiple
The execute() method cana. Not return any resultsb. Return some resultsc. Be used either to return a result or not return any resultd. None of these
A CachedRowSet class is a that caches its data ina. Connected RowSet, databaseb. Disconnected RowSet, databasec. Connected RowSet, memoryd. Disconnected RowSet, memory
The ResultSet object can be created by either executing the or method, which means that the ResultSet instance cannot be created or used without executing a query operation first.a. executeQuery(),
Provide a detailed description of the JDBC API, which includes:a. The definition of the JDBC and JDBC APIb. The components defined in the JDBC API, including all classes and interfacesc. The
Provide a brief discussion of database connection using the JDBC API, which includes:a. Two popular methods used to establish a connectionb. Operational procedure to establish a connectionc. How to
Explain the function of three different statement execution methods: executeQuery(), executeUpdate() and execute(). For each method, provide a way to retrieve the execution result.
Provide a brief introduction to the four types of JDBC drivers and their architecture.
Provide a brief introduction to the connection pooling API.
JDBC applications are made of two models: two-tier and three-tier model. (True/False)
In a three-tier model, the application is located on a Web server and the database is installed on a database server. The user can access the application server through a Web browser with a GUI
To load and register a driver, creating a new instance of the Driver class method is better than using the Class.forName() method. (True/False)
When establishing a database connection, the DriverManager.getConnection() method is a better method than the Driver.connect() method. (True/False)
A JDBC URL is composed of three parts: network host name, database server name and port number. (True/False)
By using three methods defined in the Connection interface, createStatement(), prepareStatement() and prepareCall(), one can create three statement objects: Statement, PreparedStatement and
The Statement object can be used to perform both static and dynamic data queries. (True/False)
To create a ResultSet object, you can either use the getResultSet() method or call the executeQuery() method. (True/False)
The executeQuery() method returns an integer that equals the number of rows that have been returned, and the executeUpdate() method returns a ResultSet object containing the run results. (True/False)
The next() method defined in the ResultSet interface can be used to move the cursor that points to the current row to the next row in a ResultSet. (True/False)
The object provides methods for the creation of Statement objects that will be used to execute Oracle statements in the next step.a. Statementb. Connectionc. DriverManagerd. Driver
The relationship between three statement objects is: the is a subclass of the that is a subclass of the .a. CallableStatement, PreparedStatement, Statementb. Statement, CallableStatement,
The method returns a(n) , and the method returns a(n) .a. execute(), ResultSet, executeQuery(), integerb. executeQuery(), integer, execute(), nothingc. executeUpdate(), integer, executeQuery(),
The object is used to execute a static Oracle query, but the object is used to execute a dynamic Oracle query with IN and OUT parameters.a. PreparedStatement, Statementb. Statement,
Both interfaces, PreparedStatement and CallableStatement, are used to perform dynamic Oracle statements; however, performs queries with only parameters, but calls stored procedures with both and
By using the __________ method, we can get a collection of information about the structure and properties of the returned ResultSet object.a. getResultSetMetaData()b. getResultSet()c. getMetaData()d.
To create a ____________ object, one needs to call the ___________ method defined in the Connection interface.a. ResultSet, getMetaData()b. Statement, getStatement()c. PreparedStatement,
The ____________ interface allows you to discover the structure of Tables and properties of columns, but the _______________ interface enables you to dynamically determine properties of the RDBMS.a.
When using a CallableStatement object to run a stored procedure, you need to register the __________ parameters by using the _____________ method.a. IN/OUT, getParameters()b. IN,
The placeholder used in the setXXX() and the registerOUTParameter() methods is used to ___________________.a. Indicate the location of the input or output parametersb. Reserve spaces for input or
Provide a brief description of the seven basic steps to use JDBC.
Translate the seven steps to Java code.
Provide a detailed description of the JDBC three-tier model and its function.
Provide a brief description of the JDBC URL.
Explain the operational sequence of retrieving results from a returned ResultSet object.
Explain the relationship between three Statement objects, and illustrate why and how the CallableStatement object can use the setXXX() methods defined in the PreparedStatement interface.
Explain the advantages of using JDBC metadata for Java database applications.
The Apache NetBeans Platform is a broad Swing-based framework on which you can base large desktop applications. (True/False)
Each distinct feature in a NetBeans Platform application can be provided by a distinct NetBeans module, which is comparable to a plugin. (True/False)
An Apache NetBeans module is a group of Java classes that provides an application with a specific feature. (True/False)
The NetBeans IDE is an open-source integrated development environment, and it only supports development of all Java application types. (True/False)
Three main modules included in the NetBeans IDE are: NetBeans Profiler, GUI Design Tool and NetBeans JavaScript Editor. (True/False)
The Apache NetBeans IDE is mainly composed of NetBeans Open-Source IDE and NetBeans Platform. (True/False)
A Java Class Library is only a skeleton Java class library without a main class, but it can be executed itself. (True/False)
JavaFX, which is a kind of script language, is a Java platform for creating and delivering rich Internet applications. But starting from JDK 9, this platform has been removed from the JDK and no
Like VisualStudio. NET, one can build a Java Ant application by adding a JFrame Form and use the Palette to add any GUI component to that form. (True/False)
The Java EE differs from the Java SE in that it adds libraries that provide functionality to deploy fault-tolerant, distributed, multi-tier Java software, based largely on modular components running
Each distinct feature in a NetBeans Platform application can be provided by a distinct NetBeans module, and an Apache NetBeans module is a: .a. Java SE applicationb. Group of classes with specific
The Apache NetBeans IDE is an open-source integrated development environment, and it supports development of all Java application types, which include .a. Java desktop applicationsb. Mobile and Web
Three main modules included in the Apache NetBeans IDE are .a. JEUS 7 application server, JBoss Application Server 6, Caucho Resin 4.0b. Java EE, Java SE, Mavenc. NetBeans Profiler, GUI design tool,
The major Java Bean used to handle or process messages is called .a. Session Beanb. Notification Beanc. Message-Driven Beand. Manager Bean
The just works as a view for the GlassFish application server and sets up a connection between the application server and the Session Bean in the Web tier.a. Java EE 8b. Enterprise Java Beansc.
To add new components or tools into the NetBeans IDE, one can use .a. The JFrame toolb. Pluginsc. The PHP toold. JavaFX
The Apache NetBeans IDE is composed of two components, which are: .a. NetBeans Platform and NetBeans modulesb. NetBeans modules and Java EEc. NetBeans Profiler and GUI design toolsd. NetBeans
The most popular Java GUI containers include: .a. JFrame Form, JDialog Form, JPanel Formb. JPanel Form, JPlugins Form, JCanvas Formc. JPanel Form, JMaven Form, PHP Formd. JFrame Form, JField Form,
To display an image in JFrame Form, one needs to use a object.a. JImageb. JPanelc. Canvasd. JPicture

Showing 100 - 200 of 292