Question 241

You install Oracle Grid Infrastructure for a standalone server.
Which two components are automatically included in the Oracle Restart configuration? (Choose two.)
  • Question 242

    Examine the parameters:
    Your database instance is started with a PFILE.

    You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache.
    You execute the command:
    SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
    Which is the outcome?
  • Question 243

    An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.
    A multitenant container database (CDB) instant has the following parameter set:
    THREADED_EXECUTION = FALSE
    Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?
  • Question 244

    Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:

    Which two statements are true about redefining the table? (Choose two.)
  • Question 245

    Examine the following command:
    CREATE TABLE (prod_id number(4),
    Prod_name varchar2 (20),
    Category_id number(30),
    Quantity_on_hand number (3) INVISIBLE);
    Which three statements are true about using an invisible column in the PRODUCTS table?