How is possible to restrict the user to a list o

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

378. 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.

(Continued on next question...)

Other Job Interview Questions

• Explicit Cursor attributes
• Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?
• Database Links
• How to implement the multiple control files for an existing database?
• What is schema?
• What are the master-detail triggers?
• What causes the "snapshot too old" error? How can this be prevented or mitigated?
• What is RULE-based approach to optimization?
• What are PL/SQL Cursor Exceptions?
• Explain the use of setting GLOBAL_NAMES equal to TRUE.
• More...