Question 16

Which four account management capabilities can be configured using Oracle profiles? (Choose four.)
  • Question 17

    Examine the description of the CUSTOMERS table:

    You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
    Which query can be used?
  • Question 18

    The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
    Segment creation is not deferred.
    You execute this command:

    Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)
  • Question 19

    The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
    Segment creation is not deferred.
    You execute this command:

    Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)
  • Question 20

    Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)