| A | B |
|---|
| Efficiency | skillfulness in avoiding wasted time and effort. |
| NEXTVAL | returns the next available sequence value |
| INTERVAL BY | __ specifies the interval between sequence numbers. |
| shareable | an object that can be shared by multiple users. |
| CREATE PUBLIC SYNONYM | to refer to a table by another name to simplify access |
| CURRVAL | returns the current sequence value. |
| CREATE SEQUENCE | ___ command that automatically generates sequential numbers. |
| Synonym | gives alternative names to objects. |
| CACHE / NOCACHE | specifies how many values the Server pre-allocates and keeps in memory. |
| CYCLE / NOCYCLE | specifies whether the sequence continues to generate values after reaching its maximum or minimum values. |
| MAXVALUE / NOMAXVALUE | specifies a maximum or default value the sequence can generate. |
| DROP INDEX__ | removes an index. |
| Sequences | generates a numeric value. |
| Index | ___ improves the performance of some queries; it is a schema object that speeds up retrieval of rows. |
| START WITH | specifies the first sequence number to be generated. |
