INFS 4400 Chapter 15 - Accessing Databases and Database APIs

Which statement is CORRECT? When using JDBC, 'PreparedStatement' is used for stored procedures. Call-level database APIs can use early binding Embedded APIS allow for syntax checks at compile time and early binding for efficient query retrieval. Therefore, they are widely used. JDBC was originally developed to be used in the C++ programming language

Call-level database APIs can use early binding

Which statement is NOT CORRECT? JDBC drivers come in different types, which come with different trade-offs in terms of portability and performance PHP is not a client-side scripting language. Early binding can only be used in combination with an embedded API. JavaScript is embedded in a web page.

Early binding can only be used in combination with an embedded API.

Which statement is NOT CORRECT? Embedded database APIs can use late binding Call-level database APIs can use early binding Call-level database APIs can use late binding Embedded database APIs can use early binding

Embedded database APIs can use late binding

Which statement is NOT CORRECT? JDBC uses SQLJ as an underlying technology SQL syntax can be checked before run-time when using SQLJ SQLJ uses a preprocessor to translate embedded SQL statements before invoking the Java compiler Many IDEs do not have SQLJ support

JDBC uses SQLJ as an underlying technology

Which statement is NOT CORRECT? Enterprise JavaBeans are components that establish a clear decoupling between business logic and client applications JDBC was originally developed to be used in the C++ programming language jOOQ and QueryDSL are examples of language integrated querying. The Java Persistence API is in itself just a specification defining a set of interfaces and annotations

JDBC was originally developed to be used in the C++ programming language

Which statement is NOT CORRECT? The Java Persistence API arose as part of the specification of version 3.0 of the EJB standard Java Database Objects are part of the Java Persistence API standard The Java Persistence API is in itself just a specification defining a set of interfaces and annotations Java Database Objects are agnostic to the technology of the data store used

Java Database Objects are part of the Java Persistence API standard

Which statement is NOT CORRECT? In a centralized system architecture, all of the DBMS responsibilities are handled by one centralized entity. JavaScript can not be used as a client-side scripting language. Call-level database APIs can use late binding A client-server architecture using a file system causes performance and maintenance issues.

JavaScript can not be used as a client-side scripting language.

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 JDBC None of these techniques ODBS

Language-integrated queries

Which statement is CORRECT? Just like ODBC, JDBC does not expose programmer-friendly object classes to work with Client-side scripting using Java is still widely adopted. Message-driven Java Beans are always stateless. 'ExecuteScalar' in ADO.NET is used when a query returns any set with multiple rows and/or columns.

Message-driven Java Beans are always stateless.

Which statement is NOT CORRECT? A Java Applet is a normal Java program that runs in a special sandbox. ODBC does not allow for stored procedures. Call-level database APIs can use late binding Java Data Objects are agnostic to the technology of the data stored used.

ODBC does not allow for stored procedures

Which statement is NOT CORRECT? Embedded database APIs can use early binding ODBC is largely Linux-based. Call-level database APIs can use early binding JavaScript is embedded in a web page.

ODBC is largely Linux-based.

Which statement is CORRECT? JPQL queries can differ depending on the underlying DBMS used The JPA query language (JPQL) supports more complex queries than SQL One big advantage of JPQL is its portability One big advantage of JPQL is the fact that it supports compile-time checking and validation of queries

One big advantage of JPQL is its portability

Which statement is NOT CORRECT? One drawback of ODBC is that application code needs to be modified every time a different driver needs to be used One drawback of ODBC is that performance can be worse compared to proprietary DBMS API's One drawback of ODBC is that the architecture is mostly native to Microsoft-based platforms One drawback of ODBC is it not using an object-oriented paradigm

One drawback of ODBC is that application code needs to be modified every time a different driver needs to be used

Which statement is NOT CORRECT? One drawback of ODBC is that the architecture is mostly native to Microsoft-based platforms One drawback of ODBC is it not using an object-oriented paradigm One drawback of ODBC is that application code needs to be modified every time a different driver needs to be used One drawback of ODBC is that performance can be worse compared to proprietary DBMS API's

One drawback of ODBC is that application code needs to be modified every time a different driver needs to be used

Which of the following is not a client-side scripting language? JavaScript VBScript PHP Jscript

PHP

Which statement is CORRECT? Java Session Beans are used to process messages. Early binding can only be used in combination with an embedded API. SQL syntax can be checked before run-time when using SQLJ The service provider is used by the ODBC API to communicate with the driver manager.

SQL syntax can be checked before run-time when using SQLJ

Which statement is NOT CORRECT? Session Beans represent an object-oriented representation of business entities and can be made persistent Three types of Enterprise JavaBeans exist, although one type is outdated now Enterprise JavaBeans are components that establish a clear decoupling between business logic and client applications Enterprise JavaBeans extend the concept of Java Beans

Session Beans represent an object-oriented representation of business entities and can be made persistent

Which JDBC driver type is implemented completely in Java and communicates directly with the vendor's DBMS through a network socket connection? Type 1 Type 2 Type 4 Type 3

Type 4

Which statement is NOT CORRECT? When using JDBC, all drivers have to be registered manually. JavaBeans is implemented in a n-tiered business application. Java Data Objects are agnostic to the technology of the data stored used. In the context of database APIs, late binding allows for more flexibility.

When using JDBC, all drivers have to be registered manually.

Which statement is CORRECT? In the context of database APIs, stored procedures can be used to combine late binding with an embedded API. Just like ODBC, JDBC does not expose programmer-friendly object classes to work with CGI programs can be written in almost any programming language ODBC is largely Linux-based.

cgi programs can be written in almost any programming language

Which statement is CORRECT? In the context of database APIs, stored procedures can be used to combine late binding with an embedded API. jOOQ and QueryDSL are examples of language integrated querying. 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. Client-side scripting using Java is still widely adopted.

jOOQ and QueryDSL are examples of language integrated querying.

Which statement is NOT CORRECT? An important drawback of CGI was the fact that it could not handle database querying CGI programs can be written in almost any programming language CGI was one of the first technologies that allowed for the construction of dynamic web pages An advantage of CGI was that it could deal with user-supplied input, such as provided through HTML-forms

An important drawback of CGI was the fact that it could not handle database querying