Interview Material

Oracle Interview Questions Answers

Oracle Interview Question - 136 : -

What are Roles ?

Oracle Interview Answer - 136 : -

Roles are named groups of related privileges that are granted to users or other roles.

Oracle Interview Answer - 138 : -

A Control file records the physical structure of the database. It contains the following information.
Database Name
Names and locations of a database's files and redolog files.
Time stamp of database creation.

Oracle Interview Question - 139 : -

What are the master-detail triggers?

Oracle Interview Answer - 139 : -

On-Check_delete_masterOn_clear_detailsOn_populate_details

Oracle Interview Question - 140 : -

What is trigger associated with the timer?

Oracle Interview Answer - 140 : -

When-timer-expired.

Oracle Interview Question - 141 : -

Does a grouping done for objects in the layout editor affect the grouping done in the data model editor?

Oracle Interview Answer - 141 : -

No.

Oracle Interview Question - 142 : -

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

Oracle Interview Answer - 142 : -

get_lov_property
set_lov_property

Oracle Interview Question - 143 : -

How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?

Oracle Interview Answer - 143 : -

By dragging the column outside the group.

Oracle Interview Question - 144 : -

What is snapshot log ?

Oracle Interview Answer - 144 : -

It is a table that maintains a record of modifications to the master table in a snapshot. It is stored in the same database as master table and is only available for simple snapshots. It should be created before creating snapshots.

Oracle Interview Question - 145 : -

How do you display console on a window ?

Oracle Interview Answer - 145 : -

The console includes the status line and message line, and is displayed at the bottom of the window to which it is assigned.To specify that the console should be displayed, set the console window form property to the name of any window in the form. To include the console, set console window to Null.

Oracle Interview Question - 146 : -

What is the remove on exit property?

Oracle Interview Answer - 146 : -

For a modelless window, it determines whether oracle forms hides the window automatically when the operators navigates to an item in the another window.

Oracle Interview Question - 147 : -

What is a synonym?

Oracle Interview Answer - 147 : -

A synonym is an alias for a table, view, sequence or program unit.

Oracle Interview Question - 148 : -

What are parameters?

Oracle Interview Answer - 148 : -

Parameters provide a simple mechanism for defining and setting the valuesof inputs that are required by a form at startup. Form parameters are variables of type char,number,date that you define at design time.

Oracle Interview Question - 149 : -

What are the built-in used for getting cell values?

Oracle Interview Answer - 149 : -

Get_group_char_cell(function)
Get_groupcell(function)
Get_group_number_cell(function)

Oracle Interview Question - 150 : -

How do I find used/free space in a TEMPORARY tablespace?

Oracle Interview Answer - 150 : -

Unlike normal tablespaces, true temporary tablespace information is not listed in DBA_FREE_SPACE. Instead use the V$TEMP_SPACE_HEADER view:
SELECT tablespace_name, SUM (bytes used), SUM (bytes free)
FROM V$temp_space_header
GROUP BY tablespace_name;