• +91 9971497814
  • info@interviewmaterial.com

Computer Interview Questions Answers

Oracle Interview Questions Answers

Question - 21 : - What is SGA?

Answer - 21 : - The System Global Area in an Oracle database is the area in memory to facilitate the transfer of information between users. It holds the most recently requested structural information between users. It holds the most recently requested structural information about the database. The structure is database buffers, dictionary cache, redo log buffer and shared pool area.

Question - 22 : - Can objects of the same Schema reside in different tablespace ?

Answer - 22 : - Yes.

Question - 23 : - What is the purpose of the product order option in the column property sheet?

Answer - 23 : - To specify the order of individual group evaluation in a cross products.

Question - 24 : - How can I message to passed to the user from reports?

Answer - 24 : - By using SRW.MESSAGE function.

Question - 25 : - If two groups are not linked in the data model editor, What is the hierarchy between them?

Answer - 25 : - Two group that is above are the left most rank higher than the group that is to right or below it.

Question - 26 : - What is forms_DDL?

Answer - 26 : - Issues dynamic Sql statements at run time, including server side pl/SQl and DDL

Question - 27 : - How are the index updates?

Answer - 27 : - Indexes are automatically maintained and used by Oracle. Changes to table data are automatically incorporated into all relevant indexes.

Question - 28 : - What are the dictionary tables used to monitor a database space?

Answer - 28 : - DBA_FREE_SPACE DBA_SEGMENTS DBA_DATA_FILES.

Question - 29 : - What is the Maximum allowed length of Record group Column?

Answer - 29 : - Record group column names cannot exceed 30 characters.

Question - 30 : - Can you have more than one content canvas view attached with a window?

Answer - 30 : - Yes. Each window you create must have atleast one content canvas view assigned to it. You can also create a window that has manipulated content canvas view. At run time only one of the content canvas views assign to a window is displayed at a time.

Computer Contributors

krishan
Rajeev Katiyar
Yes Baroda

Share your email for latest updates

Name:
Email:

Our partners