Part-4

What are the type of Synonyms? -

There are two types of Synonyms Private and Public

What is a Redo Log? -

The set of Redo Log files YSDATE,UID,USER or USERENV SQL functions, or the pseudo columns LEVEL or ROWNUM.

What is an Index Segment? -

Each Index has an Index segment that stores all of its data.

Explain the relationship among Database, Tablespace and Data file.? -

Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace

What are the different type of Segments? -

Data Segment, Index Segment, Rollback Segment and Temporary Segment.

What are Clusters? -

Clusters are groups of one or more tables physically stores together to share common columns and are often used together.

What is an Integrity Constrains? -

An integrity constraint is a declarative way to define a business rule for a column of a table.

What is an Index? -

An Index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval. Index can be created on one or more columns of a table.

What is an Extent? - An Extent is a specific number of contiguous data blocks, obtained in a single allocation, and used to store a specific type of information.

What is a View? - A view is a virtual table. Every view has a Query attached to it. (The Query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)

What is Table? - A table is the basic unit of data storage in an ORACLE database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.

What is a Synonym? - A synonym is an alias for a table, view, sequence or program unit.

What is a Sequence? - A sequence generates a serial list of unique numbers for numerical columns of a database’s tables.

What is a Segment? - A segment is a set of extents allocated for a certain logical structure.

What is schema? - A schema is collection of database objects of a User.