← Back to exam page

Free 1z0-497 – Oracle Database 12c Essentials Practice Test Question

Free demo downloads

Loading demo links...

Showing 4–6 of 10 questions

Question 4

Which two statements are true about transactions in Oracle Database 12c?

Select all that apply, then click Submit answer.

  • ○

    Multiple transactions can use the same undo segment.
  • ○

    A transaction is assigned an undo segment when it is started.
  • ○

    Multiple transactions cannot share the same extent in an undo tablespace.
  • ○

    If all the segments in an undo tablespace are used, transactions use system undo segments to store undo data.
Question 5

Which three events signal a database writer (DWR) to write buffers to disk?

Select all that apply, then click Submit answer.

  • ○

    The database advances a checkpoint.
  • ○

    A client process commits a transaction.
  • ○

    The redo log buffer becomes full.
  • ○

    A server process cannot find non-dirty blocks after scanning a threshold number of buffers.
  • ○

    A tablespace is changed to read-only status.
  • ○

    The database is shut down in immediate mode.
Question 6

In this SQL statement, what is the partitioning criteria?

CREATE TABLE books_part

PARTITION BY RANGE (cell_id) (

PARTITION p0l VALUES LESS THAN (2),

PARTITION p02 VALUES LESS THAN (3) ,

. . .

PARTITION pl4 VALUES LESS THAN (15),

PARTITION pl5 VALUES LESS THAN (16),

PARTITION pl6 VALUES LESS THAN (MAXVALUE)

)

AS SELECT * FROM books;

Select an option, then click Submit answer.

  • ○

    books
  • ○

    pxx
  • ○

    MAXVALUE
  • ○

    cell_id
  • ○

    There is no partitioning criteria.