A.CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 446
B.CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 446
C.CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 192.168.10.1
D.CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 192.168.10.1
您可能感兴趣的试卷
你可能感兴趣的试题
A.MQT
B.Trigger
C.Read Only Cursor
D.Stored Procedure
A.Row
B.Alias
C.Bitmap
D.Column
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.
Application A is designed to execute the following SQL statements within a single Unit of Work (UOW).
UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'Application B is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' UPDATE employee SET salary = salary * 0.5 WHERE empno='000010'
Application A and application B execute their first SQL statement at the same time. When application A and application B try to execute their second SQL statement, a deadlock occurs.
What will happen?（）
A.The database manager will rollback the transaction in both applications.
B.The database manager will rollback the transaction in one of the two applications.
C.Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.
D.Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.
A.An application process acquires at least a share lock on the current row of every cursor.
B.Any row that is read during a unit of work cannot be changed by other application processes until the unit of work is complete.
C.Any row changed by another application process can be read, even if the change has not been committed by that application process.
D.An application process that issues the same query more than once in a unit of work will not see additional rows caused by other application processes appending new information to the database.
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.
A.Row
B.Table
C.Column
D.Table space
A.Control Center
B.Development Center
C.Developer Workbench
D.Stored Procedure Builder
A.When the data is naturally tabular
B.When the number of nodes are volatile
C.When the data by nature has sparse attributes
D.When the data is of low volume and requires a complex star-schema topology
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?
最新试题
The opening of cursor CSR01 produces the following result set:STUDENT LASTNM FIRSTNM CLASSNO 123 Brown John T100 213 Bailey JamesT100 312 Carter Arlene T210 465 Chas Devon T305 546 Davis Steven T405If 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 user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?（）
The EMPLOYEE table contains the following information: EMPNO NAME WORKDEPT101 SAM A11 102 JOHN C12 103 JANE -104 PAT Remote105 ANNE -106 BOB A11The MANAGER table contains the following information: MGRID NAME DEPTNO EMPCOUNT1 WU B01 - 2 JONES A11 - 3 CHEN - - 4 SMITH - -5 THOMAS C12 -After this statement is executed: UPDATE manager m SET empcount = (SELECT COUNT(workdept) FROM employee e WHERE workdept=m.deptno)What is the result of the following query?（）SELECT mgrid, empcount FROM MANAGER WHERE empcount IS NOT NULL ORDER BY mgrid
Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000?（）
Which of the following is a characteristic of a schema?（）
A UDT is a data type which:（）
A "trusted" client needs to communicate with a server that has been configured to use CLIENT authentication. Which of the following will be used to verify passwords?（）
Given the following DDL and INSERT statements:CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 > 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 < 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100);How many of these INSERT statements will be successful?（）
A table was created using the following DDL:CREATE TABLE employee (id SMALLINT NOT NULL, name VARCHAR(9), dept SMALLINT CHECK (dept BETWEEN 10 AND 100),job CHAR(10) CHECK (job IN ('Sales','Mgr','Clerk')), hiredate DATE, salary DECIMAL(7,2), comm DECIMAL(7,2), PRIMARY KEY (id), CONSTRAINT yearsal CHECK (YEAR(hiredate) > 2004 OR salary > 80500) );Which of the following INSERT statements will fail?（）
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?（）