MC Which statement is NOT CORRECT? When using JDBC, 'PreparedStatement' is used for stored procedures. correct ODBC API always uses call-level statements. incorrect In the context of database APIs, proprietary APIs create an undesirable dependency between an application and the DBMS. incorrect In a centralized system architecture, all of the DBMS responsibilities are handled by one centralized entity. incorrect
MC Which statement is CORRECT? A client-server architecture using a file system causes performance and maintenance issues. correct One big advantage of JPQL is the fact that it supports compile-time checking and validation of queries incorrect JPQL queries can differ depending on the underlying DBMS used incorrect 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 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 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
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 Language-integrated queries correct None of these techniques incorrect ODBS incorrect
MC Which of the following is not a client-side scripting language? VBScript incorrect PHP correct Jscript incorrect JavaScript incorrect
MC Which statement is NOT CORRECT? Embedded database APIs can use late binding correct Embedded database APIs can use early binding incorrect Call-level database APIs can use early binding incorrect Call-level database APIs can use late binding incorrect
MC Which statement is CORRECT? SQLJ matured quickly, leading to a high adoption. incorrect Centralized system architecture was one of the first setups in computer technology and is still commonly present. incorrect Java Database Objects are agnostic to the technology of the data store used correct JDBC can only be used on Linux and Unix based systems incorrect
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 Many IDEs do not have SQLJ support incorrect JDBC uses SQLJ as an underlying technology correct
MC Which statement is NOT CORRECT? Call-level database APIs can use late binding incorrect Call-level database APIs can use early binding incorrect Embedded database APIs can use early binding incorrect Embedded database APIs can use late binding correct
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 application code needs to be modified every time a different driver needs to be used correct One drawback of ODBC is that performance can be worse compared to proprietary DBMS API's incorrect