Oracle Interview Questions and Answers
Question - 21 : - What are the type of Synonyms?
Answer - 21 : - There are two types of Synonyms Private and Public.
Question - 22 : - What is a Redo Log ?
Answer - 22 : - The set of Redo Log files YSDATE,UID,USER or USERENV SQL functions, or the pseudo columns LEVEL or ROWNUM.
Question - 23 : - What is an Index Segment ?
Answer - 23 : - Each Index has an Index segment that stores all of its data.
Question - 24 : - Explain the relationship among Database, Tablespace and Data file?
Answer - 24 : - Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace
Question - 25 : - What are the different type of Segments ?
Answer - 25 : - Data Segment, Index Segment, Rollback Segment and Temporary Segment.
Question - 26 : - What are Clusters ?
Answer - 26 : - Clusters are groups of one or more tables physically stores together to share common columns and are often used together.
Question - 27 : - What is an Integrity Constrains ?
Answer - 27 : - An integrity constraint is a declarative way to define a business rule for a column of a table.
Question - 28 : - What is an Index ?
Answer - 28 : - 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.
Question - 29 : - What is an Extent ?
Answer - 29 : - An Extent is a specific number of contiguous data blocks, obtained in a single allocation, and used to store a specific type of information.
Question - 30 : - What is a View ?
Answer - 30 : - 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.)