Interview Material

Oracle Interview Questions Answers

Oracle Interview Question - 16 : -

What are the two repeating frame always associated with matrix object?

Oracle Interview Answer - 16 : -

One down repeating frame below one across repeating frame.

Oracle Interview Answer - 19 : -

A column defined as UNIQUE can contain Nulls while a column defined as PRIMARY KEY can't contain Nulls.

Oracle Interview Question - 20 : -

What are the different types of Delete details we can establish in Master-Details?

Oracle Interview Answer - 20 : -

Cascade
Isolate
Non-isolate

Oracle Interview Question - 21 : -

Use the Add_group_row procedure to add a row to a static record group 1. true or false?

Oracle Interview Answer - 21 : -

False

Oracle Interview Question - 22 : -

What is the Maximum allowed length of Record group Column?

Oracle Interview Answer - 22 : -

Record group column names cannot exceed 30 characters.

Oracle Interview Question - 23 : -

What are the built-ins used for processing rows?

Oracle Interview Answer - 23 : -

Get_group_row_count(function)
Get_group_selection_count(function)
Get_group_selection(function)
Reset_group_selection(procedure)
Set_group_selection(procedure)
Unset_group_selection(procedure)

Oracle Interview Question - 24 : -

Explain the relationship among database, tablespace and data file ?

Oracle Interview Answer - 24 : -

Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace.

Oracle Interview Question - 25 : -

What are the types of synonyms?

Oracle Interview Answer - 25 : -

There are two types of synonyms private and public.

Oracle Interview Question - 26 : -

How can a text file be attached to a report while creating in the report writer?

Oracle Interview Answer - 26 : -

By using the link file property in the layout boiler plate property sheet.

Oracle Interview Question - 27 : -

What are roles? How can we implement roles ?

Oracle Interview Answer - 27 : -

Roles are the easiest way to grant and manage common privileges needed by different groups of database users. Creating roles and assigning provides to roles. Assign each role to group of users. This will simplify the job of assigning privileges to individual users.

Oracle Interview Question - 28 : -

What is a Database instance ? Explain

Oracle Interview Answer - 28 : -

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 memory structure that are used to store most queried data from database. This helps up to improve database performance by decreasing the amount of I/O performed against data file.

Oracle Interview Question - 29 : -

What is Statement Auditing ?

Oracle Interview Answer - 29 : -

Statement auditing is the auditing of the powerful system privileges without regard to specifically named objects.

Oracle Interview Question - 30 : -

What is SGA?

Oracle Interview Answer - 30 : -

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.