Oracle DBA Interview Questions Part 10

What is a physical page? What is a logical page? - A physical page is a size of a page. That is output by the printer. The logical page is the size of one page of the actual report as seen in the Previewer.

What does the term panel refer to with regarda to pages? - A panel is the number of physical pages needed to print one logical page.

What is a master detail relationship? - A master detail relationship is an association between two base table blocks- a master block and a detail block. The relationship between the blocks reflects a primary key to foreign key relationship between the tables on which the blocks are based.

What is a library? - A library is a collection of subprograms including user named procedures, functions and packages.

How can a group in a cross products be visually distinguished from a group that does not form a cross product? - A group that forms part of a cross product will have a thicker border.

What is the frame & repeating frame? - A frame is a holder for a group of fields. A repeating frame is used to display a set of records when the number of records that are to displayed is not known before.

What is a combo box? - A combo box style list item combines the features found in list and text item. Unlike the pop list or the text list style list items, the combo box style list item will both display fixed values and accept one operator entered value.

What are three panes that appear in the run time pl/SQL interpreter? - Source pane, interpreter pane, navigator pane.

What are the two panes that Appear in the design time pl/SQL interpreter? - Source pane, interpreter pane

What are the two ways by which data can be generated for a parameters list of values? - Using static values, writing select statement.

What are the various methods of performing a calculation in a report? - Perform the calculation in the SQL statements itself, use a calculated / summary column in the data model.

What are the default extensions of the files created by menu module? - .mmb, .mmx

What are the default extensions of the files created by forms modules? - .fmb - form module binary .fmx - form module executable

To display the page number for each page on a report, what would be the source & logical page number or physical page number?

It is possible to use raw devices as data files and what is the advantages over file system files? - Yes. The advantages over file system files. I/O will be improved because Oracle is bypassing the kernel when writing to disk. Disk Corruption will decrease.

What are disadvantages of having raw devices? - We should depend on export/import utility for backup/recovery (fully reliable) The tar command cannot be used for physical file backup, instead we can use dd command which is less flexible and has limited recoveries.

What is the significance of having storage clause? - We can plan the storage for a table as how much initial extents are required, how much can be extended next, how much % should leave free for managing row updations etc.,

What is the use of INCTYPE option in EXP command? - Type export should be performed COMPLETE, CUMULATIVE, INCREMENTAL. List the sequence of events when a large transaction that exceeds beyond its optimal value when an entry wraps and causes the rollback segment to expand into a notion Completes. e. will be written.

What is the use of FILE option in IMP command? - The name of the file from which import should be performed.

What is a Shared SQL pool? - The data dictionary cache is stored in an area in SGA called the Shared SQL Pool. This will allow sharing of parsed SQL statements among concurrent users.

What is hot backup and how it can be taken? - Taking backup of archive log files when database is open. For this the ARCHIVELOG mode should be enabled. The following files need to be backed up. All data files. All Archive log, redo log files. All control files.

List the Optional Flexible Architecture (OFA) of Oracle database? How can we organize the tablespaces in Oracle database to have maximum performance?

SYSTEM - Data dictionary tables.

DATA - Standard operational tables.

DATA2- Static tables used for standard operations

INDEXES - Indexes for Standard operational tables.

INDEXES1 - Indexes of static tables used for standard operations.

TOOLS - Tools table.

TOOLS1 - Indexes for tools table.

RBS - Standard Operations Rollback Segments,

RBS1,RBS2 - Additional/Special Rollback segments.

TEMP - Temporary purpose tablespace

TEMP_USER - Temporary tablespace for users.

USERS - User tablespace.

How to implement the multiple control files for an existing database?

Shutdown the database

Copy one of the existing control file to new location

Edit Config ora file by adding new control filename

Restart the database.

What is advantage of having disk shadowing/ Mirroring? - Shadow set of disks save as a backup in the event of disk failure. In most Operating System if any disk failure occurs it automatically switches over to a working disk. Improved performance because most OS support volume shadowing can direct file I/O request to use the shadow set of files instead of the main set of files. This reduces I/O load on the main set of disks.

How will you force database to use particular rollback segment? - SET TRANSACTION USE ROLLBACK S