• +91 9971497814
  • info@interviewmaterial.com

Computer Interview Questions Answers

Oracle Interview Questions Answers

Question - 61 : - How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?

Answer - 61 : - By dragging the column outside the group.

Question - 62 : - What are the default extensions of the files created by library module?

Answer - 62 : - The default file extensions indicate the library module type and storage format .pll - pl/sql library module binary

Question - 63 : - What is a Tablespace?

Answer - 63 : - A database is divided into Logical Storage Unit called tablespace. A tablespace is used to grouped related logical structures together

Question - 64 : - What is the use of image_zoom built-in?

Answer - 64 : - To manipulate images in image items.

Question - 65 : - What are the different approaches used by Optimizer in choosing an execution plan ?

Answer - 65 : - Rule-based and Cost-based.

Question - 66 : - How do you display console on a window ?

Answer - 66 : - The console includes the status line and message line, and is displayed at the bottom of the window to which it is assigned.To specify that the console should be displayed, set the console window form property to the name of any window in the form. To include the console, set console window to Null.

Question - 67 : - What does a Control file Contain ?

Answer - 67 : - A Control file records the physical structure of the database. It contains the following information. Database Name Names and locations of a database's files and redolog files. Time stamp of database creation.

Question - 68 : - What is a Text_io Package?

Answer - 68 : - It allows you to read and write information to a file in the file system.

Question - 69 : - What are the components of logical database structure of Oracle database?

Answer - 69 : - There are tablespaces and database's schema objects.

Question - 70 : - What are the options available to refresh snapshots ?

Answer - 70 : - COMPLETE - Tables are completely regenerated using the snapshots query and the master tables every time the snapshot referenced. FAST - If simple snapshot used then a snapshot log can be used to send the changes to the snapshot tables. FORCE - Default value. If possible it performs a FAST refresh; Otherwise it will perform a complete refresh.

Computer Contributors

krishan
Rajeev Katiyar
Yes Baroda

Share your email for latest updates

Name:
Email:

Our partners