MC Which statement is NOT CORRECT? Embedded database APIs can use early binding incorrect Embedded database APIs can use late binding correct Call-level database APIs can use early binding incorrect Call-level database APIs can use late binding incorrect
MC Which statement is NOT CORRECT? One drawback of ODBC is that the architecture is mostly native to Microsoft-based platforms incorrect One drawback of ODBC is that application code needs to be modified every time a different driver needs to be used correct One drawback of ODBC is it not using an object-oriented paradigm incorrect One drawback of ODBC is that performance can be worse compared to proprietary DBMS API's incorrect
MC Which statement is CORRECT? JDBC drivers come in different types, which come with different trade-offs in terms of portability and performance correct JDBC was originally developed to be used in the C++ programming language incorrect JDBC can only be used on Linux and Unix based systems incorrect Just like ODBC, JDBC does not expose programmer-friendly object classes to work with incorrect
MC Which statement is NOT CORRECT? Enterprise JavaBeans are components that establish a clear decoupling between business logic and client applications incorrect Enterprise JavaBeans extend the concept of Java Beans incorrect Three types of Enterprise JavaBeans exist, although one type is outdated now incorrect Session Beans represent an object-oriented representation of business entities and can be made persistent correct
MC Which statement is NOT CORRECT? The Java Persistence API arose as part of the specification of version 3.0 of the EJB standard incorrect The Java Persistence API is in itself just a specification defining a set of interfaces and annotations incorrect Java Database Objects are part of the Java Persistence API standard correct Java Database Objects are agnostic to the technology of the data store used incorrect
MC Which statement is CORRECT? The JPA query language (JPQL) supports more complex queries than SQL incorrect JPQL queries can differ depending on the underlying DBMS used incorrect One big advantage of JPQL is its portability correct One big advantage of JPQL is the fact that it supports compile-time checking and validation of queries incorrect
MC Which statement is NOT CORRECT? CGI was one of the first technologies that allowed for the construction of dynamic web pages incorrect CGI programs can be written in almost any programming language incorrect An important drawback of CGI was the fact that it could not handle database querying correct An advantage of CGI was that it could deal with user-supplied input, such as provided through HTML-forms incorrect
MC Which of the following is not a client-side scripting language? JavaScript incorrect VBScript incorrect Jscript incorrect PHP correct
MC Which JDBC driver type is implemented completely in Java and communicates directly with the vendor's DBMS through a network socket connection? Type 1 incorrect Type 2 incorrect Type 3 incorrect Type 4 correct
MC Which statement is NOT CORRECT? SQLJ uses a preprocessor to translate embedded SQL statements before invoking the Java compiler incorrect SQL syntax can be checked before run-time when using SQLJ incorrect JDBC uses SQLJ as an underlying technology correct Many IDEs do not have SQLJ support incorrect
MC Which database access technique does the following C# statement illustrate?
public void Example() {
DataClassesContext dc = new DataClassesContext();
var q =
from a in dc.GetTable()
where a.CustomerName.StartsWith("Seppe")
select a;
dataGrid.DataSource = q;
} JDBC incorrect ODBS incorrect Language-integrated queries correct None of these techniques incorrect
MC Which statement is NOT CORRECT? The JPA was meant as a replacement for entity beans in EJB 2.0 incorrect JPA relies heavily on annotations and convention-over-configuration incorrect JPA uses its own internal query language, but supports SQL as well incorrect All these statements are correct correct