Free 1z0-062 – Oracle Database 12c: Installation and Administration Practice Test Question

Free demo downloads

Loading demo links...

Showing 7–9 of 20 questions

Question 7

Which two statements are true about Oracle network connections? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    A listener may listen on behalf of only one database instance at a time.

  • ○

    The listener check’s a user’s authentication credentials and creates a session if the credentials are valid.

  • ○

    The listener continuously monitors a connection after the user process connects to a service handler.

  • ○

    The listener can spawn a new server process to deal with each new connection.

  • ○

    A connection request from a remote client is always first received by a listener listening on port 1521.

Question 8

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? (Choose three.)

Select all that apply, then click Submit answer.

  • ○

    The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.

  • ○

    The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.

  • ○

    Referential integrity constraint cannot be set on the invisible column.

  • ○

    The invisible column cannot be made visible and can only be marked as unused.

  • ○

    A primary key constraint can be added on the invisible column.

Question 9

Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and generates lots of redo. Which two actions would you take to solve this problem? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Increase the size of the temporary tablespace.

  • ○

    Enable Automatic Memory Management (AMM).

  • ○

    Enable undo retention guarantee.

  • ○

    Enable temporary undo for the database.

  • ○

    Increase the size of the redo log buffer.