a2zinterviews

5.	What is partitioning?
	Partitioning is used to divide large tables into manageable partitions based on different criteria, such as list, hash, or range.
	Discuss Your Name Your Email-ID Your Answer

6.	What is the significance of pseudo column in Oracle?
	Pseudo column is an Oracle assigned value used in the same context as a column. It is an item of data, which is treated like a table column even though it does not exist as part of the definition of any table. CURRVAL, NEXTVAL, USER, SYSDATE, LEVEL, ROWID, and ROWNUM are the examples of pseudo column. A pseudo column can be queried but Data Manipulation Language (DML) cannot be applied to a pseudo column.
	Discuss Your Name Your Email-ID Your Answer

7.	What do you understand by Data Definition Language (DDL) trigger?
	The DDL trigger executes every time a DDL statement is executed. These are associated with a database or schema.
	Discuss Your Name Your Email-ID Your Answer

8.	What is a global index and local index?
	A global index is associated with the entire table and gets affected when any one of the partitions is modified. Local indexes are associated with individual partitions. Therefore, only a person of the index gets affected when a table partition is modified.
	Discuss Your Name Your Email-ID Your Answer