101⟩ How do you list the files in an UNIX directory while also showing hidden files?
ls -ltra
Database Administrator (DBA)
Home Databases Programming Database Administrator (DBA)
“If you a Database Administrator and need to update DBA technical knowledge or need to prepare for a job interview? Then you are at eht right place explore this collection of DATABASE Administrator (DBA) Interview Questions and Answers here. This DBA Interview Questions and Answers are basic and advance level so every one who is DBA can get more help with these database interview questions and answers tutorial and guide.”
253 Database Administrator (DBA) Questions And Answers
102⟩ Can a formula column be obtained through a select statement?
Yes a formula column be obtained through a select statement
103⟩ Can a formula column referred to columns in higher group?
Yes a formula column referred to columns in higher group
104⟩ How do you execute a UNIX command in the background?
Use the "&"
Use the "*amp"
105⟩ 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
106⟩ If a parameter is used in a query without being previously defined, what diff. exist between report 2.0 and 2.5 when the query is applied?
While both reports 2.0 and 2.5 create the parameter, report 2.5 gives a message that a bind parameter has been created.
107⟩ What is trigger associated with the timer?
When-timer-expired.
108⟩ What are the SQL clauses supported in the link property sheet?
Where start with having.
109⟩ 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 products invoked with the run_product built-in subprogram.
110⟩ 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.
111⟩ 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.
112⟩ How would you change all occurrences of a value using VI?
Use :%s/<old>/<new>/g
113⟩ What are visual attributes?
Visual attributes are the font, color, pattern proprieties that you set for form and menu objects that appear in your application interface.
114⟩ Briefly, how do you install Oracle software on UNIX.
Basically, set up disks, kernel parameters, and run orainst.
115⟩ 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.
116⟩ Give two UNIX kernel parameters that effect an Oracle install
SHMMAX & SHMMNI
117⟩ Which of the two views should objects according to possession?
view by structure.
118⟩ What is the use of transactional triggers?
Using transactional triggers we can control or modify the default functionality of the oracle forms.
119⟩ What are the two types of views available in the object navigator (specific to report 2.5)?
View by structure and view by type .
120⟩ How do you create a new session while open a new form?
Using open_form built-in setting the session option Ex. Open_form (’Stocks ‘,active,session). when invoke the multiple forms with open form and call_form in the same application, state whether the following are true/False
