Question 1. 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 a software that was developed by Oracle corporations in 2008.
Question 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 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.
Question 3. Explain What Is A Middleware?
Technically, Middleware is a hidden layer or layers of software between Operating system and Application. It comprises of common functionalities crucial for many applications.
Question 4. What Are The Languages Used By Oracle Tuxedo?
The software is written in 7 languages:
Question 5. What According To You Is The Greatest Advantage Of 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.
Question 6. Which Cluster Is Used By Oracle?
Oracle uses Oracle RAC or Real Application Cluster.
Question 7. Explain The Difference Between Rac & Non Rac Environment In Oracle?
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.
Question 8. What Is Oracle Exadata?
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).
Question 9. How Can We Shift A Normal Database To Exadata?
There are almost 9 possible ways to do that:
- Physical Standby
- Logical Standby
- Transportable Tablespace
- Transportable Database
- Golden gate
- RMAN cold
- Oracle Streams
- Hot backup restoration
Question 10. What Is Asm?
ASM is Automatic storage management which was introduces in Oracle 10g . It provides storage solutions. It is a very powerful tool for managing multi-terabyte database.
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.
Question 11. Explain 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 adjustable rebalancing speed
- It Provides redundancy on a file basis
- Besides, ASM is Custer-aware and it can be automatically installed .
Question 12. What Are The Temporal Data Types Provided By Oracle?
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.
Question 13. 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 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.
Question 14. 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.
Question 15. What Is 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
Question 16. 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 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.
Question 17. 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 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
Question 18. What Do The Oracle Logical Structures Comprised 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 the access to logical storage structures.
Question 19. Define Cursor Variable?
A cursor variable is associated with different statements which can hold different values at run time. It is kind of reference type.
Question 20. 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.
Question 21. What Is Partitioning?
Partitioning is a method of splitting large tables and indexes into smaller, more manageable pieces.
Question 22. 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).
Question 23. What Is Explane 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 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.
Question 24. 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.
Python Interview Questions
PL/SQL Interview Questions
C++ Interview Questions
Adv Java Interview Questions
Adv Java Tutorial
Oracle Interview Questions
Python Interview Questions
COBOL Interview Questions
Oracle 11g Tutorial
Oracle 11g Interview Questions
PL/SQL Interview Questions
Ruby Interview Questions
Oracle Performance Tuning Interview Questions
C++ Interview Questions