單項(xiàng)選擇題

Examine the structure of the EMPLOYEES table:

You issue these statements:

At the end of this transaction, what is true?（）

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 eleted.

你可能感興趣的試題

單項(xiàng)選擇題

The user Sue issues this SQL statement:
GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION;
The user Alice issues this SQL statement:
GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION;
The user Reena issues this SQL statement:
GRANT SELECT ON sue. EMP TO timber;
The user Sue issues this SQL statement:
REVOKE select on sue. EMP FROM alice;
For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）

A. Alice only
B. Alice and Reena
C. Alice, Reena, and Timber
D. Sue, Alice, Reena, and Timber

多項(xiàng)選擇題

Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
Which three statements insert a row into the table? （）

A. INSERT INTO employees VALUES (NULL, 'John', 'smith');
B. INSERT INTO employees (first_name, last_name) VALUES ('John', 'smith');
C. INSERT INTO employees VALUES ('1000, 'John', 'smith');
D. INSERT INTO employees (first_name, last_name, employee_id) VALUES (1000, 'John', 'smith');
E. INSERT INTO employees (employee_id) VALUES (1000);
F. INSERT INTO employees ( employee_id, first_name, last_name, ) VALUES (1000, 'John','');

Examine the structure of the EMPLOYEES table: You issue these statements: At the end of this transaction, what is true?（）

你可能感興趣的試題

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements insert a row into the table? （）

Examine the structure of the EMPLOYEES table:

You issue these statements:

At the end of this transaction, what is true?（）

Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
Which three statements insert a row into the table? （）