What is Execution Plan ?
The combinations of the steps the optimizer chooses to execute a statement is called an execution plan. Read more »
‘Oracle Interview Questions’ - KyaPoocha.com
What is SAVE POINT ?
For long transactions that contain many SQL statements, intermediate markers or savepoints can be declared which can be used to divide a transaction into smaller... Read more »
What does COMMIT do ?
COMMIT makes permanent the changes resulting from all SQL statements in the transaction. The changes made by the SQL statements of a transaction become visible to... Read more »
Define Transaction ?
A Transaction is a logical unit of work that comprises one or more SQL statements executed by a single user. Read more »
What is an Index ? How it is implemented in Oracle Database ?
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... Read more »
What is a Database instance ? Explain
A database instance (Server) is a set of memory structure and background processes that access a set of database files. The process can be shared by all users. The... Read more »
What is user Account in Oracle database?
An user account is not a physical structure in Database but it is having important relationship to the objects in the database and will be having certain privileges. Read more »
What are the Built-ins used for sending Parameters to forms?
You can pass parameter values to a form when an application executes the call_form, New_form, Open_form or Run_product. Read more »
Explain about stacked canvas views?
Stacked canvas view is displayed in a window on top of, or “stacked” on the content canvas view assigned to that same window. Stacked canvas views obscure some... Read more »
How do you call other Oracle Products from Oracle Forms?
Run_product is a built-in, Used to invoke one of the supported oracle tools products and specifies the name of the document or module to be run. If the called product... Read more »
What is the difference between a SYNONYM and a VIEW ?
A SYNONYM is a name assigned to a table or view that may thereafter be used to refer it. If you access to another user’s table, you may create a synonym for... Read more »
What is Log Switch ?
The point at which ORACLE ends writing to one online redo log file and begins writing to another is called a log switch. Read more »
What is On-line Redo Log?
The On-line Redo Log is a set of tow or more on-line redo files that record all committed changes made to the database. Whenever a transaction is committed, the... Read more »
What is the use of Control File ?
When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation... Read more »
Can you have more than one content canvas view attached with a window?
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... Read more »
What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
The OPTIMIZER_MODE initialization parameter Statistics in the Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement. Read more »
What is Function of Optimizer?
The goal of the optimizer is to choose the most efficient way to execute a SQL statement. Read more »
What is execution plan?
The combinations of the steps the optimizer chooses to execute a statement is called an execution plan. Read more »
What does rollback do?
ROLLBACK retracts any of the changes resulting from the SQL statements in the transaction. Read more »
What is save point?
For long transactions that contain many SQL statements, intermediate markers or savepoints can be declared which can be used to divide a transaction into smaller... Read more »