Oracle interview questions -DBA

Oracle interview questions -DBA
What are the data types allowed in a table ?
What is the functionality of SYSTEM table space
What is meant by Scrollable cursor
What is an anchoring object & what is its use?
The use of HAVING , WHERE and GROUPBY in one SQL
What are the modes of parameters that can be
What is a canvas-view?
What is a Rollback segment entry ?
What are the trigger associated with image items?
Why is a Where clause faster than a group filter
Deleting a page removes information about all
What triggers are associated with the radio group?
How image_items can be populate to field in forms 4.0?
What is the difference between system.current
What is the use of TABLES option in EXP command ?
List the factors that can affect the accuracy of the estima
Where is a procedure return in an external pl/sql library
What are the types of database links
What is Network Database link ?
What are the steps involved in Database Startup ?
What is the maximum size of a form ?
What are the Restrictions on Cursor Variables?
What is a library in Forms 4.0?
How will you monitor rollback segment status ?
What is term?
What is SAVE POINT ?
How you open and close a cursor variable ?
How will you monitor the space allocation ?
What is Restricted Mode of Instance Startup ?
How many types of database triggers can be
Is it possible to attach same library to more than one form?
What are the built_in used to trapping errors in forms 4?
What is an Oracle sequence
What is a private synonym
What is the use of OWNER option in EXP command ?
What is an extent
What are three panes that appear in the run
What is the diff. when Flex mode is mode
What are visual attributes?
What is redo log buffer
What are the data types allowed in a table
How to do the scheduled task/jobs in Unix platform
An you change the default value of the radio
List the system variables related in Block and Field?
How the space utilization takes place within
What is the "LOV of Validation" Property of an item
Can a repeating frame be created without
What is the difference between OLE Server
What is Distributed database ?
What is the function of Optimizer ?
What are the different approaches used by Optimizer
How are Indexes Update ?
What is a Sequence ?
Can Full Backup be performed when
How can a square be drawn in the layout
What is subqueries, explain?
How can you call a form on a form
Which function of summary item is the
How can a break order be created on
What are the two parts of a procedure ?
What buil-in routines are used to display
What is OCI. What are its uses?
What are the different types of segments
What do you mean by a page ?
Can a property clause itself be based on
When can hash cluster used
How will you estimate the space required
What is the use of ANALYZE command ?
What are the characteristics of data files
What is an LOV?
What is Database Buffers
What is new_form built-in?
What is a logical backup?
What is difference between a PROCEDURE
What is a transaction ?
What are ORACLE PRECOMPILERS?
Explain how procedures and functions are
Can you change the alert messages at run-time?
When will be a segment released ?
How do you control the constraints in forms ?
What is the use of COMPRESS option in EXP command ?
Which of the two views should objects
Explain about content canvas views?
How many number of columns a record group can have?
What is Tablespace Quota ?
Different types of table join.
What is the function of Redo Log ?
What is self-referential integrity constraint ?
What is a Segment ?
What are the different modes of mounting
What are the various sub events a mouse
What is Statement Auditing ?
Explain Connect by Prior ?
What are the different types of key triggers ?
Is it possible to set a filter condition in a cross
What are the built-ins used for finding Object ID function?
What are the uses of Database Trigger ?
What are the types of canvas-views?
What are various joins used while writing SUBQUERIES?
What is a schema
What is Table ?
What is On-line Redo Log?
What are the different display styles of list items?
How to drop the index
What is an object group?
When does an on-lock trigger fire ?
What built-in is used for changing the properties
How do you trap the error in forms 3.0 ?
What is Index Cluster ?
What are the responsibilities of a Database
What is the use of ROWS option in EXP command ?
What is a library?
What are the factors that affect OPTIMIZER
What is a physical page & logical page ?
How will you monitor the space allocation
What are the different windows events activated
What is a Control file ?
Can you change the color of the push button
How are the index updates
Can we delete tuples in a table based on date column?
What is the maximum number of CHECK constraints
What is a Synonym ?
What are the steps involved in Instance Recovery ?
What are the different modals of windows?
What is referential integrity constraint
What is a Check Box?
What are the two phases of block coordination?
How does the command POST differs from COMMIT ?
What are the advantages of having a Package ?
List the built-in routine for controlling window
How to implement the multiple control files
What is an index segment
What is dictionary cache
What is database link
What are the different methods of backing
What are the sql clauses supported in
What is hit ratio
What is a Layout Editor?
What are ORACLE PRECOMPILERS?
State the difference between implict and explict cursor's
List some built-in routines used to manipulate
EXIT_FORM is a restricted package procedure ?
What is the disk migration?what isthe steps
What is the disk migration?what isthe steps
What are the different kind of export backups?
What is the diff. when confine mode is on and when it is off?
What are the important difference between property
What are the built -ins used for Modifying
Differentiate simple and complex, snapshots ?
What is row chaining
Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?
What is the use of image_zoom built-in?
What are the dictionary tables used to monitor
What is the use of FULL option in EXP command ?
What is Two-Phase Commit ?
What is a datafile
How can I message to passed to the user from reports?
What is mean by Program Global Area (PGA) ?
What is pop list?
What is SGA
What is a cursor for loop ?
What are the different types of SQL
What is difference between SUBSTR and INSTR?
What are the components of a PL/SQL Block ?
What is the built-in used to get and set lov
State the order in which these triggers are executed ?
What is use of rollback segments in Oracle database
What are the factors causing the reparsing
What are the ways to monitor the performance
What is the diff. bet. setting up of parameters
What is a property clause?
What are the different Levels of Auditing ?
What is DDL, DML?
What is a Data Dictionary ?
When can Hash Cluster used ?
Describe Referential Integrity ?
What are the advantages of operating a database
What is relation between the window and canvas views?
What is a segment
What are the different types of OUTER JOINS
What are the different types of Package Procedure ?
What is the advantage of the library?
What are built-ins used for Processing rows?
How many pages you can in a single form ?
Difference between procedure and function.
What is an Lov?
Which date function returns number value
What does a control file contains
What is the difference between a Function Key
What is the maximum no of chars the parameter can store?
What is a temporary segment
What is the purpose of the product order
What is default tablespace ?
What are the uses of rollback segment
What is a User_exit?
What is meant by recursive hints ?
What is trigger associated with the timer?
What is the role of PCTFREE parameter is storage clause
What are advantages of Stored Procedures
Implicit Cursor attributes
Display the number value in Words?
How to disable multiple triggers of a table at at a time?
List the built-in routines for the controlling
What is the difference between a POST-FIELD
What is the significance of having storage clause
How will you create multiple rollback segments
What are Most Common types of Complex master
What is a Text_io Package?
What is the use of place holder column?
What are the database administrators utilities avaliable ?
How is locking implemented?
What is the use of Redo Log Information ?
What is a Data File ?
What is Hash Cluster ?
What is Archived Redo Log ?
How can a text file be attached to a report while
Do you need a commit after DDL statements?
What is CYCLE/NO CYCLE in a Sequence ?
What Enter package procedure does ?
What are different types of modules available
What are the difference between lov & list item?
What is the content view and stacked view?
Difference between database triggers and form triggers?
What is a predefined exception available in forms 4.0?
How do I eliminate the duplicate rows
What is data block
What is a Trigger ?
What is the main difference between Reports 2.0 & Reports 2.5?
What is a Database instance ? Explain
What is strip sources generate options?
Can we decrease the Datafile size?
What is a deadlock ? Explain
What is WHEN-Database-record trigger?
What is the OPTIMAL parameter?
Explain about horizontal, Vertical tool
What is the difference between recovery
What is PL/SQL table ?
What is ROWID ?
Other way to replace query result null value with a text
How you will avoid your query from using indexes?
What is a stored procedure ?
System.effective_date system variable is
What SYNCHRONIZE procedure does ?
What is the use of INCTYPE option in EXP command ?
How will you monitor rollback segment status
What are the default extensions of the files
What is the difference between object embedding
What are the two panes that Appear in the
How will you enforce security using stored procedures?
What is a tablespace
What are the Limitations of a CHECK Constraint ?
What is a Data Segment ?
What is a Private Synonyms ?
What is Restricted Mode of Instance Startup ?
What are the Built-ins to display the user-named editor?
Do a view contain data
How do you find the numbert of rows in a Table ?
What is the difference between restricted and
What are the different types of Delete details we can
If a break order is set on a column would it affect
What are the types of visual attribute settings?
Display Odd/ Even number of records
How do you pass the parameters from one
Any three PL/SQL Exceptions
If the SQL * Plus hangs for a long time, what is the reason
minvalue.sql Select the Nth lowest value from a table
What is an OLE?
What does COMMIT do ?
Which of the above methods is the faster method?
What are the advantages of views
What is a profile ?
How do you reference a Parameter?
What is a data segment?
What is a timer?
What are the types of TRIGGERS ?
What are the differences between database
What is Referential Integrity ?
What is a Non- corelated subquery
Can a function take OUT parameters. If not why?
What are the components of a PL/SQL block ?
What is a display item?
When will ON-VALIDATE-FIELD trigger executed ?
List the factors that can affect the accuracy of the estimations?
How the space utilization takes place within rollback segments
What are the types of calculated columns available?
Name of the functions used to get/set canvas properties?
What are the default extensions of the files
How would you pass hints to the SQL processor?
What is an Oracle index
What are the uses of Rollback Segment ?
What is an Index Segment ?
What is Database Link ?
What is Partial Backup ?
What is a difference between pre-select and pre-query?
When does a Transaction end ?
How do you increase the performance of %LIKE operator
What do you mean by a pop-up window ?
What is a Static Record Group?
Explain about stacked canvas views?
What is the built-in function used for finding the alert?
How will you delete duplicating rows from a base table?
State the advatage and disadvantage of Cursor's
How to drop the column in a table
What is the fastest way of accessing a row in a table ?
What is the difference between media recovery &
What is forms_DDL?
What is synchronize?
What is a lookup table in database?
What is Object Auditing & Privilege Auditing ?
What are modal windows?
What are the Built-ins used for sending Parameters to forms?
When do you use data parameter type?
What is an Alert ?
What is an Alert ?
What are different modes of parameters used
What are the advantages of VIEW
Explain the different types of joins
Can you use a commit statement within a database trigger?
Can you attach an lov to a field at design time?
List the editors availables in forms 4.0?
What package procedure used for invoke sql *plus from sql *forms ?
What is use of LOG (Ver 7) option in EXP command ?
What is the use of IGNORE option in IMP command ?
How do you call other Oracle Products from Oracle Forms?
What is the remove on exit property?
How can you find all the tables created by an user?
What is an Oracle view
What is a Public Synonyms ?
Explain the relationship among Database,
What is a Tablespace?
What is Mirrored on-line Redo Log ?
What are the triggers available in the reports?
What is a Temporary Segment ?
What is Raise_application_error ?
What is the significance of PAGE 0 in forms 3.0 ?
What is a combo box?
What is use of term?
What are the menu items that oracle forms 4.0 supports?
What are cursor attributes?
Give the structure of the function ?
How you will avoid duplicating records in a query?
What is difference between Procedures and Functions ?
What are disadvantages of having raw devices ?
What are the built-ins used for Getting cell values?
What is Data Block ?
What are the built-ins that are used for setting
What are Schema Objects
What are roles? How can we implement roles ?
Can you pass data parameters to forms?
What is a text list?
Is it possible to split the print reviewer into
What ERASE package procedure does ?
What is a OUTER JOIN?
What is a cursor?
Difference between SUBSTR and INSTR ?
What is a pseudo column. Give some examples?
List the windows event triggers available in Forms 4.0?
Give built-in routine related to a record groups?
How can you execute the user defined triggers in forms 3.0 ?
What is the use of FILE option in IMP command ?
What is the use of ANALYSE ( Ver 7) option in EXP command ?
What is the basic data structure that is
What are built-ins associated with timers?
What is the mechanism provided by ORACLE
How to define data block size
What are the types of synonyms
What are the advantages of Views ?
What are the different type of Segments ?
What is Rollback Segment ?
What is Full Backup ?
What is the use of hidden column?
What is Public Database Link ?
What is an Exception ? What are types of Exception ?
What is a Package Procedure ?
How can you enable automatic archiving ?
What is the use of transactional triggers?
What is the built-in used for showing lov at runtime?
If the entire disk is corrupted how will you
What is spooling
How do I display row number with records
Give the structure of the procedure ?
What is a Control file
What are the built-ins used for Creating
What is an Index ?
How can a cross product be created?
What is Execution Plan ?
What is a SNAPSHOT LOG ?
What is the Maximum allowed length of Record group Column?
What are the different types of Record Groups?
What is the difference between keystartup and pre-form ?
Differentiate between TRUNCATE and DELETE
What is a cursor for loop?
How to access the current value and next
What are various privileges that a user
What are the triggers associated with the image item?
What do you mean by a block in forms4.0?
What is the difference between NAME_IN and COPY ?
What is advantage of having disk shadowing/ Mirroring ?
Which parameter can be used to set read level
What are display items?
What is SYSTEM tablespace and when is it created
What is a data segment
What are the types of Database Links ?
What are Clusters ?
What are the Characteristics of Data Files ?
Can we use GO-BLOCK package in a pre-field trigger ?
What is a master detail relationship?
What is COST-based approach to optimization ?
What are the display styles of an alert?
Why query fails sometimes ?
How can we reduce the network traffic?
Is the After report trigger fired if the report
What are the cursor attributes used in PL/SQL ?
Explain the usage of WHERE CURRENT OF clause in cursors ?
What are two parts of package ?
How many LONG columns are allowed in a table
What are the different type of a record group?
How redo logs can be achieved
What is bind reference and how can it be created?
Display the records between two range?
What is coordination Event?
What does ROLLBACK do ?
What is a SQL * NET?
What are the different Parameter types?
What are parameters?
When will be a segment released
What are the design facilities available in forms 4.0?
What is a database link
What are various constraints used in SQL?
To view installed Oracle version information
Shall we create procedures to fetch more than one record
List system variables available in forms 4.0,
What is an Alert?
What package procedure is used for calling
What is meant by Redo Log file mirroring ?
What is the use of INDEXES option in IMP command ?
What are difference between post database
How can values be passed bet. precompiler
What are the various type of snapshots?
What is the use of redo log information
What is a public synonym
What are the components of Physical database structure
What is a View ?
What is Log Switch ?
What is an User Exits ?
What are the benefits of distributed options in databases?
What is the use of Control File ?
What are the display styles of list items?
What is redo log file mirroring
What is the frame & repeating frame?
How will you force database to use particular rollback segment
What will happen after commit statement ?
What are the datatypes a available in PL/SQL ?
How can you see the source code of the package
How will you a activate/deactivate integrity constraints ?
Can you attach an alert to a field?
What is cold backup? What are the elements of it?
What is the User-Named Editor?
What is a Shared SQL pool?
What is an user exit used for?
What is Read-Only Transaction ?
What dynamic data replication?
How do you reference a parameter indirectly?
What are the vbx controls?
What is the use of INDEXES option in EXP command ?
Give the Types of modules in a form?
Can a view be updated/inserted/deleted
What is a view ?
What is meant by SORTING and GROUPING
What is difference between Rename and Alias?
What built-in is used for showing the alert during run-time?
Explain types of Block in forms4.0?
Two popup pages can appear on the screen at a time ?
What is the use of RECORD LENGTH option in EXP command ?
What is the use of GRANT option in EXP command?
From which designation is it preferred to send
What is the difference between boiler
What are the options available to refresh snapshots ?
What are the components of physical database
What is a database instance and Explain
What is Private Database Link ?
What is SYSTEM tablespace and when is it Created?
What is an Extent ?
What does a Control file Contain ?
What is SGA? How it is different from Ver 6.0 and Ver 7.0?
Describe two phases of Two-phase commit ?
Can a View based on another View ?
What are the differences between Database Trigger
What are the return values of functions SQLCODE and SQLERRM ?
What is the built-in routine used to count the
What is a rollback segment entry
Give the sequence of execution of the various
What is a Query Record Group?
What is the use of PARFILE option in EXP command ?
How can we plan storage for very large tables ?
Where the Pre_defined_exceptions are stored ?
When do you use WHERE clause and when
What is difference between TRUNCATE & DELETE ?
What is the difference between stored function
What is meant by redo log buffer ?