单选题 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?()
Application B will read the row.
Applications A and B will cause a deadlock situation.
Application B will wait until application A releases the Update lock.
Application A will be terminated so that application B can read the row.
单选题 Which of the following is a characteristic of a schema?()
Foreign key references cannot cross schema boundaries.
A DB2 user must be created before a schema with the same name can be created.
If no schema is specified when an object is created, the default schema PUBLIC is used.
A schema enables the creation of multiple objects in a database without encountering namespace collisions.
单选题 Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?()
The cursor is only protected from updates and deletes by concurrent applications.
The row is only protected from positioned updates and deletes that reference another cursor of the same application.
The cursor is protected from positioned updates and deletes that reference another cursor of a different application.
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.
单选题 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?()
DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS
CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS
CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
单选题 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?()
DB2 for i5/OS
DB2 Runtime Client
DB2 Connect Enterprise Edition
DB2 for i5/OS SQL Development Kit
单选题 Which of the following is a characteristic of a sequence?()
A sequence will never generate duplicate values
The MAXVALUE of a sequence can be equal to the MINVALUE
It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero
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
单选题 Which of the following is the lowest cost DB2 product that can be legally installed on an AIX server?()
DB2 Express Edition
DB2 Personal Edition
DB2 Workgroup Server Edition
DB2 Enterprise Server Edition
单选题 Given the following table definitions: EMPLOYEE ID NAME DEPTID 01Smith 10 02Bossy 20 03 20 Peterson 04Goss 30 05Pape 40 06Avery 50 07O'Neal 60 08Carter 50 DEPARTMENT ID DEPTNAME 05 Hardware 10 Kitchen 20 Shoes 30 Toys 40 Electronics 50 Automotive and the following query: SELECT e.id, d.deptname FROM employee e, department d WHERE e.deptid = d.id AND e.id > 4 Which of the following queries will produce the same result set as the query above?()
SELECT e.id, d.deptname FROM employee e, department d WHERE e.id > 4
SELECT e.id, d.deptname FROM employee e INNER JOIN department d ON e.deptid = d.id WHERE e.id > 4
SELECT e.id, d.deptname FROM employee e FULL OUTER JOIN department d ON e.id = d.id WHERE e.id > 4
SELECT e.id, d.deptname FROM employee e LEFT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4 UNION ALL SELECT e.id, d.deptname FROM employee e RIGHT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4
单选题 How does DB2 protect the integrity of indexes when data is updated?()
Locks are acquired on the data.
Locks are acquired on index keys.
Locks are acquired on index pages.
Locks are acquired on index pointers.
下列属于直线行驶的是()
某通信机房设置七氟丙烷预制灭火系统,该系统应有( )种启动方式。
唐后期书院产生的一个原因是受到()的影响。
压力损失是指()
干旱区造林,整地的主要目的是()
治癫证痰气郁结证,治以()
小学低、中年级的儿童____识记发展最为迅速。
( )是北京市制定的第一个全面保护历史文化名城的法规。
安全带的正确使用:使用前作外观检查,若破损应()使用。
Your network consists of a single Active Directory domain. The domain contains more than 300 group objects. The group objects are divided between several regional organizational units (OUs). You need to create a list of all groups that have names that begin with the word Sales. Which command should you use? ()