1Z0-082 Exam Question 91

Which three statements are true about the DESCRIBE command? (Choose three.)
  • 1Z0-082 Exam Question 92

    Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)
  • 1Z0-082 Exam Question 93

    Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)
  • 1Z0-082 Exam Question 94

    View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
    You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
    Examine this SQL statement:

    Exhibit 1.

    Exhibit 2.

    What will be the result?
  • 1Z0-082 Exam Question 95

    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.)