Explore topic-wise InterviewSolutions in .

Enterprise Resource Planning, a system that is used to MANAGE all aspects of a COMPANY's operations. ERP is a WAY to INTEGRATE the data and processes of an organization into one single system.

Enterprise Resource Planning, a system that is used to manage all aspects of a company's operations. ERP is a way to integrate the data and processes of an organization into one single system.

The EXPLAIN PLAN statement displays execution plans chosen by the Oracle optimizer for SELECT, UPDATE, INSERT, and DELETE statements. A statement's execution plan is the sequence of OPERATIONS Oracle performs to run the statement. The ROW source tree is the core of the execution plan.

It shows the following information:

• An ordering of the tables referenced by the statement
• An ACCESS method for each table mentioned in the statement
• A join method for tables affected by join operations in the statement
• Data operations like filter, sort, or aggregation In addition to the row source tree

the plan table contains information about the following:

• Optimization, such as the cost and cardinality of each operation
• Partitioning, such as the set of accessed partitions
• PARALLEL execution

such as the distribution method of join inputs The EXPLAIN PLAN results let us determine whether the optimizer selects a PARTICULAR execution plan, such as, nested loops join.

The EXPLAIN PLAN statement displays execution plans chosen by the Oracle optimizer for SELECT, UPDATE, INSERT, and DELETE statements. A statement's execution plan is the sequence of operations Oracle performs to run the statement. The row source tree is the core of the execution plan.

It shows the following information:

the plan table contains information about the following:

such as the distribution method of join inputs The EXPLAIN PLAN results let us determine whether the optimizer selects a particular execution plan, such as, nested loops join.

DCL is Data Control Language statements (GRANT, COMMIT) DDL (Data D DDL language definition Language) statements are USED to define the DATABASE structure or schema (CREATE, ALTER, TRUNCATE). 

DCL is Data Control Language statements (GRANT, COMMIT) DDL (Data D DDL language definition Language) statements are used to define the database structure or schema (CREATE, ALTER, TRUNCATE). 

A cursor VARIABLE is ASSOCIATED with DIFFERENT STATEMENTS which can hold different values at run time. It is kind of reference TYPE.

A cursor variable is associated with different statements which can hold different values at run time. It is kind of reference type.

Logical structures of an Oracle database include tablespaces, schema objects, data BLOCKS, extents, and SEGMENTS. Because the physical and logical structures are SEPARATE, the physical storage of data can be managed without AFFECTING the ACCESS to logical storage structures.

Logical structures of an Oracle database include tablespaces, schema objects, data blocks, extents, and segments. Because the physical and logical structures are separate, the physical storage of data can be managed without affecting the access to logical storage structures.

PL/SQL is Oracle's procedural EXTENSION to SQL. With PL/SQL, we can manipulate DATA with SQL statements, and control program flow with procedural CONSTRUCTS such as IF-THEN and LOOP. we can also declare constants and variables, define procedures and functions, use COLLECTIONS and object types, and trap run-time errors. Applications written using any of the Oracle programmatic interfaces can call PL/SQL stored procedures and send blocks of PL/SQL code to the server for execution. Because it runs inside the database, PL/SQL code is very efficient for data-intensive operations, and minimizes network traffic in client/server applications.

PL/SQL is Oracle's procedural extension to SQL. With PL/SQL, we can manipulate data with SQL statements, and control program flow with procedural constructs such as IF-THEN and LOOP. we can also declare constants and variables, define procedures and functions, use collections and object types, and trap run-time errors. Applications written using any of the Oracle programmatic interfaces can call PL/SQL stored procedures and send blocks of PL/SQL code to the server for execution. Because it runs inside the database, PL/SQL code is very efficient for data-intensive operations, and minimizes network traffic in client/server applications.

Oracle package is a schema object that groups logically related PL/SQL types, items, and SUBPROGRAMS. PACKAGES offer several advantages: modularity, easier application DESIGN, information hiding, added FUNCTIONALITY, and better PERFORMANCE

Oracle package is a schema object that groups logically related PL/SQL types, items, and subprograms. Packages offer several advantages: modularity, easier application design, information hiding, added functionality, and better performance

SALT STANDS for service architecture leveraging tuxedo. It is a SOAP over https gateway. It was created to expose tuxedo services as web services which will invoke web services from within tuxedo applications using tuxedo API. SALT is configuration driven. It is SCALABLE and highly AVAILABLE. Code changing is not required in CASE of SALT. 

