Name Null? Type

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

- EMPLOYEE_ID NOT NULL NUMBER(38)

SALARY NOT NULL NUMBER(38)

DEPARTMENT_ID

Which statement increases

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

Examine this statement which executes successfully:

INSERT ALL WHEN SAL > 20000

THEN INTO special_sal VALUES (EMP_ID, SAL)

ELSE INTO sal_history VALUES (EMP_ID, HIREDATE, SAL)

INTO mgr_history VALUES (EMP_ID, MGR ,SAL)

SELECT employee_id EMP_ID , hire_date HIREDATE, salary SAL, manager_id MGR FROM employees WHERE employee_id < 125; .

Which is true?

Examine the description of the EMPLOYEES table:

Name Null? Type

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

EMPLOYEE_ID NOT NULL NUMBER(38)

SALARY NOT NULL NUMBER (38)

DEPARTMENT_ID NOT NULL NUMBER(38)

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

their DEPARTMENT_ID?

Table HR. EMPLOYEES contains a row where the EMPLOYEE_ID is 109.

User ALICE has no privileges to access HR . EMPLOYEES.

User ALICE starts a session.

User HR starts a session and successfully executes these statements:

GRANT DELETE ON employees TO alice;

UPDATE employees SET salary = 24000 WHERE employee_id = 109;

In her existing session ALICE then executes:

DELETE FROM hr.employees WHERE employee_id = 109;

What is the result?

CONNECT HR/HRMGR@orcl No name server is used.

Which statement is true about ORCL?

（含图）

Examine this command attempted by the user:

$ sqlplus hr/hr@orc1 @abc

What will happen and why?

1. A size of 100 MB

2. 2. AUTOEXTEND is off

3. 3. UNDO_RETENTION is set to 15 minutes

4. 4. It has RETENTION GUARANTEE

UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens. What will happen when the next update is attempted by any transaction?

NAME TYPE VALUE

temp_undo_enabled boolean TRUE

undo_ management string AUTO

undo _retention Integer 900

undo _tablespace string UNDOTBS1

Your database has three undo tablespaces and the default undo tablespace is not autoextensible. Resumable space allocation is not enabled for any sessions in the database instance. What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?

An UPDATE is executed on a temporary table.

Where is the UNDO stored?

Name Null? Type

CITYID NOT NULL NUMBER (4)

CITY_NAME VARCHAR2 (50)

Examine the command:

SQL>ALTER TABLE cities SHRINK SPACE COMPACT;

What must you do before executing it?

i. Long-running queries are not affected.

ii. . No extra space is used.

iii. Data manipulation language (DML) operations on the table succeed at all times throughout the process iv. Unused space is reclaimed both above and below the high water mark.

Which alter TABLE option would you recommend?

ALTER TABLE orders SET UNUSED (order_date);

Which statement is true?

1. Not a DBA user

2. An operating system (OS) user

Examine this command and its output:

（含图）

What must you do so that SCOTT is authenticated by the OS when connecting to the database instance?

You need to allow user NEWUSER to:

1. Modify the TITLE and ADDRESS columns of your CUSTOMERS table.

2. GRANT that permission to other users.

Which statement will do this?

time it is executed in a session but only prompts for the table name the first time it is executed.

The variables used in your query are never undefined in your session.

Which query can be used?

ALTER TABLE hr.emp SET UNUSED (mgr_id);

Which statement is true regarding the effect of the above SQL statement?

Which statement is true about TRUNCATE and DELETE?