• +91 9971497814
  • info@interviewmaterial.com

Computer Interview Questions Answers

Oracle Interview Questions Answers

Question - 91 : - What are the Built-ins used for sending Parameters to forms?

Answer - 91 : - You can pass parameter values to a form when an application executes the call_form, New_form, Open_form or Run_product.

Question - 92 : - What is SYSTEM tablespace and when is it created?

Answer - 92 : - Every Oracle database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database.

Question - 93 : - What is Privilege Auditing ?

Answer - 93 : - Privilege auditing is the auditing of the use of powerful system privileges without regard to specifically named objects.

Question - 94 : - What are the built-ins that are used for setting the LOV properties at runtime?

Answer - 94 : - get_lov_property set_lov_property

Question - 95 : - What are the different display styles of list items?

Answer - 95 : - Pop_listText_listCombo box

Question - 96 : - What is clusters ?

Answer - 96 : - Group of tables physically stored together because they share common columns and are often used together is called Cluster.

Question - 97 : - What is Tablespace Quota ?

Answer - 97 : - The collective amount of disk space available to the objects in a schema on a particular tablespace.

Question - 98 : - What are the Referential actions supported by FOREIGN KEY integrity constraint ?

Answer - 98 : - UPDATE and DELETE Restrict - A referential integrity rule that disallows the update or deletion of referenced data. DELETE Cascade - When a referenced row is deleted all associated dependent rows are deleted.

Question - 99 : - What is pop list?

Answer - 99 : - The pop list style list item appears initially as a single field (similar to a text item field). When the operator selects the list icon, a list of available choices appears.

Question - 100 : - What are the components of physical database structure of Oracle database?

Answer - 100 : - Oracle database is comprised of three types of files. One or more datafiles, two are more redo log files, and one or more control files.

Computer Contributors

krishan
Rajeev Katiyar
Yes Baroda

Share your email for latest updates

Name:
Email:

Our partners