问题:单选题Application A holds an Update lock on a single row and application B is trying to read that row. If both applications are using isolation level UR, which of the following will occur?()A Application B will read the row.B Applications A and B will cause a deadlock situation.C Application B will wait until application A releases the Update lock.D Application A will be terminated so that application B can read the row.
Saturday, April 13, 2024
问题:单选题Which of the following is a feature of a unit of work?()A It applies to a single data server.B It is a recoverable sequence of operations.C Its value can be queried from the system catalog tables.D It begins when the application connects to the data server.
Wednesday, March 6, 2024
问题:单选题How does DB2 protect the integrity of indexes when data is updated?()A Locks are acquired on the data.B Locks are acquired on index keys.C Locks are acquired on index pages.D Locks are acquired on index pointers.
Monday, January 22, 2024
问题:单选题A user invoking a user-defined function requires which DB2 privilege?()A CALLB USAGEC EXECUTED REFERENCES
Friday, September 22, 2023
问题:单选题If DB2 detects a deadlock between application A and application B (each waiting for a lock held by the other one), what action will DB2 take?()A Rollback the transaction in both applications.B Rollback the transaction in one of the two applications.C Decrease the lock timeout value for both applications, thereby causing a lock timeout situation.D Send a message to let the administrator know of the situation and decide which application or applications should be terminated.
Monday, November 27, 2023
问题:单选题Which of the following is a characteristic of a sequence?()A A sequence will never generate duplicate valuesB The MAXVALUE of a sequence can be equal to the MINVALUEC It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zeroD When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries
Saturday, March 30, 2024
问题:单选题Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?()A REVOKE DROP ON t1 FROM PUBLICB REVOKE UPDATE ON t1 FROM PUBLICC REVOKE DELETE ON t1 FROM PUBLICD REVOKE CONTROL ON t1 FROM PUBLIC
Saturday, July 15, 2023
问题:单选题If a unique constraint is defined on column COL1 of table TAB1, what are the characteristics of COL1?()A COL1 will accept NULL values and can be referenced in another table's foreign key specification.B COL1 will not accept NULL values and cannot be referenced in another tables foreign key specification.C COL1 will not accept NULL values and can be referenced in another tables foreign key specification.D COL1 will accept NULL values and cannot be referenced in another tables foreign key specification.
问题:单选题Given the following table definition: STOCK: item VARCHAR(30) status CHAR(1) quantity INT price DEC(7,2) If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and PRICE to zero, which of the following statements would be used to update the STOCK table to indicate that all the items whose description begins with the letter "S" are out of stock?()A UPDATE stock SET (status = NULL; quantity, price = 0) WHERE item LIKE S%B UPDATE stock SET (status, quantity, price) = (NULL, 0, 0) WHERE item LIKE S%C UPDATE stock SET status = NULL, SET quantity = 0, SET price = 0 WHERE item LIKE 'S%'D UPDATE stock SET (status = NULL), (quantity = 0), (price = 0) WHERE item LIKE S%
问题:单选题Which of the following DB2 products are required on an iSeries or System i server to enable an application running on that server to retrieve data from a DB2 database on a Linux server?()A DB2 for i5/OSB DB2 Runtime ClientC DB2 Connect Enterprise EditionD DB2 for i5/OS SQL Development Kit
问题:单选题The opening of cursor CSR01 produces the following result set: STUDENT LASTNM FIRSTNM CLASSNO 123 Brown John T100 213 Bailey James T100 312 Carter Arlene T210 465 Chas Devon T305 546 Davis Steven T405 If this Fetch statement is executed: FETCH csr01 INTO :studnum, :firstname, :lastname, :class Which of the following DELETE statements will cause this row to be deleted?()A DELETE ALL FROM tab01 FOR CURRENT OF csr01B DELETE FROM tab01 FOR CURRENT csr01 WITH RSC DELETE * FROM tab01 WHERE CURRENT csr01 WITH CSD DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR
Saturday, October 15, 2022
问题:单选题Which of the following is a typical data warehouse query?()A What is this customers address?B Does this customer have any unpaid bills?C What is the balance in this customers account?D What are the total sales for each of the last 6 months?
问题:单选题An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement: CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT) Which of the following SQL statements will provide the table definition that meets the specified requirements?()A DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLEB DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSC CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSD CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
Saturday, September 2, 2023
问题:单选题Which of the following tools is used to view historical information about tasks, database changes, messages, and notifications?()A JournalB Task CenterC Control CenterD Activity Monitor
Tuesday, March 19, 2024
问题:单选题How should the following UDF be invoked in order to convert US currency values stored in the EXPENSES table into Canadian currency?CREATE FUNCTION getratews11 ( country1 VARCHAR(100), country2 VARCHAR(100) ) RETURNS DOUBLE LANGUAGE SQL CONTAINS SQL EXTERNAL ACTION NOT DETERMINISTIC BEGIN ... END()A CALL getratews11('USA','CANADA')B CALL expenses.getratews11('USA','CANADA')C SELECT getratews11('USA','CANADA') FROM expensesD SELECT * FROM TABLE(getratews11('USA','CANADA')) AS convert_currency
问题:单选题Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?()A The cursor is only protected from updates and deletes by concurrent applications.B The row is only protected from positioned updates and deletes that reference another cursor of the same application.C The cursor is protected from positioned updates and deletes that reference another cursor of a different application.D The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application.
问题:单选题Which of the following is a characteristic of a schema?()A Foreign key references cannot cross schema boundaries.B A DB2 user must be created before a schema with the same name can be created.C If no schema is specified when an object is created, the default schema PUBLIC is used.D A schema enables the creation of multiple objects in a database without encountering namespace collisions.
问题:单选题Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?()A CLOBB BLOBC HierarchicallyD Rows and columns