Question 391
Examine the details of the uncompressed, non-partitioned heap table CITIES.
Examine the command:
SQL> ALTER TABLE cities SHRINK SPACE COMPACT;
What must you do before executing it?
Examine the command:
SQL> ALTER TABLE cities SHRINK SPACE COMPACT;
What must you do before executing it?
Question 392
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?
Question 393
Which three statements are true about automated maintenance tasks?
Question 394
Which two statements are true about initialization parameter files? (Choose two.)
Question 395
The HR schema exists in databases, BOSTONand DENVER, with the same password, HR.
You have CREATE DATABASE LINKand CREATE SESSIONprivileges in both databases.
DENVERis defined as a service name in the tnsnames.oraof both databases.
You plan to use this command:
CREATE DATABASE LNK hr_link CONNECT TO hr IDENTIFIED BY hr USING 'DENVER'; What must be done to ensure that all users in BOSTONcan access the HRschema in DENVER?
You have CREATE DATABASE LINKand CREATE SESSIONprivileges in both databases.
DENVERis defined as a service name in the tnsnames.oraof both databases.
You plan to use this command:
CREATE DATABASE LNK hr_link CONNECT TO hr IDENTIFIED BY hr USING 'DENVER'; What must be done to ensure that all users in BOSTONcan access the HRschema in DENVER?