【多选题】User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, orany data definition language (DDL) command: SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF...
A.
LOCK TABLE emp IN SHARE MODE;
B.
LOCK TABLE emp IN EXCLUSIVE MODE;
C.
UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER?UPDATE emp SET sal=sal*1.2 WHERE job=?ANAGER?
D.
INSERT INTO emp(empno,ename) VALUES (1289,’Harry’);
E.
SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno
【单选题】Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE You issue these statements: CREATE table new_emp ( employe_id...
A.
You have no rows in the table.
B.
You have an employee with the name of James.
C.
You cannot roll back to the same savepoint more than once.
D.
Your last update fails to update any rows because employee ID 180 was already deleted.