Question 341

Examine the current value for the following parameters in your database instance:
SGA_MAX_SIZE = 1024M
SGA_TARGET = 700M
DB_8K_CACHE_SIZE = 124M
LOG_BUFFER = 200M
You issue the following command to increase the value of DB_8K_CACHE_SIZE:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
Which statement is true?
  • Question 342

    Your database is open in read/write mode and multiple users are connected to the database instance.
    You execute the following command:
    SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
    What would be the effect on current sessions?
  • Question 343

    What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?
  • Question 344

    SMD is a smallfile locally managed tablespace with manual segment space management.
    The SH user receives the following error while inserting data into the salestable:

    Which three actions can be taken to enable the user to insert data? (Choose three.)
  • Question 345

    A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:

    There is enough free space in the disk group for mirroring to be done.
    What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?