Question 81

Which two statements are true about Oracle synonyms?
  • Question 82

    You must create a tablespace of non-standard block size in a new file system and plan to use this command:

    The standard block size is 8k but other non-standard block sizes will also be used. Which two are requirements for this command to succeed?
  • Question 83

    You execute this command:
    CREATE SMALLFILE TABLESPACE sales
    DATAFILE '/u01/app/oracle/sales01.dbf
    SIZE 5G
    SEGMENT SPACE MANAGEMENT AUTO;
    Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)
  • Question 84

    Examine the description of the EMPLOYEES table:

    Which query is valid?
  • Question 85

    Examine the description of the members table:

    Examine the partial query:
    SELECT city, last__name 1NAME FROM members
    You want to display all cities that contain the string an. The cities must be returned in ascending order, with the last names further sorted in descending order.
    Which two clauses must you add to the query?