Jul 31 2009 in Interviews

Oracle Interview Questions – Part B





-- Sponsored Ads -- 



-- Sponsored Ads -- 



  • An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?
  • Can a property clause itself be based on a property clause?
  • Can you have more than one content canvas view attached with a window?
  • Describe two phases of Two-phase commit ?
  • Differentiate simple and complex, snapshots ?
  • Do a view contain data?
  • Does a Before form trigger fire when the parameter form is suppressed?
  • Does Oracle write to data files in begin/hot backup mode? (for DBA )
  • Explain about horizontal, Vertical tool bar canvas views?
  • Explain about stacked canvas views?
  • How can one see who is using a temporary segment? (for DBA )
  • How can we reduce the network traffic?
  • How can we specify the Archived log file name format and destination?
  • How can you Enforce Referential Integrity in snapshots ?
  • How do I find used/free space in a TEMPORARY tablespace? (for DBA )
  • How do you create a new session while open a new form?
  • How do you display console on a window ?
  • How do you reference a parameter indirectly?
  • How does one backup a database using RMAN? (for DBA )
  • How does one backup archived log files? (for DBA )
  • How does one do off-line database backups? (for DBA )
  • How does one do on-line database backups? (for DBA )
  • How does one get the view definition of fixed views/tables?
  • How does one put a database into ARCHIVELOG mode? (for DBA )
  • How does one see the uptime for a database? (for DBA )
  • How will you enforce security using stored procedures?
  • How will you enforce security using stored procedures?
  • If a parameter is used in a query without being previously defined, what diff. exist between. report 2.0 and 2.5 when the query is applied?
  • If two groups are not linked in the data model editor, What is the hierarchy between them?
  • Is the After report trigger fired if the report execution fails?
  • State any three mouse events system variables?
  • What are clusters?
  • What are Most Common types of Complex master-detail relationships?
  • What are the benefits of distributed options in databases?
  • What are the built-ins that are used to Attach an LOV programmatically to an item?
  • What are the Built-ins used for sending Parameters to forms?
  • What are the Coordination Properties in a Master-Detail relationship?
  • What are the default extensions of the files created by library module?
  • What are the dictionary tables used to monitor a database space?
  • What are the dictionary tables used to monitor a database spaces ?
  • What are the different file extensions that are created by oracle reports?
  • What are the different Parameter types?
  • What are the different windows events activated at runtimes?
  • What are the factors causing the reparsing of SQL statements in SGA?
  • What are the options available to refresh snapshots ?
  • What are the sql clauses supported in the link property sheet?
  • What are the trigger associated with image items?
  • What are the two phases of block coordination?
  • What are the two types of views available in the object navigator(specific to report 2.5)?
  • What are the types of calculated columns available?
  • What are the various type of snapshots?
  • What are the vbx controls?
  • What are the ways to monitor the performance of the report?
  • What are visual attributes?
  • What dynamic data replication?
  • What is a data segment?
  • What is a profile ?
  • What is a shared pool?
  • What is a SNAPSHOT ?
  • What is a SNAPSHOT LOG ?
  • What is a SQL * NET?
  • What is a text list?
  • What is a timer?
  • What is cluster key?
  • What is difference between open_form and call_form?
  • What is Distributed database ?
  • What is mean by Program Global Area (PGA)?
  • What is new_form built-in?
  • What is pop list?
  • What is SGA?
  • What is snapshot log ?
  • What is snapshots?
  • What is strip sources generate options?
  • What is term?
  • What is the “LOV of Validation” Property of an item? What is the use of it?
  • What is the basic data structure that is required for creating an LOV?
  • What is the diff. when confine mode is on and when it is off?
  • What is the diff. when Flex mode is mode on and when it is off?
  • What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?
  • What is the maximum no of chars the parameter can store?
  • What is the mechanism provided by ORACLE for table replication ?
  • What is the purpose of the product order option in the column property sheet?
  • What is the use of image_zoom built-in?
  • What is the use of transactional triggers?
  • What is trigger associated with the timer?
  • What is Two-Phase Commit ?
  • What is use of term?
  • What is user Account in Oracle database?
  • What is user Account in Oracle database?
  • When do you use data parameter type?
  • When will the data in the snapshot log be used?
  • Where are my TEMPFILES, I don’t see them in V$DATAFILE or DBA_DATA_FILE? (for DBA )
  • Which of the two views should objects according to possession?
  • Share This Post

    This post was tagged with the following: , , , , , , ,

    Use the forms below to leave a comment. Name and e-Mail are required. e-Mail is never shared.

    You must be logged in to post a comment.