Top Oracle Tuxedo Interview Questions and Answers

Last updated on 17th Nov 2021, Blog, Interview Questions

In this program of Oracle Tuxedo basic interview questions, we have included all regularly asked basic and Oracle Tuxedo interview questions for experienced candidates with detailed answers to help you clear the job interview. The following list includes the best important Oracle Tuxedo questions for freshers as well as Looker questions and answers for experienced candidates to help them prepare for the interview. This complete guide of Looker interview questions will encourage you to crack your Job interview easily.

1. To start with, When and by whom was Oracle Tuxedo formed?

Ans:

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?

Ans:

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?

Ans:

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?

Ans:

The software is written in 7 languages:

• C
• C++
• JAVA
• PYTHON
• COBOL
• Ruby
• PHP

5. What is the difference between RAC & non-RAC environments in Oracle?

Ans:

RAC	Non-RAC
In the case of a Non-RAC environment, a single instance accesses a single database.	The RAC environment contains two or more instances communicating with a single database.
The database contains control files, redo log files & database files that are physically present on the desk.	These all are instances running on separate servers.

6. What according to you is the greatest advantage of a Tuxedo?

Ans:

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 a few microseconds.

7. Which cluster is used by oracle?

Ans:

Oracle uses Oracle RAC or Real Application Cluster.

8. What is RAC?

Ans:

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.

9. What is Oracle Exadata?

Ans:

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. Define oracle tuxedo architecture overview?

Ans:

11. How can we shift a normal database to Exadata ?

Ans:

There are almost 9 possible ways to do that.

• Physical Standby
• Logical Standby
• Export/Import
• Transportable Tablespace
• Transportable Database
• Golden gate
• RMAN cold
• Oracle Streams
• Hot backup restoration

12. What is ASM?

Ans:

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 Disks
• ASM Disk groups
• ASM Allocation units
• ASM Extents
• ASM Files
• 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.

13. What are the benefits of ASM?

Ans:

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 Cluster-aware and it can be automatically installed.

14. What are the temporal data types provided by Oracle?

Ans:

Oracle provides 3 kinds of data types-M

• 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.

15. What is an Oracle instance and Oracle package?

Ans:

Oracle instance	Oracle package
Oracle instance is a system global area (SGA) and the Oracle background processes constitute an Oracle database instance.	Oracle package is a schema object that groups logically related PL/SQL types, items, and subprograms.
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.	Packages offer several advantages: modularity, easier application design, information hiding, added functionality, and better performance

16. What is SALT?

Ans:

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.

17. What is a database trigger?

Ans:

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.

18. Brief on data warehouse?

Ans:

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.

19. What is BEA Tuxedo system?

Ans:

The BEA Tuxedo system is a middleware product that distributes applications across multiple platforms, databases, and operating systems using message-based communications and, if desired, distributed transaction processing. The BEA Tuxedo system serves as an extension to the operating system.

20. What are oracle tuxedo system fundamentals?

Ans:

21. What do the Oracle logical structures comprise of?

Ans:

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?

Ans:

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?

Ans:

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 Oracle jolt?

Ans:

Oracle Jolt is a Java class library and API that provides an interface to Oracle Tuxedo from remote Java clients. Jolt Class Library—the Jolt class library is a Java package containing the class files that implement the Jolt API.

25. What is the DML & DDL language?

Ans:

DCL	DDL
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).

26. What is the Oracle package?

Ans:

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.

27. Which will help to call Tuxedo service from PeopleSoft application?

Ans:

PeopleSoft also uses Oracle Jolt, a Java API and class library, to facilitate communication between Tuxedo running on the application server and the PeopleSoft software running on the web server.

28. What is EXPLAIN PLAN?

Ans:

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 Tuxedo salt?

Ans:

Oracle Service Architecture Leveraging Tuxedo (SALT) is an add-on product option for Tuxedo, enabling Tuxedo applications to participate in SOA environments. Oracle SALT allows external Web services applications to invoke Tuxedo services as Web services, and Tuxedo applications to invoke external Web services.

30. What are oracle tuxedo management tools?

Ans:

31. What is Tux in computer?

Ans:

Tux is the name of the penguin mascot used for the Linux kernel. Although initially created for the Linux kernel, Tux is often used today to represent anything related to Linux, including Linux distros. The picture here is an example of Tux, originally drawn by Larry Ewing in 1996 using GIMP.