SALT stands for service architecture leveraging tuxedo. It is a SOAP over https gateway. It was created to expose tuxedo services as web services which will invoke web services from within tuxedo applications using tuxedo API. SALT is configuration driven. It is scalable and highly available. Code changing is not required in case of SALT. 

Oracle provides 3 kinds of data types-

• DATE data TYPE which provides different FORMATS of dates.
• Timestamp data type which provides different formats of TIME stamp.
• INTERVAL data type which provides interval between dates & times.

Oracle provides 3 kinds of data types-

There are several benefits of ASM . The most important aspects of ASM are:

• It stripes files RATHER than logical VOLUMES
• It can perform Online disk reconfiguration and DYNAMIC REBALANCING
• It has adjustable rebalancing SPEED
• It Provides redundancy on a file basis
• Besides, ASM is Custer-aware and it can be automatically installed .

There are several benefits of ASM . The most important aspects of ASM are:

There are almost 9 POSSIBLE WAYS to do that:

1. Physical Standby
2. Logical Standby 
3. Export/Import
4. Transportable Tablespace
5. Transportable DATABASE
6. Golden gate
7. RMAN cold 
8. Oracle Streams
9. Hot backup RESTORATION

There are almost 9 possible ways to do that:

Exadata is simply a data appliance. A data appliance is a server with pre-installed & pre-optimized database.

Three major components of Exadata database server are :

 DB Server , Cell Storage , INFINIBAND SWITCH , Cisco Switch , PDU , Database Instance , ASM Instance , Database Resource MANAGER

The key Features of Oracle Exadata are :

Hardware level , Storage Server CELLS , High Speed Infiniband Switch , Software level , SMART Scan , Flash Cache , Hybrid Columnar Compression , IORM (I/O Resource Manager).

Exadata is simply a data appliance. A data appliance is a server with pre-installed & pre-optimized database.

Three major components of Exadata database server are :

 DB Server , Cell Storage , Infiniband Switch , Cisco Switch , PDU , Database Instance , ASM Instance , Database Resource Manager

The key Features of Oracle Exadata are :

Hardware level , Storage Server Cells , High Speed Infiniband Switch , Software level , Smart Scan , Flash Cache , Hybrid Columnar Compression , IORM (I/O Resource Manager).

In CASE of Non RAC environment a single instance accesses a single database. The database contains control files, redo log files & database files which is physically present on desk. WHEREAS, The RAC environment contains two or more INSTANCES COMMUNICATING with a single database ; these all are instances running on separate servers. 

In case of Non RAC environment a single instance accesses a single database. The database contains control files, redo log files & database files which is physically present on desk. Whereas, The RAC environment contains two or more instances communicating with a single database ; these all are instances running on separate servers. 

Oracle USES Oracle RAC or REAL Application Cluster. 

Oracle uses Oracle RAC or Real Application Cluster. 

The amazing CLUSTERING capability of TUXEDO is its greatest advantage. It can process millions of REQUESTS in a second. Being HIGHLY optimized it GETS responses within few microseconds.

The amazing clustering capability of Tuxedo is its greatest advantage. It can process millions of requests in a second. Being highly optimized it gets responses within few microseconds.

The software is written in 7 LANGUAGES:

• C 
• C++
• JAVA
• PYTHON
• COBOL
• RUBY
• PHP

The software is written in 7 languages:

Technically, Middleware is a hidden layer or layers of SOFTWARE between Operating SYSTEM and APPLICATION. It COMPRISES of common FUNCTIONALITIES crucial for many applications.

Technically, Middleware is a hidden layer or layers of software between Operating system and Application. It comprises of common functionalities crucial for many applications.

Well the full form of Tuxedo is Transactions for Unix , Extended for distributed operations. Simply, it is a middle WARE PLATFORM which manages the distribution of computing environments along with processing of transactions. It is ALSO a cross platform software that can be run by any operating SYSTEM. 

Well the full form of Tuxedo is Transactions for Unix , Extended for distributed operations. Simply, it is a middle ware platform which manages the distribution of computing environments along with processing of transactions. It is also a cross platform software that can be run by any operating system. 

Tuxedo was built by AT&T i.e. American TELEPHONE & Telegraph COMPANY in the 1980s. ORACLE Tuxedo is a software that was DEVELOPED by Oracle corporations in 2008.

Tuxedo was built by AT&T i.e. American Telephone & Telegraph Company in the 1980s. Oracle Tuxedo is a software that was developed by Oracle corporations in 2008.