10 Apr, 2007
Database Interview Questions
- 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.)
