Oracle FAQs Questions with Answers # 10

Is it possible to modify an external query in a report which contains it?


Does a grouping done for objects in the layout editor affect the grouping done in the data model editor?


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?


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?


Can you pass data parameters to forms?


Is it possible to link two groups inside a cross products after the cross products group has been created?


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
What are the different default triggers created when Master Deletes Property is set to isolated?
Master Deletes Property Resulting Triggers
Isolated On-Clear-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

What is the diff. bet. setting up of parameters in reports 2.0 reports 2.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.

What is the advantage of the library?

Libraries provide a convenient means of storing client-side program units and sharing them among multiple applications. Once you create a library, you can attach it to any other form, menu, or library modules. When you can call library program units from triggers menu items commands and user named routine, you write in the modules to which you have attach the library. 

When a library attaches another library, program units in the first library can reference program units in the attached library. Library support dynamic loading-that is library program units are loaded into an application only when needed. This can significantly reduce the run-time memory requirements of applications.

What is lexical reference? How can it be created?

Lexical reference is place_holder for text that can be embedded in a sql statements. A lexical reference can be created using & before the column or parameter name.

What is system.coordination_operation?

It represents the coordination causing event that occur on the master block in master-detail relation.

Also read:

Have a Oracle Question
Do you have an Oracle Question?

Oracle Books
Oracle Certification, Database Administration, SQL, Application, Programming Reference Books

Oracle Application
Oracle Application Hints and Tips

Oracle Home
Oracle Database, SQL, Application, Programming Tips

All the site contents are Copyright © and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site is not affiliated with or endorsed by any company listed at this site.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of or the content authors.