Oracle Interview Questions with Answers
Question: 1. What Is Oracle?
Answer:
Oracle is a organisation. Oracle is likewise a database server, which manages facts in a totally structured way. It lets in users to keep and retrieve associated data in a multiuser surroundings in order that many users can concurrently get entry to the identical facts. All this is done while handing over excessive overall performance. A database server additionally prevents unauthorized get entry to and presents green solutions for failure restoration.
Question: 2. What Is An Oracle Database?
Answer:
An Oracle database is a collection of records dealt with as a big unit inside the database server.
Oracle 9i Interview Questions
Question: three. What Is An Oracle Instance?
Answer:
Every going for walks Oracle database is associated with an Oracle instance. When a database is commenced on a database server (no matter the sort of laptop), Oracle allocates a memory location called the System Global Area (SGA) and begins one or more Oracle approaches. This mixture of the SGA and the Oracle procedures is referred to as an Oracle example. The reminiscence and procedures of an example manipulate the associated database’s data effectively and serve the one or more than one users of the database.
Question: 4. What Is Oracle Table?
Answer:
A table is the basic unit of statistics garage in an Oracle database. The tables of a database maintain all the person reachable facts. Table information is stored in rows and columns.
Oracle 9i Tutorial
Question: 5. What Is An Oracle View?
Answer:
A view is a virtual table. Every view has a question connected to it. (The query is a SELECT assertion that identifies the columns and rows of the desk(s) the view makes use of.)
Informatica Interview Questions
Question: 6. What Is An Oracle Sequence?
Answer:
A sequence generates a serial listing of specific numbers for numerical columns of a database’s tables.
Question: 7. What Is An Oracle Index?
Answer:
An index is an optionally available structure related to a desk to have direct get admission to to rows, which may be created to increase the performance of facts retrieval. Index can be created on one or extra columns of a table.
Informatica Tutorial PL/SQL Interview Questions
Question: eight. What Is An Oracle Data File?
Answer:
An Oracle records document is a huge unit of physical garage inside the OS document system. One or many Oracle data files are prepared collectively to provide physical storage to a unmarried Oracle tablespace.
Question: 9. What Are The Components Of Physical Database Structure Of Oracle Database?
Answer:
Oracle database is constructed from 3 types of files. One or extra datafiles, are more redo log documents, and one or greater control documents.
Oracle DBA Interview Questions
Question: 10. What Are The Components Of Logical Database Structure Of Oracle Database?
Answer:
There are tablespaces and database’s schema items.
Oracle DBA Tutorial
Question: eleven. What Is A Tablespace?
Answer:
A database is split into Logical Storage Unit referred to as tablespaces. A tablespace is used to grouped related logical structures together.
Oracle 11g Interview Questions
Question: 12. What Is System Tablespace And When Is It Created?
Answer:
Every Oracle database consists of a tablespace named SYSTEM, that’s automatically created while the database is created. The SYSTEM tablespace always contains the information dictionary tables for the entire database.
Oracle 9i Interview Questions
Question: 13. Explain The Relationship Among Database, Tablespace And Data File ?
Answer:
Each databases logically divided into one or greater tablespaces one or extra information files are explicitly created for every tablespace.
Oracle 11g Tutorial
Question: 14. What Is Schema?
Answer:
A schema is series of database gadgets of a person.
Question: 15. What Are Schema Objects?
Answer:
Schema items are the logical systems that without delay confer with the database’s data. Schema gadgets consist of tables, perspectives, sequences, synonyms, indexes, clusters, database triggers, techniques, capabilities programs and database hyperlinks.
SQL Interview Questions
Question: 16. Can Objects Of The Same Schema Reside In Different Tablespaces?
Answer:
Yes.
Unix/Linux Tutorial
Question: 17. Can A Tablespace Hold Objects From Different Schemes?
Answer:
Yes.
PL/SQL and Informatica Interview Questions
Question: 18. What Is Partial Backup ?
Answer:
A Partial Backup is any operating system backup brief of a complete backup, taken at the same time as the database is open or shut down.
Informatica Interview Questions
Question: 19. What Is Mirrored On-line Redo Log ?
Answer:
A mirrored online redo log includes copies of on-line redo log documents bodily located on separate disks, changes made to one member of the group are made to all contributors.
Question: 20. What Is Full Backup ?
Answer:
A full backup is an running system backup of all facts documents, online redo log files and control report that represent ORACLE database and the parameter.
Sybase Interview Questions
Question: 21. Can A View Based On Another View ?
Answer:
Yes.
Question: 22. Can A Tablespace Hold Objects From Different Schemes ?
Answer:
Yes.
Question: 23. Can Objects Of The Same Schema Reside In Different Tablespace ?
Answer:
Yes.
PL/I Interview Questions
Question: 24. What Is The Use Of Control File ?
Answer:
When an example of an ORACLE database is started, its manipulate file is used to become aware of the database and redo log documents that ought to be opened for database operation to continue. It is also utilized in database restoration.
PL/SQL Interview Questions
Question: 25. Do View Contain Data ?
Answer:
Views do not include or store facts.
Question: 26. What Are The Referential Actions Supported By Foreign Key Integrity Constraint ?
Answer:
UPDATE and DELETE Restrict – A referential integrity rule that disallows the update or deletion of referenced data.
DELETE Cascade – When a referenced row is deleted all related established rows are deleted.
Oracle MySQL 5.6 Database Administrator Interview Questions
Question: 27. What Are The Type Of Synonyms?
Answer:
There are two types of Synonyms
Private
Public.
Oracle DBA Interview Questions
Question: 28. What Is A Redo Log ?
Answer:
The set of Redo Log files YSDATE,UID,USER or USERENV SQL functions, or the pseudo columns LEVEL or ROWNUM.
Question: 29. What Is An Index Segment ?
Answer:
Each Index has an Index segment that stores all of its records.
Unix/Linux Interview Questions
Question: 30. Explain The Relationship Among Database, Tablespace And Data File?
Answer:
Each databases logically divided into one or extra tablespaces one or greater data documents are explicitly created for each tablespace.
Question: 31. What Are The Different Type Of Segments ?
Answer:
The distinct form of Segments are:
Data Segment,
Index Segment,
Rollback Segment and
Temporary Segment.
Question: 32. What Are Clusters ?
Answer:
Clusters are companies of one or greater tables bodily shops collectively to share not unusual columns and are regularly used together.
Oracle Apps Functional Interview Questions
Question: 33. What Is An Integrity Constrains ?
Answer:
An integrity constraint is a declarative manner to outline a commercial enterprise rule for a column of a table.
Oracle 11g Interview Questions
Question: 34. What Is An Index ?
Answer:
An Index is an optionally available shape associated with a desk to have direct get admission to to rows, which can be created to increase the performance of records retrieval. Index may be created on one or greater columns of a table.
Question: 35. What Is An Extent ?
Answer:
An Extent is a selected number of contiguous records blocks, received in a unmarried allocation, and used to save a selected form of information.
Question: 36. What Is A View ?
Answer:
A view is a virtual desk. Every view has a Query connected to it. (The Query is a SELECT announcement that identifies the columns and rows of the desk(s) the view makes use of.)
SQL Interview Questions
Question: 37. What Is Table ?
Answer:
A desk is the basic unit of facts storage in an ORACLE database. The tables of a database preserve all of the consumer accessible facts. Table statistics is stored in rows and columns.
Question: 38. Can A View Based On Another View?
Answer:
Yes.
Question: 39. What Are The Advantages Of Views?
Answer:
Provide an extra level of table safety, via restricting get right of entry to to a predetermined set of rows and columns of a table.
Hide data complexity.
Simplify instructions for the person.
Present the data in a exceptional perspective from that of the base desk.
Store complex queries.
Question: forty. What Is A Synonym?
Answer:
A synonym is an alias for a table, view, collection or program unit.
PL/SQL and Informatica Interview Questions
Question: forty one. What Are The Types Of Synonyms?
Answer:
There are styles of synonyms non-public and public.
Question: 42. What Is A Private Synonym?
Answer:
Only its owner can get admission to a private synonym.
Sybase Interview Questions
Question: 43. What Is A Public Synonym?
Answer:
Any database person can get entry to a public synonym.
Question: 44. What Are Synonyms Used For?
Answer:
Mask the real call and proprietor of an item.
Provide public get entry to to an object.
Provide region transparency for tables, views or application devices of a far flung database.
Simplify the SQL statements for database users.
Question: 45. How Are The Index Updates?
Answer:
Indexes are routinely maintained and used by Oracle. Changes to table information are robotically included into all applicable indexes.
Question: forty six. What Is Rollback Segment ?
Answer:
A Database consists of one or extra Rollback Segments to briefly save “undo” facts.
Question: 47. What Are The Characteristics Of Data Files ?
Answer:
A statistics file can be related to best one database. Once created a information record can not exchange size. One or more statistics files shape a logical unit of database storage known as a tablespace.
Question: forty eight. How To Define Data Block Size ?
Answer:
A statistics block length is certain for every ORACLE database whilst the database is created. A database customers and allocated unfastened database space in ORACLE facts blocks. Block size is specified in INIT.ORA document and might’t be modified latter.
Question: 49. What Does A Control File Contain ?
Answer:
A Control report facts the physical structure of the database. It incorporates the subsequent data.
Database Name
Names and places of a database’s documents and redolog documents.
Time stamp of database introduction.
Question: 50. What Is Difference Between Unique Constraint And Primary Key Constraint ?
Answer:
A column defined as UNIQUE can comprise Nulls whilst a column defined as PRIMARY KEY can not comprise Nulls.
Question: 51. What Is Index Cluster ?
Answer:
A Cluster with an index on the Cluster Key.
Question: 52. When Does A Transaction End ?
Answer:
When it’s miles devoted or Rollbacked.
Question: 53. What Is The Effect Of Setting The Value “all_rows” For Optimizer_goal Parameter Of The Alter Session Command ? What Are The Factors That Affect Optimizer In Choosing An Optimization Approach ?
Answer:
The OPTIMIZER_MODE initialization parameter Statistics within the Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER SESSION command recommendations inside the declaration.
Question: fifty four. What Is The Effect Of Setting The Value “pick out” For Optimizer_goal, Parameter Of The Alter Session Command ?
Answer:
The Optimizer chooses Cost_based technique and optimizes with the goal of pleasant throughput if records for atleast one of the tables accessed with the aid of the SQL statement exist within the information dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.
Question: fifty five. How Does One Create A New Database? (for Dba)
Answer:
One can create and regulate Oracle databases the use of the Oracle “dbca” (Database Configuration Assistant) application. The dbca software is located in the $ORACLE_HOME/bin directory. The Oracle Universal Installer (oui) typically starts it after putting in the database server software.
One can also create databases manually the usage of scripts. This option, however, is falling out of fashion, as it is pretty involved and blunders inclined. Look at this example for growing and Oracle 9i database:
CONNECT SYS AS SYSDBA
ALTER SYSTEM SET DB_CREATE_FILE_DEST=’/u01/oradata/’;
ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_1=’/u02/oradata/’;
ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_2=’/u03/oradata/’;
CREATE DATABASE;
Question: 56. What Database Block Size Should I Use? (for Dba)
Answer:
Oracle recommends that your database block size suit, or be multiples of your working machine block length. One can use smaller block sizes, however the overall performance cost is huge. Your preference need to depend upon the type of application you’re strolling. If you have many small transactions as with OLTP, use a smaller block size. With fewer however larger transactions, as with a DSS utility, use a larger block length. If you’re using a extent supervisor, remember your “working system block size” to be 8K. This is due to the fact quantity supervisor products use 8K blocks (and this is not configurable).
Question: fifty seven. What Are The Different Approaches Used By Optimizer In Choosing An Execution Plan ?
Answer:
The unique strategies used by Optimizer in choosing an execution plan are:
Rule-primarily based
Cost-based.
Question: 58. What Does Rollback Do ?
Answer:
ROLLBACK retracts any of the modifications resulting from the SQL statements within the transaction.
Question: 59. What Is Cost-based Approach To Optimization ?
Answer:
Considering to be had access paths and figuring out the maximum green execution plan based on statistics inside the information dictionary for the tables accessed by means of the declaration and their associated clusters and indexes.
Question: 60. What Does Commit Do ?
Answer:
COMMIT makes everlasting the modifications as a result of all SQL statements in the transaction. The changes made by the SQL statements of a transaction turn out to be seen to other user periods transactions that begin most effective after transaction is dedicated.
Question: sixty one. How Are Extents Allocated To A Segment? (for Dba)
Answer:
Oracle8 and above rounds off extents to a multiple of 5 blocks when greater than five blocks are requested. If one requests 16K or 2 blocks (assuming a 8K block length), Oracle does not round it up to 5 blocks, however it allocates 2 blocks or 16K as asked. If one asks for eight blocks, Oracle will round it up to 10 blocks.
Space allocation additionally depends upon the dimensions of contiguous free area available. If one asks for 8 blocks and Oracle unearths a contiguous unfastened space this is precisely eight blocks, it might deliver it you. If it have been 9 blocks, Oracle could also provide it to you. Clearly Oracle does not continually round extents to a a couple of of five blocks.
The exception to this rule is locally controlled tablespaces. If a tablespace is created with nearby volume management and the extent length is 64K, then Oracle allocates 64K or 8 blocks assuming 8K-block size. Oracle does not round it up to the more than one of five whilst a tablespace is domestically managed.
Question: 62. Can One Rename A Database User (schema)? (for Dba)
Answer:
No, that is indexed as Enhancement Request 158508. Workaround:
Do a person-stage export of person A
create new user B
Import gadget/supervisor fromuser=A touser=B
Drop person A
Question: sixty three. Define Transaction ?
Answer:
A Transaction is a logical unit of labor that comprises one or extra SQL statements finished through a single person.
Question: 64. What Is Read-handiest Transaction ?
Answer:
A Read-Only transaction ensures that the results of each question done in the transaction are consistant with admire to the same point in time.
Question: sixty five. What Is A Deadlock ? Explain
Answer:
Two strategies wating to replace the rows of a desk which are locked by the alternative process then impasse arises. In a database environment this may frequently happen due to now not issuing right row lock instructions. Poor layout of the front-quit software may additionally reason this case and the performance of server will reduce substantially.
These locks will be launched mechanically when a commit/rollback operation achieved or someone of this techniques being killed externally.
Question: sixty six. What Is A Schema ?
Answer:
The set of items owned through consumer account is called the schema.
Question: sixty seven. What Is A Cluster Key ?
Answer:
The related columns of the tables are known as the cluster key. The cluster key is indexed using a cluster index and its price is stored most effective as soon as for more than one tables inside the cluster.
Question: 68. What Is Parallel Server ?
Answer:
Multiple instances accessing the equal database (Only In Multi-CPU environments)
Question: 69. What Is Clusters ?
Answer:
Group of tables physically saved collectively because they share not unusual columns and are frequently used collectively is called Cluster.
Question: 70. What Is An Index ? How It Is Implemented In Oracle Database ?
Answer:
An index is a database shape utilized by the server to have direct get right of entry to of a row in a table. An index is routinely created when a completely unique of number one key constraint clause is specified in create desk comman (Ver 7.Zero).
Question: seventy one. What Is A Database Instance ? Explain
Answer:
A database example (Server) is a hard and fast of reminiscence structure and heritage methods that get entry to a set of database documents.
The procedure may be shared by means of all users. The reminiscence structure which can be used to keep maximum queried facts from database. This helps up to enhance database performance via lowering the quantity of I/O done against records file.
Question: 72. What Is The Use Of Analyze Command ?
Answer:
To carry out the sort of characteristic on an index, table, or cluster:
To acquire information approximately item used by the optimizer and keep them within the statistics dictionary.
To delete facts approximately the object utilized by item from the information dictionary.
To validate the structure of the object.
To identify migrated and chained rows of the table or cluster.
Question: 73. What Is Default Tablespace ?
Answer:
The Tablespace to incorporate schema objects created without specifying a tablespace name.
Question: 74. What Are The System Resources That Can Be Controlled Through Profile ?
Answer:
The wide variety of concurrent sessions the person can set up the CPU processing time available to the user’s consultation the CPU processing time available to a unmarried name to ORACLE made by means of a SQL statement the amount of logical I/O available to the person’s session the amout of logical I/O to be had to a single call to ORACLE made through a SQL assertion the allowed amount of idle time for the user’s consultation the allowed amount of join time for the user’s session.
Question: 75. What Is Tablespace Quota ?
Answer:
The collective quantity of disk space to be had to the items in a schema on a selected tablespace.
Question: 76. What Are The Different Levels Of Auditing ?
Answer:
The distinctive Levels of Auditing are:
Statement Auditing,
Privilege Auditing and
Object Auditing.
Question: seventy seven. What Is Statement Auditing ?
Answer:
Statement auditing is the auditing of the effective system privileges without regard to mainly named gadgets.
Question: seventy eight. What Are The Database Administrators Utilities Available ?
Answer:
SQL * DBA – This permits DBA to screen and manage an ORACLE database.
SQL * Loader – It loads records from popular working machine files (Flat documents) into ORACLE database tables.
Export (EXP) and Import (imp) utilities assist you to move existing records in ORACLE layout to and from ORACLE database.
Question: seventy nine. How Can You Enable Automatic Archiving ?
Answer:
Shut the database
Backup the database
Modify/Include LOG_ARCHIVE_START_TRUE in init.Ora file.
Start up the database.
Question: eighty. What Are Roles? How Can We Implement Roles ?
Answer:
Roles are the perfect way to provide and manipulate common privileges needed by means of extraordinary groups of database users. Creating roles and assigning offers to roles. Assign each function to organization of customers. This will simplify the activity of assigning privileges to man or woman users.
Question: 81. What Are Roles ?
Answer:
Roles are named companies of associated privileges which are granted to customers or different roles.
Question: eighty two. What Are The Use Of Roles ?
Answer:
The use of Roles are:
REDUCED GRANTING OF PRIVILEGES – Rather than explicitly granting the equal set of privileges to many users a database administrator can grant the privileges for a group of associated customers granted to a position and then furnish best the role to every member of the group.
DYNAMIC PRIVILEGE MANAGEMENT – When the privileges of a set must alternate, only the privileges of the function need to be modified. The security domain names of all customers granted the institution’s role automatically mirror the changes made to the function.
SELECTIVE AVAILABILITY OF PRIVILEGES – The roles granted to a consumer can be selectively allow (available for use) or disabled (now not available to be used). This lets in precise control of a user’s privileges in any given situation.
APPLICATION AWARENESS – A database utility may be designed to routinely allow and disable selective roles when a person attempts to use the utility.
Question: 83. What Is Privilege Auditing ?
Answer:
Privilege auditing is the auditing of using powerful gadget privileges without regard to in particular named items.
Question: eighty four. What Is Object Auditing ?
Answer:
Object auditing is the auditing of accesses to particular schema items without regard to person.
Question: 85. What Is Auditing ?
Answer:
Monitoring of consumer get right of entry to to useful resource inside the research of database use.
Question: 86. Where Are My Tempfiles, I Don’t See Them In V$datafile Or Dba_data_file? (for Dba )
Answer:
Tempfiles, in contrast to everyday datafiles, are not listed in v$datafile or dba_data_files. Instead query v$tempfile or dba_temp_files:
SELECT * FROM v$tempfile;
SELECT * FROM dba_temp_files;
Question: 87. How Do I Find Used/free Space In A Temporary Tablespace? (for Dba )
Answer:
Unlike everyday tablespaces, actual temporary tablespace statistics isn’t always indexed in DBA_FREE_SPACE. Instead use the V$TEMP_SPACE_HEADER view:
SELECT tablespace_name, SUM (bytes used), SUM (bytes free)
FROM V$temp_space_header
GROUP BY tablespace_name;
Question: 88. What Is A Profile ?
Answer:
Each database user is assigned a Profile that specifies obstacles on diverse system sources available to the consumer.
Question: 89. How Will You Enforce Security Using Stored Procedures?
Answer:
Don’t grant consumer get admission to without delay to tables in the application. Instead supply the potential to get right of entry to the processes that get entry to the tables. When technique completed it’s going to execute the privilege of strategies owner. Users can not access tables except through the system.
Question: 90. How Does One Get The View Definition Of Fixed Views/tables?
Answer:
Query v$fixed_view_definition. Example: SELECT * FROM v$fixed_view_definition WHERE view_name= ‘V$SESSION’;
Question: 91. What Are The Dictionary Tables Used To Monitor A Database Spaces ?
Answer:
The dictionary tables used to monitor a database areas are:
DBA_FREE_SPACE
DBA_SEGMENTS
DBA_DATA_FILES.
Question: ninety two. How Can We Specify The Archived Log File Name Format And Destination?
Answer:
By setting the following values in init.Ora report. LOG_ARCHIVE_FORMAT = arch %S/s/T/tarc (%S – Log sequence wide variety and is 0 left paded, %s – Log collection range not padded. %T – Thread range lef-0-paded and %t – Thread quantity now not padded). The file name created is arch 0001 are if %S is used. LOG_ARCHIVE_DEST = route.
Question: 93. What Is User Account In Oracle Database?
Answer:
An person account isn’t always a physical structure in Database but it’s far having critical dating to the objects inside the database and could be having sure privileges.
Question: ninety four. When Will The Data In The Snapshot Log Be Used?
Answer:
snapshort log is used updated records for master table and if any recored is up to date after certain duration to refers the master desk accumulate the photo log due to the fact tha desk length may be very big it take lot of time thus by means of americathe photo log.
Question: ninety five. What Dynamic Data Replication?
Answer:
Updating or Inserting records in remote database thru database triggers. It can also fail if remote database is having any problem.
Question: 96. What Is Two-section Commit ?
Answer:
Two-section dedicate is mechanism that ensures a dispensed transaction both commits on all concerned nodes or rolls returned on all worried nodes to preserve facts consistency throughout the worldwide distributed database. It has two section, a Prepare Phase and a Commit Phase.
Question: ninety seven. How Can You Enforce Referential Integrity In Snapshots ?
Answer:
Time the references to occur whilst grasp tables aren’t in use. Peform the reference the manually right now locking the master tables. We can join tables in snopshots by way of creating a complicated snapshots to be able to based totally at the master tables.
Question: ninety eight. What Is A Sql * Net?
Answer:
SQL *NET is ORACLE’s mechanism for interfacing with the conversation protocols utilized by the networks that facilitate distributed processing and distributed databases. It is utilized in Clint-Server and Server-Server communications.
Question: ninety nine. What Is A Snapshot ?
Answer:
Snapshots are read-only copies of a master desk positioned on a remote node which is periodically refreshed to mirror adjustments made to the master desk.
Question: a hundred. What Is The Mechanism Provided By Oracle For Table Replication ?
Answer:
Snapshots and SNAPSHOT LOGs.
Question: 101. What Is Snapshots?
Answer:
Snapshot is an item used to dynamically replicate facts between distribute database at particular time intervals. In ver 7.0 they’re examine best.
Question: 102. What Are The Various Type Of Snapshots?
Answer:
The diverse type of snapshots are:
Simple
Complex.
Question: 103. Describe Two Phases Of Two-segment Commit ?
Answer:
Prepare section – The international coordinator (initiating node) ask a members to prepare (to vow to commit or rollback the transaction, even though there is a failure).
Commit Phase – If all contributors reply to the coordinator that they’re prepared, the coordinator asks all nodes to dedicate the transaction, if all members can’t put together, the coordinator asks all nodes to roll back the transaction.
Question: 104. What Is Snapshot Log ?
Answer:
It is a table that continues a document of modifications to the master desk in a photo. It is stored in the identical database as grasp table and is best to be had for simple snapshots. It must be created before creating snapshots.
Question: one hundred and five. What Are The Benefits Of Distributed Options In Databases?
Answer:
Database on other servers may be up to date and people transactions can be grouped together with others in a logical unit.
Database uses a section devote.
Question: 106. What Are The Options Available To Refresh Snapshots ?
Answer:
COMPLETE – Tables are completely regenerated using the snapshots question and the master tables each time the image referenced.
FAST – If simple photograph used then a image log can be used to ship the modifications to the photo tables.
FORCE – Default fee. If feasible it plays a FAST refresh; Otherwise it’ll carry out a entire refresh.
Question: 107. What Is A Snapshot Log ?
Answer:
A image log is a table in the master database that is associated with the master table. ORACLE uses a picture log to track the rows that have been up to date inside the grasp table. Snapshot logs are used in updating the snapshots based at the grasp desk.
Question: 108. What Is Distributed Database ?
Answer:
A disbursed database is a network of databases controlled by a couple of database servers that appears to a user as single logical database. The facts of all databases within the allotted database can be simultaneously accessed and modified.
Question: 109. How Can We Reduce The Network Traffic?
Answer:
Replication of data in distributed surroundings.
Using snapshots to copy information.
Using far off method calls.
Question: one hundred ten. Differentiate Simple And Complex, Snapshots ?
Answer:
A simple picture is primarily based on a query that does not contains GROUP BY clauses, CONNECT BY clauses, JOINs, sub-query or snashot of operations.
A complicated snapshots comprise atleast someone of the above.
Question: 111. What Are The Built-ins Used For Sending Parameters To Forms?
Answer:
You can bypass parameter values to a form when an application executes the call_form, New_form, Open_form or Run_product.
Question: 112. Can You Have More Than One Content Canvas View Attached With A Window?
Answer:
Yes. Each window you create have to have atleast one content material canvas view assigned to it. You can also create a window that has manipulated content canvas view. At run time most effective one of the content canvas perspectives assign to a window is displayed at a time.
Question: 113. Is The After Report Trigger Fired If The Report Execution Fails?
Answer:
Yes.
Question: 114. Does A Before Form Trigger Fire When The Parameter Form Is Suppressed?
Answer:
Yes.
Question: one hundred fifteen. What Is Sga?
Answer:
The System Global Area in an Oracle database is the location in memory to facilitate the transfer of facts between customers. It holds the most lately asked structural facts between customers. It holds the maximum these days requested structural information approximately the database. The structure is database buffers, dictionary cache, redo log buffer and shared pool vicinity.
Question: 116. What Is A Shared Pool?
Answer:
The data dictionary cache is stored in an area in SGA known as the shared pool. This will allow sharing of parsed SQL statements among concurrent users.
Question: 117. What Is Mean By Program Global Area (pga)?
Answer:
It is location in reminiscence that is used by a single Oracle person procedure.
Question: 118. What Is A Data Segment?
Answer:
Data segment are the physical regions within a database block in which the records associated with tables and clusters are saved.
Question: 119. What Are The Factors Causing The Reparsing Of Sql Statements In Sga?
Answer:
Due to inadequate shared pool size.
Monitor the ratio of the reloads takes region whilst executing SQL statements. If the ratio is extra than 1 then increase the SHARED_POOL_SIZE.
Question: a hundred and twenty. What Are Clusters?
Answer:
Clusters are groups of 1 or greater tables physically stores collectively to proportion common columns and are often used together.
Question: 121. What Is Cluster Key?
Answer:
The associated columns of the tables in a cluster are known as the cluster key.
Question: 122. Do A View Contain Data?
Answer:
Views do not include or keep facts.
Question: 123. What Are The Dictionary Tables Used To Monitor A Database Space?
Answer:
DBA_FREE_SPACE
DBA_SEGMENTS
DBA_DATA_FILES.
Question: 124. Can A Property Clause Itself Be Based On A Property Clause?
Answer:
Yes
Question: one hundred twenty five. If A Parameter Is Used In A Query Without Being Previously Defined, What Diff. Exist Between. Report 2.Zero And 2.Five When The Query Is Applied?
Answer:
While each reviews 2.Zero and 2.5 create the parameter, file 2.Five gives a message that a bind parameter has been created.
Question: 126. What Are The Sql Clauses Supported In The Link Property Sheet?
Answer:
Where begin with having.
Question: 127. What Is Trigger Associated With The Timer?
Answer:
When-timer-expired.
Question: 128. What Are The Trigger Associated With Image Items?
Answer:
When-image-activated fires while the operators double clicks on an image item while-photograph-pressed fires while an operator clicks or double clicks on an photo item.
Question: 129. What Are The Different Windows Events Activated At Runtimes?
Answer:
When_window_activated
When_window_closed
When_window_deactivated
When_window_resized
Within this triggers, you can observe the constructed in machine variable machine. Event_window to decide the call of the window for which the cause fired.
Question: one hundred thirty. When Do You Use Data Parameter Type?
Answer:
When the fee of a information parameter being handed to a known as product is constantly the name of the record organization described in the present day form. Data parameters are used to bypass statistics to merchandise invoked with the run_product integrated subprogram.
Question: 131. What Is Difference Between Open_form And Call_form?
Answer:
while one form invokes some other shape via executing open_form the first form remains displayed, and operators can navigate between the forms as desired. While one shape invokes every other shape via executing call_form, the known as form is modal with recognize to the calling shape. That is, any home windows that belong to the calling shape are disabled, and operators can’t navigate to them till they first go out the referred to as shape.
Question: 132. What Is New_form Built-in?
Answer:
When one form invokes another form by way of executing new_form oracle form exits the primary shape and releases its memory earlier than loading the new form calling new form absolutely update the primary with the second. If there are modifications pending inside the first form, the operator may be prompted to save them before the new shape is loaded.
Question: 133. What Is The “lov Of Validation” Property Of An Item? What Is The Use Of It?
Answer:
When LOV for Validation is ready to True, Oracle Forms compares the modern-day cost of the textual content item to the values inside the first column displayed in the LOV. Whenever the validation event occurs. If the value inside the text object suits one of the values within the first column of the LOV, validation succeeds, the LOV isn’t always displayed, and processing keeps commonly. If the fee within the text item does no longer suit one of the values in the first column of the LOV, Oracle Forms shows the LOV and uses the textual content object value because the search criteria to robotically lessen the listing.
Question: 134. What Is The Diff. When Flex Mode Is Mode On And When It Is Off?
Answer:
When flex mode is on, reviews routinely resizes the discern whilst the child is resized.
Question: one hundred thirty five. What Is The Diff. When Confine Mode Is On And When It Is Off?
Answer:
When confine mode is on, an item cannot be moved out of doors its parent inside the layout.
Question: 136. What Are Visual Attributes?
Answer:
Visual attributes are the font, shade, pattern properties that you set for form and menu objects that seem to your software interface.
Question: 137. Which Of The Two Views Should Objects According To Possession?
Answer:
view through structure.
Question: 138. What Are The Two Types Of Views Available In The Object Navigator(specific To Report 2.Five)?
Answer:
The kinds of perspectives to be had inside the item navigator are:
View by using shape
view by means of type .
Question: 139. What Are The Vbx Controls?
Answer:
Vbx manipulate offer a simple method of building and improving person interfaces. The controls can use to obtain person inputs and display program outputs.Vbx manipulate where firstly develop as extensions for the ms visible basic environments and consist of such items as sliders, rides and knobs.
Question: one hundred forty. What Is The Use Of Transactional Triggers?
Answer:
Using transactional triggers we will manage or modify the default capability of the oracle bureaucracy.
Question: 141. How Do You Create A New Session While Open A New Form?
Answer:
Using open_form integrated putting the consultation alternative Ex. Open_form(‘Stocks ‘,active, session). When invoke the more than one forms with open form and call_form in the identical software, kingdom whether the subsequent are proper/False.
Question: 142. What Are The Ways To Monitor The Performance Of The Report?
Answer:
Use reviews profile executable statement.
Use SQL hint facility.
Question: 143. If Two Groups Are Not Linked In The Data Model Editor, What Is The Hierarchy Between Them?
Answer:
Two institution that is above are the left most rank higher than the organization this is to right or underneath it.
Question: a hundred and forty four. An Open Form Can Not Be Execute The Call_form Procedure If You Chain Of Called Forms Has Been Initiated By Another Open Form?
Answer:
True
Question: one hundred forty five. Explain About Horizontal, Vertical Tool Bar Canvas Views?
Answer:
Tool bar canvas views are used to create tool bars for individual home windows. Horizontal device bars are display at the top of a window, just underneath its menu bar. Vertical Tool bars are displayed along the left side of a window.
Question: 146. What Is The Purpose Of The Product Order Option In The Column Property Sheet?
Answer:
To specify the order of person institution evaluation in a cross products.
Question: 147. What Is The Use Of Image_zoom Built-in?
Answer:
To control pix in image gadgets.
Question: 148. How Do You Reference A Parameter Indirectly?
Answer:
To circuitously reference a parameter use the NAME IN, COPY ‘built-ins to in a roundabout way set and reference the parameters price’ Example name_in (‘capital parameter my param’), Copy (‘SURESH’,’Parameter my_param’)
Question: 149. What Is A Timer?
Answer:
Timer is an “internal time clock” that you may programmatically create to carry out an motion each time the instances.
Question: a hundred and fifty. What Are The Two Phases Of Block Coordination?
Answer:
There are levels of block coordination:
The clean section:During, the clear segment, Oracle Forms navigates internally to the detail block and flushes the obsolete element facts.
The population section. During the population section, Oracle Forms issues a SELECT statement to repopulate the element block with detail information associated with the new master document. These operations are executed through the execution of triggers.
Question: 151. What Are Most Common Types Of Complex Master-detail Relationships?
Answer:
There are three most commonplace styles of complicated grasp-detail relationships:
grasp with structured details
master with impartial information
detail with masters.
Question: 152. What Is A Text List?
Answer:
The text listing fashion listing object seems as a square field which displays the constant range of values. When the textual content list incorporates values that cannot be displayed, a vertical scroll bar seems, permitting the operator to view and choose undisplayed values.
Question: 153. What Is Term?
Answer:
The term is terminal definition file that describes the terminal shape that you are using r20run.
Question: 154. What Is Use Of Term?
Answer:
The time period record which key is correspond to which oracle report features.
Question: a hundred and fifty five. What Is Pop List?
Answer:
The pop listing style listing object seems to start with as a single area (similar to a textual content object area). When the operator selects the listing icon, a listing of available picks appears.
Question: 156. What Is The Maximum No Of Chars The Parameter Can Store?
Answer:
The most no of chars the parameter can save is most effective valid for char parameters, which may be upto 64K. No parameters default to 23Bytes and Date parameter default to 7Bytes.
Question: 157. What Are The Default Extensions Of The Files Created By Library Module?
Answer:
The default report extensions imply the library module kind and garage format .Pll – pl/sq. Library module binary.
Question: 158. What Are The Coordination Properties In A Master-element Relationship?
Answer:
The coordination residences are
Deferred
Auto-Query
These Properties decide when the populace phase of block coordination need to occur.
Question: 159. How Do You Display Console On A Window ?
Answer:
The console includes the fame line and message line, and is displayed at the lowest of the window to which it is assigned.To specify that the console must be displayed, set the console window form assets to the name of any window in the shape. To encompass the console, set console window to Null.
Question: a hundred and sixty. What Are The Different Parameter Types?
Answer:
The special Parameter types are:
Text Parameters
Data Parameters
Question: 161. State Any Three Mouse Events System Variables?
Answer:
System.Mouse_button_pressed
System.Mouse_button_shift_state
system.Mouse_item
machine.Mouse_canvas
gadget.Mouse_record
Question: 162. What Are The Types Of Calculated Columns Available?
Answer:
The forms of calculated columns to be had are:
Summary,
Formula,
Placeholder column.
Question: 163. Explain About Stacked Canvas Views?
Answer:
Stacked canvas view is displayed in a window on pinnacle of, or “stacked” on the content canvas view assigned to that identical window. Stacked canvas perspectives obscure some a part of the underlying content material canvas view, and or regularly proven and hidden programmatically.
Question: 164. What Is The Difference Between Show_editor And Edit_textitem?
Answer:
Show editor is the accepted built-in which accepts any editor call and takes a few input string and returns modified output string. Whereas the edit_textitem integrated desires the enter focus to be in the text item earlier than the integrated is accomplished.
Question: 165. What Are The Built-ins That Are Used To Attach An Lov Programmatically To An Item?
Answer:
set_item_property
get_item_property
(by means of putting the LOV_NAME belongings)
Question: 166. What Are The Different File Extensions That Are Created By Oracle Reports?
Answer:
The distinct record extensions that are created by oracle reports are:
Rep report
Rdf document.
Question: 167. What Is Strip Sources Generate Options?
Answer:
Removes the source code from the library document and generates a library documents that contains only pcode. The resulting document may be used for final deployment, however cannot be sooner or later edited inside the dressmaker.Ex. F45gen module=old_lib.Pll userid=scott/tiger strip_source YES output_file.
Question: 168. What Is The Basic Data Structure That Is Required For Creating An Lov?
Answer:
Record Group.
Question: 169. What Is The Maximum Allowed Length Of Record Group Column?
Answer:
Record institution column names cannot exceed 30 characters.
Question: one hundred seventy. Which Parameter Can Be Used To Set Read Level Consistency Across Multiple Queries?
Answer:
Read only
Question: 171. What Are The Different Types Of Record Groups?
Answer:
The different sorts of Record Groups are:
Query Record Groups
NonQuery Record Groups
State Record Groups.
Question: 172. From Which Designation Is It Preferred To Send The Output To The Printed?
Answer:
Previewer
Question: 173. What Are Difference Between Post Database Commit And Post-form Commit?
Answer:
Post-form commit fires as soon as for the duration of the submit and commit transactions manner, after the database commit occurs. The post-form-devote cause fires after inserts, updates and deletes have been posted to the database but before the transactions have been finalized within the issuing the command.
Submit-database-dedicate cause fires after oracle paperwork problems the commit to finalized transactions.
Question: 174. What Are The Different Display Styles Of List Items?
Answer:
Pop_list
Text_list
Combo container
Question: one hundred seventy five. Which Of The Above Methods Is The Faster Method?
Answer:
appearing the calculation in the question is quicker.
Question: 176. With Which Function Of Summary Item Is The Compute At Options Required?
Answer:
percent of total functions.
Question: 177. What Are Parameters?
Answer:
Parameters provide a easy mechanism for defining and setting the valuesof inputs which can be required by a shape at startup. Form parameters are variables of kind char,range,date which you define at design time.
Question: 178. What Are The Three Types Of User Exits Available ?
Answer:
Oracle Precompiler exits,
Oracle call interface,
NonOracle user exits.
Que