a2zinterviews

13.	Name two files used for network connection to a database?
	The TNSNAMES.ORA and SQLNET.ORA files are used for network connection to a database.
	Discuss Your Name Your Email-ID Your Answer

14.	How many columns can be used to create a composite index?
	A composite index can support 32 columns as long as total size of the columns does not exceed DB_BLOCK_SIZE.
	Discuss Your Name Your Email-ID Your Answer

15.	What command would you use to encrypt a PL/SQL application?
	The WRAP command can be used to encrypt a PL/SQL application.
	Discuss Your Name Your Email-ID Your Answer

16.	Can you disable and enable primary key?
	Yes, you can use the following statements to enable and disable primary key constraints. Alter table <table_name> enable constraint <constraint_name>; Alter table <table_name> disable constraint < constraint_name>;
	Discuss Your Name Your Email-ID Your Answer