1Z0-071 Web TestEngine demo

Select all that apply.

• A

  When the MAXVALUE limit for a sequence is reached, it can be increased by using the ALTER SEQUENCE statement.

• B

  DELETE <sequencename> would remove a sequence from the database.

• C

  The numbers generated by an explicitly defined sequence can only be used to insert data in one table.

• D

  CURRVAL is used to refer to the most recent sequence number that has been generated for a particular sequence.

• E

  When a database instance shuts down abnormally, sequence numbers that have been cached but not used are available again when the instance is restarted.