Interview Questions.

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