Which of the following is NOT true of cursors ? A. A cursor is read only. B. A cursor is advanced using a fetch command. C. A cursor is used to iterate through tables or query results. D. A cursor is updateable.

Which of the following is NOT part of the three tier application architecture ? A. Application Server B. Web Server C. DNS Server D. Database Server

Which of the following orders SQL environment concepts from largest to smallest? A. schema, table, user, host B. host, user, schema, table C. db2 instance, db2 database, schema, table D. db2 instance, schema, table, db2 database

Which of the following statements are NOT true? A. SQL clients can be on the same machine as a SQL server. B. SQL clients must connect to a SQL server to access data in the SQL server. C. SQL commands performed during a connection form a session. D. SQL clients and SQL servers must be on different machines. Which of the following is NOT required when integrating a SQL environment and a host language ? A. A way to pass data from SQL environment to host language environment. B. A way to pass data from host language environment to SQL environment. C. Data types in SQL environment must have corresponding and compatible data types in host language environment. D. Data types in host language environment must be exactly the same as data types in SQL environment. Why is a cursor construct necessary in embedded SQL in C programs ? A. A cursor is required to iterate through a result set of which the size is not known in advance. B. A cursor is required so that it can be moved around the screen using a mouse. C. A cursor construct is not necessary, but is a convenient shorthand. D. A cursor construct is required because the C language does not have arrays. Which of the following is NOT true of dynamic SQL queries? A. The SQL is not fully specified at application compile time. B. The SQL is fully specified at application runtime. C. The SQL may incorporate additional parameters based on user input at application runtime. D. Dynamic SQL queries are always vulnerable to SQL injection attacks. Which of the following is NOT done when the application calls the API to prepare a SQL statement. A. The SQL statement is parsed and checked for syntax errors. B. The query execution plan is executed. C. The SQL query is compiled into a query execution plan. D. The query optimizer is called to find the optimal query execution plan for the query.