Oracle Interview Questions and Answers
Question - 121 : - What are the factors causing the reparsing of SQL statements in SGA?
Answer - 121 : - 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 - 122 : - What are clusters?
Answer - 122 : - Clusters are groups of one or more tables physically stores together to share common columns and are often used together.
Question - 123 : - What is cluster key?
Answer - 123 : - The related columns of the tables in a cluster are called the cluster key.
Question - 124 : - Do a view contain data?
Answer - 124 : - Views do not contain or store data.
Question - 125 : - What are the dictionary tables used to monitor a database space?
Answer - 125 : - DBA_FREE_SPACE
DBA_SEGMENTS
DBA_DATA_FILES.
Question - 126 : - Can a property clause itself be based on a property clause?
Answer - 126 : - Yes
Question - 127 : - If a parameter is used in a query without being previously defined, what diff. exist between. report 2.0 and 2.5 when the query is applied?
Answer - 127 : - While both reports 2.0 and 2.5 create the parameter, report 2.5 gives a message that a bind parameter has been created.
Question - 128 : - What are the sql clauses supported in the link property sheet?
Answer - 128 : - Where start with having.
Question - 129 : - What is trigger associated with the timer?
Answer - 129 : - When-timer-expired.
Question - 130 : - What are the trigger associated with image items?
Answer - 130 : - 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