1Z0-082 Exam Question 26

Which two statements are true about the PMON background process? (Choose two.)
  • 1Z0-082 Exam Question 27

    In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
    The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

    Which statement is true?
  • 1Z0-082 Exam Question 28

    Which two statements are true about trace files produced by the Oracle Database server?
    (Choose two.)
  • 1Z0-082 Exam Question 29

    In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
    Examine this command:
    SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
    Which segment or segments, if any, are created as a result of executing the command?
  • 1Z0-082 Exam Question 30

    The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.
    NLS_DATE_FORMAT is set to DD-MON-RR.
    Which two are true about data type conversions involving these columns in query expressions?
    (Choose two.)