What are parameters?

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

(Continued from previous question...)

308. What are parameters?

Parameters provide a simple mechanism for defining and setting the values of inputs that are required by a form at startup. Form parameters are variables of type char, number, date that you define at design time.

(Continued on next question...)

Other Job Interview Questions

• A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
• What are the two phases of block coordination?
• What is a correlated subquery?
• What is the maximum no of chars the parameter can store?
• How can we specify the Archived log file name format and destination?
• How can a cross product be created?
• How would you change all occurrences of a value using VI?
• What is the proper method for disabling and re-enabling a primary key constraint?
• Compare and contrast TRUNCATE and DELETE for a table.
• Is it possible to disable the parameter from while running the report?
• More...