|
Oracle Interview Questions and Answers
What is the Maximum allowed length of Record group
Column?
Record group column names cannot exceed 30 characters.
Which parameter can be used to set read level
consistency across multiple queries?
Read only
What are the different types of Record Groups?
Query Record Groups
NonQuery Record Groups
State Record Groups
From which designation is it preferred to send the
output to the printed?
Previewer
What are difference between post database commit and
post-form commit?
Post-form commit fires once during the post and commit
transactions process, after the database commit occurs.
The post-form-commit trigger fires after inserts,
updates and deletes have been posted to the database but
before the transactions have been finalized in the
issuing the command. The post-database-commit trigger
fires after oracle forms issues the commit to finalized
transactions.
What are the different display styles of list items?
Pop_listText_listCombo box
Which of the above methods is the faster method?
performing the calculation in the query is faster.
With which function of summary item is the compute at
options required?
percentage of total functions.
What are parameters?
Parameters provide a simple mechanism for defining and
setting the valuesof inputs that are required by a form
at startup. Form parameters are variables of type
char,number,date that you define at design time.
What are the three types of user exits available ?
Oracle Precompiler exits, Oracle call interface,
NonOracle user exits.
How many windows in a form can have console?
Only one window in a form can display the console, and
you cannot change the console assignment at runtime.
What is an administrative (privileged) user? (for DBA )
Oracle DBAs and operators typically use administrative
accounts to manage the database and database instance.
An administrative account is a user that is granted
SYSOPER or SYSDBA privileges. SYSDBA and SYSOPER allow
access to a database instance even if it is not running.
Control of these privileges is managed outside of the
database via password files and special operating system
groups. This password file is created with the orapwd
utility.
What are the two repeating frame always associated with
matrix object?
One down repeating frame below one across repeating
frame.
What are the master-detail triggers?
On-Check_delete_masterOn_clear_detailsOn_populate_details
How does one connect to an administrative user? (for DBA
)
If an administrative user belongs to the "dba" group on
Unix, or the "ORA_DBA" (ORA_sid_DBA) group on NT, he/she
can connect like this:
connect / as sysdba
No password is required. This is equivalent to the
desupported "connect internal" method.
A password is required for "non-secure" administrative
access. These passwords are stored in password files.
Remote connections via Net8 are classified as
non-secure. Look at this example:
connect sys/password as sysdba
How does one create a password file? (for DBA )
The Oracle Password File ($ORACLE_HOME/dbs/orapw or
orapwSID) stores passwords for users with administrative
privileges. One needs to create a password files before
remote administrators (like OEM) will be allowed to
connect.
Follow this procedure to create a new password file:
. Log in as the Oracle software owner
. Runcommand: orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID
password=mypasswd
. Shutdown the database (SQLPLUS> SHUTDOWN IMMEDIATE)
. Edit the INIT.ORA file and ensure
REMOTE_LOGIN_PASSWORDFILE=exclusive is set.
. Startup the database (SQLPLUS> STARTUP)
NOTE: The orapwd utility presents a security risk in
that it receives a password from the command line. This
password is visible in the process table of many
systems. Administrators needs to be aware of this!
Is it possible to modify an external query in a report
which contains it?
No.
Does a grouping done for objects in the layout editor
affect the grouping done in the data model editor?
No.
How does one add users to a password file? (for DBA )
One can select from the SYS.V_$PWFILE_USERS view to see
which users are listed in the password file. New users
can be added to the password file by granting them
SYSDBA or SYSOPER privileges, or by using the orapwd
utility. GRANT SYSDBA TO scott;
If a break order is set on a column would it affect
columns which are under the column?
No
Why are OPS$ accounts a security risk in a client/server
environment? (for DBA)
If you allow people to log in with OPS$ accounts from
Windows Workstations, you cannot be sure who they really
are. With terminals, you can rely on operating system
passwords, with Windows, you cannot.
If you set REMOTE_OS_AUTHENT=TRUE in your init.ora file,
Oracle assumes that the remote OS has authenticated the
user. If REMOTE_OS_AUTHENT is set to FALSE
(recommended), remote users will be unable to connect
without a password. IDENTIFIED EXTERNALLY will only be
in effect from the local host. Also, if you are using
"OPS$" as your prefix, you will be able to log on
locally with or without a password, regardless of
whether you have identified your ID with a password or
defined it to be IDENTIFIED EXTERNALLY.
Do user parameters appear in the data modal editor in
2.5?
No
Can you pass data parameters to forms?
No
Is it possible to link two groups inside a cross
products after the cross products group has been
created?
no
What are the different modals of windows?
Modalless windows
Modal windows
What are modal windows?
Modal windows are usually used as dialogs, and have
restricted functionality compared to modelless windows.
On some platforms for example operators cannot resize,
scroll or iconify a modal window.
What are the different default triggers created when
Master Deletes Property is set to Non-isolated?
Master Deletes Property Resulting Triggers
----------------------------------------------------
Non-Isolated(the default) On-Check-Delete-Master
On-Clear-Details
On-Populate-Details
What are the different default triggers created when
Master Deletes Property is set to isolated?
Master Deletes Property Resulting Triggers
---------------------------------------------------
Isolated On-Clear-Details
On-Populate-Details
What are the different default triggers created when
Master Deletes Property is set to Cascade?
Master Deletes Property Resulting Triggers
---------------------------------------------------
Cascading On-Clear-Details
On-Populate-Details
Pre-delete
What is the diff. bet. setting up of parameters in
reports 2.0 reports2.5?
LOVs can be attached to parameters in the reports 2.5
parameter form.
What are the difference between lov & list item?
Lov is a property where as list item is an item. A list
item can have only one column, lov can have one or more
columns.
Page Numbers :
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
Have a Question ?
post your questions here. It
will be answered as soon as possible.
Check
Job Interview Questions
for more Interview Questions with Answers
|
