NAME               TYPE       VALUE

temp_undo_enabled boolean     TRUE 

undo_management   string      AUTO

undo_retention    integer     900 

undo_tablespace   string      UNDOTBS1

Which two statements are true?

Level 0 backup on Sunday

Cumulative incremental level 1 backup on Monday, Wednesday, and Saturday

Differential incremental level 1 backup on Tuesday, Thursday, and Friday Which three statements are true about the strategy?

Which two would you do to accomplish this?

CREATE TABLE daily_ords_list (ordno NUMBER, ord_date DATE) PCTFREE 20;

Which two are true?

Which two are required for this command to connect the SQLPLUS client to a database instance?

SQL> SELECT job FROM employees WHERE job=‘CLERK’ FOR UPDATE OF empno; 

HR then opens a second session. Which two operations wait when executed in HR’s second session?

You execute this command： SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION; 

Which three are true about the active transactions?

Examine the commands and their outcome： 

SQL> CREATE USER user02 identified by us123 QUOTA 10M ON users; 

User created.

SQL> GRANT create session, sysdba To user02; 

Grant succeeded. 

You plan to execute the commands：

SQL> CONN user02/us123 AS SYSDBA

SQL> CREATE TABLE mytab (id number, 1name varchar2 (20) ); Which two statements are true?