When a COMMIT statement is executed, what happens、

试卷相关题目

• 1Which statement about roll back operations is correct、

  A.When a ROLLBACK statement is executed, all locks held by the terminating transaction are released.

  B.When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired up to the savepoint are released.

  C.When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired after the savepoint are release

  D.D. When a ROLLBACK statement is executed, all locks acquired for open cursors that were declared WITH HOLD, are held.

  开始考试点击查看答案
• 2A table named SALES contains a record for every sales transaction a company processes. A user wishes to see the number of transactions that are made by each salesman. Which SQL statement will produce the desired results、

  A.SELECT name, COUNT(*) AS transactions FROM sales

  B.SELECT name, COUNT(DISTINCT name) AS transactions FROM sales

  C.SELECT name, COUNT(*) AS transactions FROM sales GROUP BY name

  D.SELECT DISTINCT name, COUNT(*) AS transactions FROM sales GROUP BY transactions

  开始考试点击查看答案
• 3Which tool allows users to connect to a DB2 database using a wizard、

  A.Control Center

  B.IBM Data Studio

  C.Universal Connection Expert

  D.DB2 Connection Pool Manager

  开始考试点击查看答案
• 4Which platform supports DB2 pureScale environments、

  A.AIX

  B.iOS

  C.z/OS

  D.Windows

  开始考试点击查看答案
• 5Which DB2 product is NOT suitable for very large data warehouse applications、

  A.DB2 for i

  B.DB2 for AIX

  C.DB2 for z/OS

  D.DB2 for Linux

  开始考试点击查看答案
• 6Which SQL statement would be used to retrieve only salaries that are greater than $100,000.00 from a table named EMPLOYEE、

  A.SELECT * FROM employee WHERE salary < 100000

  B.SELECT salary FROM employee WHERE salary > 100000

  C.SELECT salary FROM employee WHERE salary > 100,000.00

  D.SELECT * FROM employee WHERE salary GREATER THAN 100000

  开始考试点击查看答案
• 7Which SQL statement should be used to retrieve the minimum and maximum salaries (SALARY) for each job code (JOB), sorted by job code, from a table named EMPLOYEE、

  A.SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY job ORDER BY job;

  B.SELECT job, MIN(salary), MAX(salary) FROM employee ORDER BY job;

  C.SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY SALARY ORDER BY job;

  D.SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY MIN(salary), MAX(salary)ORDER BY job;

  开始考试点击查看答案
• 8If a table named MY_TAB contains 100 rows and the following statement is executed:  UPDATE  (SELECT * FROM my_tab   ORDER BY col1 DESC   FETCH FIRST 10 ROWS ONLY) AS temp   SET col3 = 99; How many rows will be updated、

  A.0

  B.1

  C.10

  D.99

  开始考试点击查看答案
• 9An SQL function named DEPT_INFO was created as follows:  CREATE FUNCTION dept_info()  RETURNS TABLE(dept_id INTEGER,dept_name VARCHAR(20))  LANGUAGE SQL  READS SQL DATA  BEGIN ATOMIC  RETURN    SELECT deptno,deptname FROM department WHERE deptname LIKE 'S%';  END What is the correct way to use this function in a query、

  A.SELECT dept_info(dept_id, dept_name)

  B.SELECT dept_id, dept_name FROM dept_info()

  C.SELECT TABLE dept_id, dept_name FROM dept_info()

  D.SELECT dept_id, dept_name FROM TABLE(dept_info()) AS results

  开始考试点击查看答案
• 10Which type of stored procedure is not associated with an external application program、

  A.A Java stored procedure.

  B.A REXX stored procedure.

  C.A native SQL stored procedure.

  D.An external SQL stored procedur

  开始考试点击查看答案