MC	Which statement is CORRECT?	Early binding can only be used in combination with an embedded API. 	incorrect	APIs often communicate over a network socket. 	correct	Embedded APIS allow for syntax checks at compile time and early binding for efficient query retrieval. Therefore, they are widely used. 	incorrect	A universal API completely solves the portability issues. 	incorrect	
MC	Which statement is CORRECT?	JDBC can only be used on Linux and Unix based systems	incorrect	One big advantage of JPQL is the fact that it supports compile-time checking and validation of queries	incorrect	Call-level database APIs can use early binding	correct	JDBC was originally developed to be used in the C++ programming language	incorrect	
MC	Which of the following statements on database system architecture is correct?	A three-tier architecture can be achieved from a two-tier architecture by decoupling the application logic and putting it into a separate layer. 	correct	A tiered system architecture consists of only PCs. 	incorrect	In a centralized system architecture, the workstation performs a limited amount of processing (like presentation). 	incorrect	When it makes sense to couple an application's workflow with its look and feel, a fat server should be used. 	incorrect	
MC	Which of the following statements on ODBC is correct?	ODBC does not allow for stored procedures.	incorrect	ODBC API always uses call-level statements. 	correct	The service provider is used by the ODBC API to communicate with the driver manager. 	incorrect	ODBC is largely Linux-based. 	incorrect	
MC	Which statement is NOT CORRECT?	The Java Persistence API arose as part of the specification of version 3.0 of the EJB standard	incorrect	Java Database Objects are part of the Java Persistence API standard	correct	Java Database Objects are agnostic to the technology of the data store used	incorrect	The Java Persistence API is in itself just a specification defining a set of interfaces and annotations	incorrect	
MC	Which statement is CORRECT?	JDBC was originally developed to be used in the C++ programming language	incorrect	Java Session Beans are used to process messages. 	incorrect	When using JDBC, 'PreparedStatement' is used for stored procedures.	incorrect	CGI programs can be written in almost any programming language	correct	
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 2	incorrect	Type 3	incorrect	Type 1	incorrect	
MC	Which statement is NOT CORRECT?	Client-side scripting is widely adopted.	correct	Client-side scripting allows for more flexibility than CGI.	incorrect	JavaScript is embedded in a web page.	incorrect	A Java Applet is a normal Java program that runs in a special sandbox.	incorrect	
MC	Which statement is NOT CORRECT?	Java Data Objects are agnostic to the technology of the data stored used.	incorrect	SQLJ uses a preprocessor to translate embedded SQL statements before invoking the Java compiler	incorrect	PHP is a server-side scripting language.	correct	OLE DB extends ODBC by providing support for non-relational databases. 	incorrect	
MC	Which statement is CORRECT?	Early binding can only be used in combination with an embedded API. 	incorrect	Java Session Beans are used to process messages. 	incorrect	OLE DB extends ODBC by providing support for non-relational databases. 	correct	In the context of Java Beans, the business tier contains the database system and the data stores. 	incorrect