Question

Name the different types of database objects. Explain any two in detail.​

Answer 1

$\huge\bold\pink{\underline{\underline{{ANSWER:}}}}$

$\bf{\underline\green{DATABASE}}$$\bf{\underline\green{OBJECTS:}}$

A database object is any defined object in a database that is used to store or reference data.

The table is this hour's focus because it is the primary and simplest form of data storage in a relational database.

$\bf{\underline\green{EXAMPLES:}}$

✦ tables.

✦ views.

✦ clusters.

✦ sequences.

✦ indexes.

✦ synonyms.

$\bf{\underline\green{TABLE:}}$

⟹ A table is a collection of related data held in a table format within a database.

⟹ In relational databases, and flat file databases, a table is a set of data elements (values) using a model of vertical columns (identifiable by name) and horizontal rows, the cell being the unit where a row and column intersect.

$\bf{\underline\green{INDEXES:}}$

⟹ A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space to maintain the index data structure.

⟹ Some databases extend the power of indexing by letting developers create indexes on functions or expressions.

___________________________________________

$\huge\bold\purple{\underline{\underline{{★THANKS★}}}}$

Answer 2

Explanation:

ANSWER:

\bf{\underline\green{DATABASE}}

DATABASE

\bf{\underline\green{OBJECTS:}}

OBJECTS:

A database object is any defined object in a database that is used to store or reference data.

The table is this hour's focus because it is the primary and simplest form of data storage in a relational database.

\bf{\underline\green{EXAMPLES:}}

EXAMPLES:

✦ tables.

✦ views.

✦ clusters.

✦ sequences.

✦ indexes.

✦ synonyms.

\bf{\underline\green{TABLE:}}

TABLE:

⟹ A table is a collection of related data held in a table format within a database.

⟹ In relational databases, and flat file databases, a table is a set of data elements (values) using a model of vertical columns (identifiable by name) and horizontal rows, the cell being the unit where a row and column intersect.

\bf{\underline\green{INDEXES:}}

INDEXES:

⟹ A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space to maintain the index data structure.

⟹ Some databases extend the power of indexing by letting developers create indexes on functions or expressions