32. What Is an Explain Plan?

Ans:

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.
• 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

33. What Is Partitioning?

Ans:

Partitioning is a method of splitting large tables and indexes into smaller, more manageable pieces.

34. What Is A Pragma?

Ans:

Pragma is a keyword in Oracle PL/SQL that is used to provide an instruction to the compiler like PRAGMA AUTONOMOUS_TRANSACTION

35. Why Is Sap MDM Part Of Sap Net weaver?

Ans:

SAP MDM	SAP NET WEAVER
SAP Net Weaver is an integration and application platform that helps unify and align people, information and business processes across technologies and organizations. SAP Master Data Management (MDM) is a building block	SAP Net Weaver to enable information integrity across the business network and to facilitate a better communication of information across a heterogeneous IT landscape.

36. What Do The Oracle Logical Structures Comprised Of?

Ans:

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.

37. What Is Rdf?

Ans:

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 web sites. 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

38. Explain The General Concepts Of Pl/sql?

Ans:

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.

39. When And By Whom Was Oracle Tuxedo Formed?

Ans:

Tuxedo became built by way of AT&T i.E. American Telephone & Telegraph Company within the Nineteen Eighties. Oracle Tuxedo is a software that become developed by means of Oracle corporations in 2008

40. What are oracle tuxedo ATMI core components?

Ans:

41. What is Tuxedo system?

Ans:

Tuxedo is a transaction processing system or transaction-oriented middleware, or enterprise application server for a variety of systems and programming languages. … Developed by AT&T in the 1980s, it became a software product of Oracle Corporation in 2008 when they acquired BEA Systems.

42. Explain What Is A Middleware?

Ans:

Technically, Middleware is a hidden layer or layers of software program between Operating system and Application. It incorporates of not unusual functionalities vital for lots applications.

43. What Is an Erp System?

Ans:

Enterprise Resource Planning, a gadget that is used to control all elements of an organization’s operations. ERP is a way to integrate the facts and tactics of an company into one unmarried device.

44. What Do The Oracle Logical Structures Compromise Of?

Ans:

Logical systems of an Oracle database consist of tablespaces, schema items, facts blocks, extents, and segments. Because the physical and logical structures are separate, the physical storage of information may be managed without affecting the get right of entry to to logical storage systems.

45. What do you know about structured and unstructured data?

Ans:

Structured data	Unstructured data
Structured data is the one where everything is present in a defined sequence and thus locating the same is not at all a big deal. This data is generally limited in terms of size.	Unstructured data is often bulky and needs a lot of attention and time for the users when it comes to deriving something important from the same.

46. What is NULL value in oracle?

Ans:

NULL value represents missing or unknown data. This is used as a place holder or represented it in as default entry to indicate that there is no actual data present./p>

47. And what exactly is TUXEDO?

Ans:

TUXEDO is at least three things:

• It’s middleware :- it relays requests and responses between client and server processes (with or without transactions).
• It’s a Transaction Processing (TP) monitor :- it begins, terminates, and monitors transactions on behalf of client and server processes.
• It’s a Distributed TP monitor (DTP) :- it allows the transaction participants to be located on different machines or associated with different databases.
• Many people who are tired of low-level networking (streams, sockets, daemons etc.) use TUXEDO as their software communication infrastructure.

48. Which companies owned TUXEDO before BEA?

Ans:

AT&T, USL, Novell.

49. What’s the TUXEDO ‘buddy’ mechanism?

Ans:

The DBBL keeps the BBL up, the BBL keeps the DBBL (and all other servers) up.

50. What are oracle tuxedo CORBA components?

Ans:

51. How can I test my services without having to write a variety of client driver modules?

Ans:

Tuxedo provides a utility driver client (ud/ud32) which can serve as a great test driver. The ud program can drive simple interaction and can be configured to drive complex, multi-call interaction. It’s great to use in scripts to drive performance tests. It also comes in a workstation flavor (wud/wud32). Caveat – your services must accept FML/FML32 input to use ud. If your services don’t accept FML input, consider modifying them to do so.

52. What is JSL port?

Ans:

Jolt Server Listener (JSL)—the JSL is configured to support clients on an IP/port combination. The JSL works with the Jolt Server Handler (JSH) to provide client connectivity to the back-end of the Oracle Jolt system. The JSL runs as an Oracle Tuxedo server.

