Interview Questions.

Question 1. When And By Whom Was Oracle Tuxedo Formed?

Answer :

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.

Question 2. What Does Tuxedo Mean To You?

Answer :

Well the overall form of Tuxedo is Transactions for Unix , Extended for allotted operations. Simply, it is a middle ware platform which manages the distribution of computing environments along side processing of transactions. It is also a move platform software program that can be run by using any operating device. 

Python Interview Questions
Question 3. Explain What Is A Middleware?

Answer :

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.

Question four. What Are The Languages Used By Oracle Tuxedo?

Answer :

The software program is written in 7 languages:

C 
C++
JAVA
PYTHON
COBOL
Ruby
PHP
Python Tutorial
Question 5. What According To You Is The Greatest Advantage Of Tuxedo?

Answer :

The fantastic clustering capability of Tuxedo is its best benefit. It can technique thousands and thousands of requests in a second. Being exceedingly optimized it receives responses within few microseconds.

PL/SQL Interview Questions
Question 6. Which Cluster Is Used By Oracle?

Answer :

Oracle uses Oracle RAC or Real Application Cluster. 

Question 7. Explain The Difference Between Rac & Non Rac Environment In Oracle?

Answer :

In case of Non RAC environment a single example accesses a single database. The database incorporates manipulate files, redo log files & database documents that is bodily present on table. Whereas, The RAC environment carries  or extra times speaking with a unmarried database ; these all are times walking on separate servers. 

C++ Tutorial C++ Interview Questions
Question eight. What Is Oracle Exadata?

Answer :

Exadata is certainly a statistics appliance. A information equipment is a server with pre-mounted & pre-optimized database.

Three major additives 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 stage , 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?

Answer :

There are nearly nine viable approaches to do this:

Physical Standby
Logical Standby 
Export/Import
Transportable Tablespace
Transportable Database
Golden gate
RMAN cold 
Oracle Streams
Hot backup restoration
Adv Java Interview Questions
Question 10. What Is Asm?

Answer :

ASM is Automatic storage control which became introduces in Oracle 10g . It affords storage solutions. It is a totally effective device for coping with multi-terabyte database.

The garage components of Oracle ASM are:

ASM Disks
ASM Disk corporations
ASM Allocation units
ASM Extents
ASM Files
ASM File Extent Map
ASM can upload a disk from the quantity or eliminate it, ASM can perform the weight balancing inside the storage. Basically , ASM offers the quantity manager layer that's critical for each software program. It also acts as a file machine.

Adv Java Tutorial
Question 11. Explain The Benefits Of Asm?

Answer :

There are several blessings of ASM . The maximum vital aspects of ASM are:

It stripes documents in place of logical volumes
It can carry out Online disk reconfiguration and dynamic rebalancing
It has adjustable rebalancing pace
It Provides redundancy on a file foundation
Besides, ASM  is  Custer-aware and it can be robotically mounted .
Oracle Interview Questions
Question 12. What Are The Temporal Data Types Provided By Oracle?

Answer :

Oracle provides 3 sorts of information sorts-

Date statistics type which offers extraordinary formats of dates.
Timestamp records kind which presents specific codecs of Time stamp.
Interval information type which affords c programming language between dates & times.
Python Interview Questions
Question thirteen. What Is Salt?

Answer :

SALT stands for provider structure leveraging tuxedo. It is a SOAP over https gateway. It turned into created to reveal tuxedo offerings as net offerings as a way to invoke web offerings from inside tuxedo applications the use of tuxedo API. SALT is configuration driven. It is scalable and fairly to be had. Code converting isn't required in case of SALT. 

COBOL Tutorial
Question 14. What Is An Oracle Instance?

Answer :

Oracle instance is a device worldwide vicinity (SGA) and the Oracle heritage procedures constitute an Oracle database instance. Every time a database is commenced, a gadget worldwide location is allotted and Oracle history tactics are started out. The SGA is deallocated whilst the instance shuts down. After starting an instance, Oracle buddies the instance with the required database. This is known as mounting the database. The database is then ready to be opened, which makes it accessible to authorized customers.

Question 15. What Is Oracle Package?

Answer :

Oracle bundle is a schema item that groups logically associated PL/SQL sorts, gadgets, and subprograms. Packages provide several blessings: modularity, easier application layout, facts hiding, brought functionality, and higher overall performance

COBOL Interview Questions
Question 16. Explain The General Concepts Of Pl/sq.?

Answer :

PL/SQL is Oracle's procedural extension to SQL. With PL/SQL, we will manage statistics with SQL statements, and manipulate software glide with procedural constructs including IF-THEN and LOOP. We can also claim constants and variables, define tactics and features, use collections and item sorts, and trap run-time errors. Applications written the usage of any of the Oracle programmatic interfaces can call PL/SQL stored tactics and send blocks of PL/SQL code to the server for execution. Because it runs within the database, PL/SQL code could be very efficient for records-extensive operations, and minimizes community site visitors in patron/server programs.

Oracle 11g Tutorial
Question 17. What Is Rdf?

Answer :

A set of rules (a form of language) for creating descriptions of records, specially records to be had on the World Wide Web. RDF can be used to explain a collection of books, or artists, or a set of internet pages as within the RSS records layout which uses RDF to create system-readable summaries of net websites. 

RDF is also used in XPFE programs to define the relationships among specific collections of elements, as an example RDF can be used to define the relationship between the records in a database and the manner that data is displayed to a person

Oracle 11g Interview Questions
Question 18. What Do The Oracle Logical Structures Comprised Of?

Answer :

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 with out affecting the get right of entry to to logical storage systems.

PL/SQL Interview Questions
Question 19. Define Cursor Variable?

Answer :

A cursor variable is related to specific statements which could hold exceptional values at run time. It is sort of reference type.

Unix/Linux Tutorial
Question 20. What Is A Pragma?

Answer :

Pragma is a key-word in Oracle PL/SQL this is used to offer an guidance to the compiler like PRAGMA AUTONOMOUS_TRANSACTION.

Ruby Interview Questions
Question 21. What Is Partitioning?

Answer :

Partitioning is a way of splitting massive tables and indexes into smaller, more plausible portions.

Question 22. What Is The Dcl & Ddl Language ?

Answer :

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

Question 23. What Is Explane Plan?

Answer :

The EXPLAIN PLAN declaration presentations execution plans selected through the Oracle optimizer for SELECT, UPDATE, INSERT, and DELETE statements. A assertion's execution plan is the collection of operations Oracle plays to run the statement. The row supply tree is the middle of the execution plan.

It shows the subsequent records:

An ordering of the tables referenced with the aid of the announcement
An access approach for each table cited within the statement
A be a part of method for tables suffering from be part of operations within the announcement
Data operations like clear out, kind, or aggregation In addition to the row supply tree
the plan desk contains facts about the following:

Optimization, together with the value and cardinality of every operation
Partitioning, including the set of accessed walls
Parallel execution
together with the distribution approach of be a part of inputs The EXPLAIN PLAN consequences allow us to decide whether the optimizer selects a selected execution plan, together with, nested loops be a part of.

Oracle Performance Tuning Interview Questions
Question 24. What Is Erp System?

Answer :

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

C++ Interview Questions