Segment creation is not deferred.

You execute this command:

CREATE USER sales

        IDENTIFIED BY sales_123

        DEFAULT TABLESPACE sales_q1

        TEMPORARY TABLESPACE temp

        QUOTA 5M ON users;

Which three statements must be true so that the sales user can create tables in SALES_Q1?

and then execute this command:

GRANT CREATE SESSION TO hr WITH ADMIN OPTION;

Which three actions can HR perform?

[oracle@host01 ~]$ expdp system/oracle \

> FULL=Y \

> DUMPFILE=exp_db_full.dmp \

> PARALLEL=4 \

> LOGFILE=exp_db_full.log \

> JOB_NAME=exp_db_full

During the export operation, you detach from the job by using CTRL+C and then execute this command:

Export> STOP_JOB=immediate

Are you sure you wish to stop the job ([yes]/no): yes

Which two statements are true about the job?

[oracle@host01 ~]$ expdp system/oracle \

> FULL=Y \

> DUMPFILE=exp_db_full.dmp \

>PARALLEL=4 \

> LOGFILE=exp_db_full.log \

> JOB_NAME=exp_db_full

During the export operation, you detach from the job by using CTRL+C and then execute this command:

Export> STOP_JOB=immediate

Are you sure you wish to stop the job ([yes]/no):yes

Which two statements are true about the job?

[oracle@host01 ~ ]$$ sqlplus u1/oracle

SQL> SELECT ∗ FROM emp;

ENO               ENAME          DN

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

1                    Alan               2

2                    Ben                2

SQL> exit

[oracle@host01 ~ ]$$ cat emp.dat

3,Curl,4

4,Bob,4

[oracle@host01 ~ ]$ sqlldr u1/oracle TABLE=emp

Which two statements are true about the sqlldr execution?

[oracle@host01 ~]$$ sqlplus u1/oracle

SQL> SELECT ∗ FROM emp;

ENO               ENAME          DN

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

1                    Alan               2

2                    Ben                2

SQL> exit

[oracle@host01 ~]$$ cat emp.dat

1,Alan,2

3,Curl,4

4,Bob,4

[oracle@host01 ~]$ sqlldr u1/oracle TABLE=emp

Which two statements are true about the sqlldr execution?