53. How can I test my services without having to write a variety of client driver modules?

Ans:

Tuxedo provides a utility driver client (ud/ud32) which can serve as a great test driver. The ud program can drive simple interaction and can be configured to drive complex, multi-call interaction. It’s great to use in scripts to drive performance tests. It also comes in a workstation flavor (wud/wud32). Caveat – your services must accept FML/FML32 input to use ud. If your services don’t accept FML input, consider modifying them to do so.

54. What is key preserved table?

Ans:

A table is set to be key preserved table if every key of the table can also be the key of the result of the join. It guarantees to return only one copy of each row from the base table.

55. What do you mean by GROUP BY Clause?

Ans:

A GROUP BY clause can be used in select statement where it will collect data across multiple records and group the results by one or more columns.

56. What is Tuxedo protocol?

Ans:

Tuxedo provides middleware software services for client/server applications in heterogeneous, distributed environments. VuGen’s Tuxedo protocol supports testing over a Tuxedo middleware system. Record Tuxedo applications. Tuxedo buffer data.

57. What are the components of the physical database structure of Oracle database?

Ans:

Components of physical database structure are given below.

• One or more data files.
• Two or more redo log files.
• One or more control files.

58. What are the components of logical database structure in Oracle database?

Ans:

Components of logical database structure.

Tablespaces

Database’s schema objects

59. What is a tablespace?

Ans:

A database contains a Logical Storage Unit called tablespaces. A tablespace is a set of related logical structures. Actually a tablespace groups related logical structures together.

60. Define monitor tuxedo with TSAM?

Ans:

61. What is a SYSTEM tablespace and when it is created?

Ans:

When the database is created in the Oracle database system, it automatically generates a SYSTEM named SYSTEM tablespace. The SYSTEM tablespace contains data dictionary tables for the entire database.

62. What is an Oracle table?

Ans:

A table is a basic unit of data storage in an Oracle database. A table contains all the accessible information of a user in rows and columns

63. In the Oracle version 9.3.0.5.0, what does each number show?

Ans:

Oracle version number refers:

• 9 – Major database release number
• 3 – Database maintenance release number
• 0 – Application server release number
• 5 – Component Specific release number
• 0 – Platform Specific release number

64. What is bulk copy or BCP in Oracle?

Ans:

Bulk copy or BCP in Oracle, is used to import or export data from tables and views but it does not copy the structure of the same data. The main advantage of BCP is fast mechanism for coping data and you can also take the backup of data easily

65. What is the relationship among database, tablespace and data file?

Ans:

An Oracle database contains one or more logical storage units called tablespaces. These tablespaces collectively store whole data of databases and each tablespace in Oracle database consists of one or more files called datafiles. These datafiles are physical structure that confirm with the operating system in which Oracle is running

66.What is a snapshot in the Oracle database?

Ans:

A snapshot is a replica of a target master table from a single point-in-time. In simple words you can say, snapshot is a copy of a table on a remote database.

67. How many memory layers are in the Oracle shared pool?

Ans:

Oracle shared pools contains two layers:

library cache

data dictionary cache

68.What is savepoint in Oracle database?

Ans:

Save points are used to divide a transaction into smaller parts. It allows rolling back of a transaction. Maximum five save points are allowed. It is used to save our data, whenever you encounter an error you can roll back from the point where you save your SAVEPOINT.

69. What is a hash cluster in Oracle?

Ans:

Hash cluster is a technique to store data in a hash table and improve the performance of data retrieval. Hash function is applied on table row’s cluster key value and store in hash cluster

70. Define oracle tuxedo system administration?

Ans:

71. What are the various Oracle database objects?

Ans:

Tables:This is a set of elements organized in vertical and horizontal fashion.

Tablespaces: This is a logical storage unit in Oracle.

Views: It is a virtual table derived from one or more tables.

Indexes: This is a performance tuning method to process the records.

Synonyms: This is a name for tables.

72.What are the different types of modules in Oracle forms?

Ans:

Following are the different modules in Oracle forms:

• Form module
• Menu module
• Pl/SQL Library module
• Object Library module

73.What is the usage of ANALYZE command in Oracle?

Ans:

