OCP考试082

Name           Null?              Type

----------------------------------------------------------------------------

EMPLOYEE_ID SALARY DEPARTMENT_ID 

NOT NULL NOT NULL NOT NULL 

NUMBER(38) NUMBER (38) NUMBER(38)

Which statement increases each employee's SALARY by the minimum SALARY for their DEPARTMENT_ID?

--------------------------------------------

0A0007000A070000 ACTIVE In

Which three situations will re-executing this query still return a row but with a different XID, indicating a new transaction has started?

PROD_ID        PROD_NAME       PROD_LIST        CATEGORY_ID 

101                         Plate                     10                       1 

102                         Cup                       20                       1 

103                         Saucer                   20                       1 

104                         Knife                     30                        1 

105                         Fork                      30                        1 

Examine these queries: 

1. SELECT prod_name, prod_list FROM products WHERE prod_list = ANY (10, 20) AND category_id = 1; 

2. SELECT prod_name, prod_list FROM products WHERE prod_list IN (10, 20) AND category_id

= 1; 

3. SELECT prod_name, prod_list FROM products WHERE prod_list = ALL (10, 20) AND category_id = 1; Which queries generate the same output?

----------------------------------------------------------------------------

ORDER_ID                      NOT NULL                 NUMBER (38)           

PRODUCT_ID                 NOT NULL                 NUMBER (38) 

QUANTITY                     NOT NULL                 NUMBER (38)

Which two queries Return rows where QUANTITY is a multiple of ten?