Examine the command:Which statement is true about the execution of the command?
You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs.How can you detect the cause of the degraded performance?
Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined.You execute this command:SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;Which statement is true?
You created a tablespace with this statement:CREATE BIGFILE TABLESPACE adtbs -DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.Which two alter statements will achieve this?
Which two statements are true regarding the Oracle Data Pump export and import operations?
Which two statements are true about scheduling operations in a pluggable database (PDB)?
