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 allows for a basic form of interactivity using HTML Forms. incorrect The Java Persistence API arose as part of the specification of version 3.0 of the EJB standard incorrect The JPA query language (JPQL) supports more complex queries than SQL correct JavaScript is embedded in a web page. incorrect
MC Which statement is NOT CORRECT? SQL injection is a drawback from embedded statements. correct In the context of database APIs, late binding allows for more flexibility. incorrect Many IDEs do not have SQLJ support incorrect A client-server architecture using a file system causes performance and maintenance issues. 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 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
MC Which statement is CORRECT? Just like ODBC, JDBC does not expose programmer-friendly object classes to work with incorrect JDBC was originally developed to be used in the C++ programming language incorrect JDBC drivers come in different types, which come with different trade-offs in terms of portability and performance correct JDBC can only be used on Linux and Unix based systems 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;
} None of these techniques incorrect JDBC incorrect Language-integrated queries correct ODBS incorrect
MC Which statement is NOT CORRECT? 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 Enterprise JavaBeans extend the concept of Java Beans incorrect
MC Which statement is NOT CORRECT? An important drawback of CGI was the fact that it could not handle database querying 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 advantage of CGI was that it could deal with user-supplied input, such as provided through HTML-forms incorrect
MC Which statement is CORRECT? SQL injection is a drawback from embedded statements. incorrect In a centralized system architecture, all of the DBMS responsibilities are handled by one centralized entity. correct OLE DB can be combined with ADO, in which OLE DB severs as a programming model on top of ADO. incorrect ODBC is largely Linux-based. incorrect
MC Which statement is CORRECT? 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 The JPA query language (JPQL) supports more complex queries than SQL incorrect