• +91 9971497814
  • info@interviewmaterial.com

Computer Interview Questions Answers

Oracle Interview Questions Answers

Question - 31 : - What is an Index ? How it is implemented in Oracle Database ?

Answer - 31 : - An index is a database structure used by the server to have direct access of a row in a table. An index is automatically created when a unique of primary key constraint clause is specified in create table comman (Ver 7.0)

Question - 32 : - What are the trigger associated with image items?

Answer - 32 : - When-image-activated fires when the operators double clicks on an image itemwhen-image-pressed fires when an operator clicks or double clicks on an image item

Question - 33 : - How can you enable automatic archiving ?

Answer - 33 : - Shut the database Backup the database Modify/Include LOG_ARCHIVE_START_TRUE in init.ora file. Start up the database.

Question - 34 : - How does one get the view definition of fixed views/tables?

Answer - 34 : - Query v$fixed_view_definition. Example: SELECT * FROM v$fixed_view_definition WHERE view_name='V$SESSION';

Question - 35 : - What are the vbx controls?

Answer - 35 : - Vbx control provide a simple method of building and enhancing user interfaces. The controls can use to obtain user inputs and display program outputs.vbx control where originally develop as extensions for the ms visual basic environments and include such items as sliders, rides and knobs.

Question - 36 : - What are the factors causing the reparsing of SQL statements in SGA?

Answer - 36 : - Due to insufficient shared pool size. Monitor the ratio of the reloads takes place while executing SQL statements. If the ratio is greater than 1 then increase the SHARED_POOL_SIZE.

Question - 37 : - What is an Index ?

Answer - 37 : - 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 - 38 : - How can values be passed bet. precompiler exits & Oracle call interface?

Answer - 38 : - By using the statement EXECIAFGET & EXECIAFPUT.

Question - 39 : - What is a View ?

Answer - 39 : - 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.)

Question - 40 : - What is the diff. when Flex mode is mode on and when it is off?

Answer - 40 : - When flex mode is on, reports automatically resizes the parent when the child is resized.

Computer Contributors

Rajeev Katiyar
Yes Baroda

Share your email for latest updates


Our partners