MC Which statement is CORRECT? One big advantage of JPQL is its portability correct JPQL queries can differ depending on the underlying DBMS used incorrect One big advantage of JPQL is the fact that it supports compile-time checking and validation of queries incorrect The JPA query language (JPQL) supports more complex queries than SQL incorrect
MC Which statement is NOT CORRECT? Enterprise JavaBeans are components that establish a clear decoupling between business logic and client applications incorrect Session Beans represent an object-oriented representation of business entities and can be made persistent correct Enterprise JavaBeans extend the concept of Java Beans incorrect Three types of Enterprise JavaBeans exist, although one type is outdated now 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
MC Which statement is NOT CORRECT? CGI was one of the first technologies that allowed for the construction of dynamic web pages incorrect An important drawback of CGI was the fact that it could not handle database querying correct CGI programs can be written in almost any programming language incorrect An advantage of CGI was that it could deal with user-supplied input, such as provided through HTML-forms incorrect
MC Which JDBC driver type is implemented completely in Java and communicates directly with the vendor's DBMS through a network socket connection? Type 2 incorrect Type 1 incorrect Type 3 incorrect Type 4 correct
MC Which statement is NOT CORRECT? Enterprise JavaBeans extend the concept of Java Beans incorrect Three types of Enterprise JavaBeans exist, although one type is outdated now incorrect Enterprise JavaBeans are components that establish a clear decoupling between business logic and client applications incorrect Session Beans represent an object-oriented representation of business entities and can be made persistent correct
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;
} Language-integrated queries correct JDBC incorrect None of these techniques incorrect ODBS incorrect
MC Which statement is NOT 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 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 that the architecture is mostly native to Microsoft-based platforms 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
MC Which statement is CORRECT? The JPA query language (JPQL) supports more complex queries than SQL incorrect One big advantage of JPQL is the fact that it supports compile-time checking and validation of queries incorrect One big advantage of JPQL is its portability correct JPQL queries can differ depending on the underlying DBMS used incorrect