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

Oracle DBA Interview Questions Part 9

What are different types of images? - Boiler plate images, Image Items

What is the difference between boiler plat images and image items? - Boiler plate Images are static images (Either vector or bit map) that you import from the file system or database to use a graphical elements in your form, such as company logos and maps. Image items are special types of interface controls that store and display either vector or bitmap images. Like other items that store values, image items can be either base table items (items that relate directly to database columns) or control items. The definition of an image item is stored as part of the form module FMB and FMX files, but no image file is actually associated with an image item until the item is populate at run time.

What is bind reference and how can it be created? - Bind reference are used to replace the single value in sql, pl/sql statements a bind reference can be created using a (:) before a column or a parameter name.

What are the triggers available in the reports? - Before report, Before form, After form , Between page, After report.

Give the sequence of execution of the various report triggers? - Before form , After form , Before report, Between page, After report.

Why is a Where clause faster than a group filter or a format trigger? - Because in a where clause the condition is applied during data retrieval, then after retrieving the data.

Why is it preferable to create a fewer no. of queries in the data model? - Because for each query, report has to open a separate cursor and has to rebind, execute and fetch data.

Where is the external query executed at the client or the server? - At the server.

Where is a procedure return in an external pl/SQL library executed at the client or at the server? - At the client.

What is coordination Event? - Any event that makes a different record in the master block the current record is a coordination causing event.

What is the difference between OLE Server & OLE Container? - An Ole server application creates ole Objects that are embedded or linked in ole Containers ex. Ole servers are ms_word & ms_excel. OLE containers provide a place to store, display and manipulate objects that are created by ole server applications. Ex. oracle forms is an example of an ole Container.

What is an object group? - An object group is a container for a group of objects; you define an object group when you want to package related objects, so that you copy or reference them in other modules.

What is an LOV? - An LOV is a scrollable popup window that provides the operator with either a single or multi column selection list.

At what point of report execution is the before Report trigger fired? - After the query is executed but before the report is executed and the records are displayed.

What are the built -ins used for Modifying a groups structure? - ADD-GROUP_COLUMN (function) ADD_GROUP_ROW (procedure) DELETE_GROUP_ROW(procedure)

What is an user exit used for? - A way in which to pass control (and possibly arguments ) form Oracle report to another Oracle products of 3 GL and then return control ( and ) back to Oracle reports.

What is the User-Named Editor? - A user named editor has the same text editing functionality as the default editor, but, because it is a named object, you can specify editor attributes such as windows display size, position, and title.

What are the Built-ins to display the user-named editor? - A user named editor can be displayed programmatically with the built in procedure SHOW-EDITOR, EDIT_TETITEM independent of any particular text item.

What is a Static Record Group? - A static record group is not associated with a query, rather, you define its structure and row values at design time, and they remain fixed at runtime.

What is a record group? - A record group is an internal Oracle Forms that structure that has a column/row framework similar to a database table. However, unlike database tables, record groups are separate objects that belong to the form module which they are defined.

How many number of columns a record group can have? - A record group can have an unlimited number of columns of type CHAR, LONG, NUMBER, or DATE provided that the total number of column does not exceed 64K.

What is a Query Record Group? - A query record group is a record group that has an associated SELECT statement. The columns in a query record group derive their default names, data types, had lengths from the database columns referenced in the SELECT statement. The records in query record group are the rows retrieved by the query associated with that record group.

What is a Non Query Record Group?

What is a property clause? - A property clause is a named object that contains a list of properties and their settings. Once you create a property clause you can base other object on it. An object based on a property can inherit the setting of any property in the clause that makes sense for that object.

Oracle DBA Interview Questions Part 8

What are different types of modules available in oracle form? - Form module - a collection of objects and code routines Menu modules - a collection of menus and menu item commands that together make up an application menu library module - a collection of user named procedures, functions and packages that can be called from other modules in the application

What is the remove on exit property? - For a modeless window, it determines whether oracle forms hides the window automatically when the operators navigates to an item in the another window.

What is WHEN-Database-record trigger? - Fires when oracle forms first marks a record as an insert or an update. The trigger fires as soon as oracle forms determines through validation that the record should be processed by the next post or commit as an insert or update. Generally occurs only when the operators modifies the first item in the record, and after the operator attempts to navigate out of the item.

What is a difference between pre-select and pre-query? - Fires during the execute query and count query processing after oracle forms constructs the select statement to be issued, but before the statement is actually issued. The pre-query trigger fires just before oracle forms issues the select statement to the database after the operator as define the example records by entering the query criteria in enter query mode. Pre-query trigger fires before pre-select trigger.

What are built-ins associated with timers? - find_timer create_timer delete_timer

What are the built-ins used for finding object ID functions? - Find_group(function) Find_column(function)

What are the built-ins used for finding Object ID function? - FIND_GROUP(function) FIND_COLUMN(function)

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed? - False

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

Use the add_group_column function to add a column to record group that was created at a design time? - False

What are the various sub events a mouse double click event involves? - What are the various sub events a mouse double click event involves? - Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.

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? - By dragging the column outside the group.

What is the use of place holder column? - What are the various sub events a mouse double click event involves? - A placeholder column is used to hold calculated values at a specified place rather than allowing is to appear in the actual row where it has to appear.

What is the use of hidden column? - What are the various sub events a mouse double click event involves? - A hidden column is used to when a column has to embed into boilerplate text.

What is the use of break group? - What are the various sub events a mouse double click event involves? - A break group is used to display one record for one group ones. While multiple related records in other group can be displayed.

What is an anchoring object & what is its use? - What are the various sub events a mouse double click event involves? - An anchoring object is a print condition object which used to explicitly or implicitly anchor other objects to itself.

What are the various sub events a mouse double click event involves? - What are the various sub events a mouse double click event involves? - Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.

What are the default parameter that appear at run time in the parameter screen? - What are the various sub events a mouse double click event involves? - Destype and Desname.

What are the built-ins used for Creating and deleting groups? - CREATE-GROUP (function) CREATE_GROUP_FROM_QUERY(function) DELETE_GROUP(procedure)

What are different types of canvas views? - Content canvas views Stacked canvas views Horizontal toolbar vertical toolbar.

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

What is relation between the window and canvas views? - Canvas views are the back ground objects on which you place the interface items (Text items), check boxes, radio groups etc.,) and boilerplate objects (boxes, lines, images etc.,) that operators interact with us they run your form . Each canvas views displayed in a window.

What is a User_exit? - Calls the user exit named in the user_exit_string. Invokes a 3Gl program by name which has been properly linked into your current oracle forms executable.

How is it possible to select generate a select set for the query in the query property sheet? - By using the tables/columns button and then specifying the table and the column names.

How can values be passed between precompiler exits & Oracle call interface? - By using the statement EXECIAFGET & EXECIAFPUT.

How can a square be drawn in the layout editor of the report writer? - By using the rectangle tool while pressing the (Constraint) key.

How can a text file be attached to a report while creating in the report writer? - By using the link file property in the layout boiler plate property sheet.

How can I message to passed to the user from reports? - By using SRW.MESSAGE function.

How is possible to restrict the user to a list of values while entering values for parameters? - By setting the Restrict To List property to true in the parameter property sheet.

How can a button be used in a report to give a drill down facility? - By setting the action associated with button to Execute pl/SQL option and using the SRW.Run_report function.

How can a cross product be created? - By selecting the cross products tool and drawing a new group surrounding the base group of the cross products.