Oracle Interview Questions and Answers
1. Explain: a.) Integrity Constraints It can be called as a declarative way in order to define a business rule for a table's column b.) Index - It can be called as an optional structure which is associated with a table for direct access to the rows - Index can be created for one or more columns in a table c.) Extent - It can be defined as a specific number of contiguous data blocks in single allocation. - It is used to store a specific type of information. 2. What is ANALYZE command used for? ANALYZE command is used to perform various functions on index, table, or cluster, as listed below: - It helps in dentifying migrated and chained rows of the table or cluster. - It helps in validating the structure of the object. - It helps in collecting the statistics about object used by the optimizer. They are then stored in the data dictionary. - It helps in deleting statistics used by object from the data dictionary. 3. a.) List the types of joins...