ANALYZE command is used to perform various functions on index, table, or cluster. The following list specifies the usage of ANALYZE command in Oracle:

• It is used to identify migrated and chained rows of the table or cluster.
• It is used to validate the structure of the object.
• It helps in collecting the statistics about objects used by the optimizer. They are then stored in the data dictionary.
• It helps in deleting statistics used by object from the data dictionary.

74. Can you create a synonym without having a table?

Ans:

Yes. We can create a synonym without having a base table.

75.What types of joins are used in writing SUBQUERIES?

Ans:

Self join

Outer Join

Equi-join

76.What is the usage of control files in Oracle?

Ans:

In Oracle, the control file is used for database recovery. The control file is also used to identify the database and redo log files that must be opened for database operation to go ahead, whenever an instance of an ORACLE database begins.

77. What is a synonym?

Ans:

synonym is also known as alias for a table, view, sequence or program unit

78. What are the different types of synonyms?

Ans:

There are two types of synonyms or alias:

Private: It can only be accessed by the owner.

Public: It can be accessed by any database user.

79. What is the usage of synonyms?

Ans:

• Synonym can be used to hide the real name and owner of an object.
• It provides public access to an object.
• It also provides location transparency for tables, views or program units of a remote database.
• It simplifies the SQL statements for database users.

80. Define oracle tuxedo JCA adapter overview?

Ans:

81. How do you store pictures in a database?

Ans:

Yes, you can store pictures in a database using Long Raw Data type. This data type is used to store binary data for 2 gigabytes of length. However, the table can have only one Long Raw data type

82.What is the BLOB data type in Oracle?

Ans:

BLOB data type is a data type with varying length binary string. It is used to store two gigabytes of memory. For BLOB data type, the length needs to be specified in bytes.

83. What is WebLogic Tuxedo?

Ans:

The WebLogic Tuxedo Connector provides interoperability between WebLogic Server applications and Tuxedo services. The connector allows WebLogic Server clients to invoke Tuxedo services and Tuxedo clients to invoke WebLogic Server Enterprise Java Beans (EJBs) in response to a service request.

84. What is Exalogic/Exadata Features Benefiting Tuxedo Applications?

Ans:

Exalogic combines hardware, software, storage, and network components that ensure enterprise grade qualities of service, such as high availability, fault tolerance, high performance, and scalability – straight out of the box. Each Exalogic system contains the optimal amount of RAM (Random Access Memory), SSD (Solid State Drive), and storage so that the system is balanced for maximum performance.

85. Desfine Faster and Flexible Startup of Applications?

Ans:

With this feature, one can significantly improve the start-up time of large applications. Servers configured in an application can be started in parallel. The feature enables specifying startup dependencies of boot sequence at the group and server levels.

86. What is Transaction Context Propagation Started from Oracle Tuxedo?

Ans:

XA transaction context can be propagated from Oracle Tuxedo applications to JEE applications.

87. Describe Integration with JDeveloper SOA Extension?

Ans:

Tuxedo JCA Adapter is integrated with the Oracle JDeveloper SOA Extension for enhanced user experience. This feature allows user applications to access Oracle Tuxedo services through SOA components without needing to write any code.

88. Define Oracle Tuxedo JCA Adapter Installation Prerequisites?

Ans:

Tuxedo JCA Adapter is contained in a single resource archive file (com.oracle.tuxedo.TuxedoAdapter.rar), which can be downloaded from the Oracle product

89. What is the use of the SHOW option in the IMP command?

Ans:

The SHOW option specifies when the value of show=y, the DDL within the export file is displayed

90. Define oracle tuxedo domain?

Ans:

91. What is the use of the IGNORE option in the IMP command?

Ans:

The IGNORE option is used to specify how object creation errors should be handled.

92.What is the use of the INDEXES option in the IMP command?

Ans:

The INDEXES option is used to determine whether indexes are imported.

93. What is the use of GRANT option in IMP command?

Ans:

GRANT is used to import object grants.

94.What are the limitations of CHECK constraint?

Ans:

The main limitation of CHECK constraint is that the condition must be a Boolean expression evaluated using the values in the row being inserted or updated and can’t contain sub queries.

95. What is the meaning of recursive hints in Oracle?

Ans:

The number of times a dictionary table is repeatedly called by various processes is known as a recursive hint. Recursive hints occurred because of the small size of the data dictionary cache.