| A | B |
|---|
| Table | structure that stores data, basic unit of storage, composed of rows and columns. |
| BLOB | binary large object data up to 4 gigabytes. |
| Data Warehousing | a generic term for a system for storing, retrieving and managing large amounts of any type of data. |
| INTERVAL DAY TO SECOND | allows time to be stored as an interval of days to hours, minutes, and seconds. |
| BFILE | binary data stored in an external file; up to 4 gigabytes. |
| Schema | a collection of objects that are the logical structures that directly refers to the data in the database |
| INTERVAL YEAR TO MONTH | allows time to be stored as an interval of years and months. |
| LONG | variable-length character data up to 2 gigabytes. |
| ROWID | hexadecimal string representing the unique address of a row in its table. |
| CREATE TABLE | command to create tables to store data |
| DEFAULT | specifies a preset value if a value is omitted in the INSERT statement. |
| TIMESTAMP | allows the time to be stored as a date with fractional seconds |
| Data Dictionary | created and maintained by the Oracle Server and contains information about the database. |
| MERGE INTO | provides the ability to conditionally update or insert data into a database table. |
| User Tables | tables created by the user. |
| RENAME | used to change the name of a table. |
| COMMENT ON TABLE | command to add comments to a table or column. |
| TRUNCATE TABLE | used to remove all rows from a table and to release the storage spaced used by the table. |
| DROP COLUMN | to delete a column from a table. |
| ALTER TABLE | to add, modify, or drop columns from a table. |
| SET UNUSED | ______ marks one or more columns as unused so that they can be dropped when the demand on system resources is lower. |
| DROP TABLE | removes the definition of a table. |
