1Z0-082 Exam Question 111

Which two can you use to recover a dropped table? (Choose two.)
  • 1Z0-082 Exam Question 112

    You execute this query:
    SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "Monday for" fmMonth rrrr') What is the result?
  • 1Z0-082 Exam Question 113

    Which three are types of segments in an Oracle Database? (Choose three.)
  • 1Z0-082 Exam Question 114

    In your data center, Oracle Managed Files (OMF) is used for all databases.
    All tablespaces are smallfile tablespaces.
    SALES_Q1 is a permanent user-defined tablespace in the SALES database.
    Examine this command which is about to be issued by a DBA logged in to the SALES database:
    ALTER TABLESPACE sales_q1 ADD DATAFILE;
    Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)
  • 1Z0-082 Exam Question 115

    Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
    ALTER DATABASE MOUNT;
    Which two actions are performed? (Choose two.)