MC Which JDBC driver type is implemented completely in Java and communicates directly with the vendor's DBMS through a network socket connection? Type 4 correct Type 1 incorrect Type 3 incorrect Type 2 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;
} Language-integrated queries correct JDBC incorrect ODBS incorrect None of these techniques 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 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 can only be used on Linux and Unix based systems 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? Enterprise JavaBeans extend the concept of Java Beans 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 Three types of Enterprise JavaBeans exist, although one type is outdated now incorrect
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 can only be used on Linux and Unix based systems incorrect JDBC drivers come in different types, which come with different trade-offs in terms of portability and performance 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;
} None of these techniques incorrect Language-integrated queries correct JDBC incorrect ODBS 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 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 it not using an object-oriented paradigm incorrect
MC Which statement is CORRECT? JDBC uses SQLJ as an underlying technology incorrect One drawback of ODBC is that application code needs to be modified every time a different driver needs to be used incorrect Java Data Objects are agnostic to the technology of the data stored used. correct When using JDBC, we can differentiate between three types of drivers: the JDBC-ODBC bridge drivers, the DJBC native API drivers and the JDBC-NET drivers. incorrect
MC Which statement is NOT CORRECT? An advantage of CGI was that it could deal with user-supplied input, such as provided through HTML-forms incorrect CGI programs can be written in almost any programming language incorrect 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