DBA > Interview Resource

DataBase Administrator (DBA) Interview Questions and Answers

Part:   1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  47  48  49  50  51 

(Continued from previous part...)

252. What is trigger associated with the timer?

When-timer-expired.


253. What are the trigger associated with image items?

When-image-activated fires when the operators double clicks on an image itemwhen-image-pressed fires when an operator clicks or double clicks on an image item


254. What are the different windows events activated at runtimes?

When_window_activated When_window_closed When_window_deactivated When_window_resized Within this triggers, you can examine the built in system variable system. event_window to determine the name of the window for which the trigger fired.


255. When do you use data parameter type?

When the value of a data parameter being passed to a called product is always the name of the record group defined in the current form. Data parameters are used to pass data to produts invoked with the run_product built-in subprogram.


256. What is difference between open_form and call_form?

When one form invokes another form by executing open_form the first form remains displayed, and operators can navigate between the forms as desired. when one form invokes another form by executing call_form, the called form is modal with respect to the calling form. That is, any windows that belong to the calling form are disabled, and operators cannot navigate to them until they first exit the called form.


257. How would you change all occurrences of a value using VI?

Use :%s/<old>/<new>/g


258. Give two UNIX kernel parameters that effect an Oracle install

SHMMAX & SHMMNI


258. Briefly, how do you install Oracle software on UNIX.

Basically, set up disks, kernel parameters, and run orainst.


259. What is the diff. when confine mode is on and when it is off?

When confine mode is on, an object cannot be moved outside its parent in the layout.

(Continued on next part...)

Part:   1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  47  48  49  50  51