Using the CUSTOMERS table, you must generate a report that displays a credit limit increase of 15% for all customers.

Customers with no credit limit should have “Not Available” displayed.

Which SQL statement would produce the required result?

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?

Defined in this database, executes this command: $ sqlplus hr/hr@orcl @abc.sql

What will happen upon execution?

CONNECT / AS SYSDBA SQL> CREATE DIRECTORY dumpdir AS ‘/u01/app’; 

Directory created. 

SQL> GRANT READ,WRITE ON DIRECTORY dumpdir TO PUBLIC; 

Grant succeeded. 

SQL> GRANT USER TEST IDENTIFIED BY test; 

User created. 

SQL> GRANT CREATE SESSION,RESOURCE,UNLIMITED TABLESPACE TO test; 

Grant succeeded. 

SQL> CONN test/test. 

Connected. 

SQL> CREATE TABLE test_employees (id NUMBER(3), name VARCHAR2(20), salary NUMBER(7)); 

Table created. 

SQL> CREATE SYNONYM emp FOR test_employees; 

Synonym create.

Now examine this command: 

$ expdp test/test DIRECTORY=dumpdir DUMPFILE=test_emp.dmp LOGFILE=test.log TABLES=emp 

Which is true?