Multiple choice technology databases

Choose the database objects

  1. TABLE

  2. VARCHAR2

  3. SEQUENCE

  4. INDEX
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

TABLE, SEQUENCE, and INDEX are database objects in Oracle and other RDBMS. TABLE stores data, SEQUENCE generates unique numbers, and INDEX improves query performance. VARCHAR2 is a data type used to define columns, not a database object itself.

AI explanation

Correct answers: TABLE, SEQUENCE, INDEX.

In a relational database (e.g., Oracle), TABLE, SEQUENCE, and INDEX are all schema objects — named, storable structures that exist as entries in the data dictionary and can be created, altered, and dropped. VARCHAR2, by contrast, is a data type used to define a column's storage format, not an object in its own right — it has no independent existence in the database (you can't create/drop a "VARCHAR2" the way you can a table or sequence).

Keep practicing — related questions