What is the difference between static and dynamic lov

Scheduler is a process which runs programmed jobs at scheduled times. This process wakes up at the specified time and runs automatically. The basic elements of the scheduler are: Jobs Schedules Programs A job specifies what needs to be executed and when. A program is a collection of metadata that will be executed by the scheduler. A schedule specifies when and how many times a job is executed. Login to the database using Toad, and create a Scheduler Job as follows;.

July 17, What are Packages in Oracle Database A package is a group of procedures, functions, variables and SQL statements created as a single unit. It is used to store together related objects. A package has two parts, Package Specification and Package Body. Package Specification Package Specification acts as an interface to the package.

Declaration of types, variables, constants, exceptions, cursors and subprograms is done in Package specifications. Other Interview Questions Is it possible to split the print reviewer into more than one region? Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size? For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?

Can a field be used in a report without it appearing in any data group? The join defined by the default data link is an outer join yes or no? Can a formula column referred to columns in higher group? Can a formula column be obtained through a select statement?

Is it possible to insert comments into sql statements return in the data model editor? Is it possible to disable the parameter from while running the report? Explain the difference between a hot backup and a cold backup and the benefits associated with each. You have just had to restore from backup and do not have any control files. How would you go about bringing up this database? How do you switch from an init. Explain the difference between a data block, an extent and a segment.

Give two examples of how you might determine the structure of the table DEPT. Where would you look for errors from the database engine? Give the reasoning behind using an index. Give the two types of tables involved in producing a star schema and the type of data they hold. What type of index should you use on a fact table? Give two examples of referential integrity constraints. 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 command would you use to create a backup control file? Give the stages of instance startup to a usable state where normal users may access it. How would you go about increasing the buffer cache hit ratio? How would you determine the time zone under which a database was operating?

Explain the use of table functions. Name three advisory statistics you can collect. Where in the Oracle directory tree structure are audit traces placed? Explain materialized views and how they are used.

When a user process fails, what background process cleans up after it? What background process refreshes materialized views? How would you determine what sessions are connected and what resources they are waiting for?

Describe what redo logs are. How would you force a log switch? Give two methods you could use to determine what DDL changes have been made. What does coalescing a tablespace do? Name a tablespace automatically created when you create a database. When creating a user, what permissions must you grant to allow them to connect to the database?

How do you add a data file to a tablespace How do you resize a data file? What view would you use to look at the size of a data file? What view would you use to determine free space in a tablespace? How would you determine who has added a row to a table?

How can you rebuild an index? Explain what partitioning is and what its benefit is. How can you gather statistics on a table? How can you enable a trace for a session? Name two files used for network connection to a database. What is the function of Optimizer? What is Execution Plan? Can one resize tablespaces and data files?

Can one rename a tablespace? How does one create a standby database? What is a trace file and how is it created? What are the roles and user accounts created automatically with the database? What are the minimum parameters should exist in the parameter file init.

Why and when should I backup my database? How do you call other Oracle Products from Oracle Forms? What is the main diff.

Reports 2. What are the Built-ins to display the user-named editor? How many number of columns a record group can have? What is a Query Record Group? What does the term panel refer to with regard to pages? What is a master detail relationship? What is a library? What is an anchoring object and what is its use? What are the various sub events a mouse double click event involves? What is the use of break group? What tuning indicators can one use?

What package procedure is used for calling another form? When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text? The value recorded in system. Number b. Boolean c. What is hit ratio? How do you implement the If statement in the Select Statement How many types of Exceptions are there What are the inline and the precompiler directives How do you use the same lov for 2 columns How many minimum groups are required for a matrix report What is the difference between static and dynamic lov How does one manage Oracle database users?

How does one tune Oracle Wait events? What are the different objects that you cannot copy or reference in object groups? What is an OLE? Can a repeating frame be created without a data group as a base? Is it possible to set a filter condition in a cross product group in matrix reports?

What is Overloading of procedures? Explain the usage? What are the two parts of a procedure? Should the OEM Console be displayed at all times when there are scheduled jobs? What kind of jobs can one schedule with OEM? How does one backout events and jobs during maintenance slots?