Question 161

Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege?
(Choose three.)
  • Question 162

    Automatic Shared Memory Management is disabled for one of your database instances.
    Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance.
    What would be your next step?
  • Question 163

    Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. APP_ROOT is an application root in CDB1. 3. APP_PDB1 is an application PDB in APP_ROOT. 4. FLASHBACK DATABASE is ON. You execute these commands: $ sqlplus sys/orac1e_4U@localhost:1521/cdb1 SQL> SELECT current_scn FROM v$database; CURRENT_SCN -----------------------2074756 SQL> CREATE TABLE cdb1_tab(c1 NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> CREATE TABLE app_root_tab (c1 NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> CREATE TABLE app_pdb1_tab (c1 NUMBER) ; Table created. SQL> conn / as sysdba Connected. SQL> ALTER PLUGGABLE DATABASE app_root CLOSE; Pluggable database altered. SQL> FLASHBACK PLUGGABLE DATABASE app_root TO SCN 2074756; Flashback complete. Which table or set of tables will exist after the Flashback operation has completed?
  • Question 164

    Which two are true about common objects? (Choose two.)
  • Question 165

    SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases.
    Which action could help in the performance management of these regressed SQL statements?