Please find the list of “Oracle Tuxedo Interview Questions And Answers” as follows:
1) To start with, When and by whom was Oracle Tuxedo formed?
Tuxedo was built by AT&T i.e. American Telephone & Telegraph Company in the 1980s. Oracle Tuxedo is software that was developed by Oracle corporations in 2008.
2) What does Tuxedo mean to you?
Well, the full form of Tuxedo is Transactions for Unix, Extended for distributed operations. Simply, it is a middleware platform that manages the distribution of computing environments along with the processing of transactions. It is also a cross-platform software that can be run by any operating system.
3) What is Middleware?
Technically, Middleware is a hidden layer or layers of software between the Operating system and Application. It comprises common functionalities crucial for many applications.
4) Name the languages used by Oracle Tuxedo?
The software is written in 7 languages
5) What according to you is the greatest advantage of a Tuxedo?
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.
6) Which cluster is used by oracle?
Oracle uses Oracle RAC or Real Application Cluster.
7) What is RAC?
Oracle RAC is Oracle’s premier shared disk database clustering technology. It is a clustered database solution for scalability, high availability, flexibility, and elasticity. RAC was introduced in 2001 with Oracle 9i. It is available in standard as well as an enterprise edition.
8) What is the difference between RAC & non-RAC environments in Oracle?
In the case of a Non-RAC environment, a single instance accesses a single database. The database contains control files, redo log files & database files that are physically present on the desk. Whereas, The RAC environment contains two or more instances communicating with a single database; these all are instances running on separate servers.
9) What is Oracle Exadata?
Exadata is simply a data appliance. A data appliance is a server with a pre-installed & pre-optimized database. Three major components of the 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).
10) How can we shift a normal database to Exadata?
There are almost 9 possible ways to do that.
1 Physical Standby
2. Logical Standby
4. Transportable Tablespace
5. Transportable Database
6. Golden gate
7. RMAN cold
8. Oracle Streams
9. Hot backup restoration
11) What is ASM?
ASM is Automatic storage management which was introduced in Oracle 10g. It provides storage solutions. It is a very powerful tool for managing multi-terabyte databases. The storage components of Oracle ASM are
ASM Disk groups
ASM Allocation units
ASM File Extent Map
ASM can add a disk from the volume or remove it, ASM can perform the load balancing inside the storage. Basically, ASM provides the volume manager layer which is essential for every software. It also acts as a file system.
12) What are the benefits of ASM?
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 an adjustable rebalancing speed
It Provides redundancy on a file basis
Besides, ASM is Custer-aware and it can be automatically installed.
13) What are the temporal data types provided by Oracle?
Oracle provides 3 kinds of data types-
Data data type which provides different formats of dates.
Timestamp data type which provides different formats of Timestamp.
Interval data type provides an interval between dates & times.
14) What is 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 that 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 the case of SALT.
15) What is an Oracle instance?
Oracle instance is a system global area (SGA) and the Oracle background processes constitute an Oracle database instance. Every time a database is started, a system global area is allocated and Oracle background processes are started. The SGA is deallocated when the instance shuts down. After starting an instance, Oracle associates the instance with the specified database. This is called mounting the database. The database is then ready to be opened, which makes it accessible to authorized users.
16) What is the Oracle package?
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
17) Explain the general concepts of PL/SQL?
PL/SQL is Oracle’s procedural extension to SQL. With PL/SQL, we can manipulate data with SQL statements, and control program flows 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.
18) What is a database trigger?
A database trigger is a stored procedure that Oracle invokes automatically when certain events occur, for example, when a DML operation modifies a certain table. Triggers enforce business rules, prevent incorrect values from being stored, and reduce the need to perform checking and cleanup operations in each application.
Here are some important items to remember about triggers. -On insert triggers have no: OLD values. -On delete triggers have no: NEW values -Triggers do not commit transactions. If a transaction is rolled back, the data changed by the trigger is also rolled back. -Commits, rollbacks, and save points are not allowed in the trigger body.
A commit/rollback affects the entire transaction, it is all or none. -Unhandled exceptions in the trigger will cause a rollback of the entire transaction, not just the trigger. -If more than one trigger is defined on an event, the order in which they fire is not defined. If the triggers must fire in order, we must create one trigger that executes all the actions in the required order. -A trigger can cause other events to execute triggers. -A trigger cannot change a table that it has read from.
19) Brief on data warehouse?
A data warehouse is a relational database that is designed for query and analysis. It usually contains historical data derived from transaction data, but it can include data from other sources. It separates analysis workload from transaction workload and enables an organization to consolidate data from several sources.
In addition to a relational database, a data warehouse environment includes an extraction, transportation, transformation, and loading (ETL) solution, an online analytical processing (OLAP) engine, client analysis tools, and other applications that manage the process of gathering data and delivering it to business users.
Most data warehouses use a staging area to clean and process our operational data before We may want to customize our warehouse’s architecture for different groups within our organization.
20) What is RDF?
A set of rules (a sort of language) for creating descriptions of information, especially information available on the World Wide Web. RDF could be used to describe a collection of books, or artists, or a collection of web pages as in the RSS data format which uses RDF to create machine-readable summaries of websites.
RDF is also used in XPFE applications to define the relationships between different collections of elements, for example, RDF could be used to define the relationship between the data in a database and the way that data is displayed to a user
21) What do the Oracle logical structures comprise of?
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 access to logical storage structures.
22) Define cursor variable?
A cursor variable is associated with different statements which can hold different values at run time. It is a kind of reference type.
23) Describe PLS_INTEGER datatype?
PLS_INTEGER and BINARY_INTEGER are identical data types and are only available in PL/SQL. You cannot create a column in a table with either of these data types. PLS_INTEGER is a highly efficient integer 32-bit data type. You will most commonly see PLS_INETGER (and BINARY_INETGER) in PL/SQL routines as an index variable. An associative array (INDEX BY TABLE) index. Both PLS_INTEGER and BINARY_INTEGER allow whole numbers only. Decimal fractions are rounded to the nearest whole number.
24) What is a pragma?
Pragma is a keyword in Oracle PL/SQL that is used to provide an instruction to the compiler like PRAGMA AUTONOMOUS_TRANSACTION.
25) What is the Oracle package?
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.
26) What is partitioning?
Partitioning is a method of splitting large tables and indexes into smaller, more manageable pieces.
27) What is the DCL & DDL language?
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).
28) What is EXPLAIN PLAN?
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 plantable 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.
29) What is ERP 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.
This is all about “Oracle Tuxedo Interview Questions And Answers“.
For more interview questions and answers about latest technologies please check here.