Question 56

Which three statements are true regarding single row subqueries?
  • Question 57

    In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement:
    CONNECT HR/HRMGR@orcl
    No name server is used.
    Which statement is true about ORCL?
  • Question 58

    Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)
  • Question 59

    Examine this command and some partial output:

    Why does the DB01.abc.comservice show unknown status?
  • Question 60

    Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)