Oracle Versions

SUCCESS FOR CAREER

Oracle Versions

1977
Relational Software Inc. (RSI - currently Oracle Corporation) established
1978
Oracle V1 ran on PDP-11 under RSX, 128 KB max memory. Written in assembly language. Implementation separated Oracle code and user code. Oracle V1 was never officially released.
1980
Oracle V2 released - the first commercially available relational database to use SQL. Oracle runs on on DEC PDP-11 machines. Coide is still written in PDP-11 assembly language, but now ran under Vax/VMS.
1982
Oracle V3 released, Oracle became the first DBMS to run on mainframes, minicomputers, and PC's (portable codebase). First release to employ transactional processing. Oracle V3's server code was written in C.
1983
Relational Software Inc. changed its name to Oracle Corporation.
1984
Oracle V4 released, introduced read consistency, was ported to multiple platforms, first interoperability between PC and server.
1986
Oracle V5 released. Featured true client/server, VAX-cluster support, and distributed queries. (first DBMS with distributed capabilities).
1987
CASE and 4GL toolset
1988
Oracle V6 released - PL/SQL introduced.
Oracle Financial Applications built on relational database.
1989
Released Oracle 6.2 with Symmetric cluster access using the Oracle Parallel Server
1991
Reached power of 1,000 TPS on a parallel computing machine.
First database to run on a massively parallel computer (Oracle Parallel Server).
1992
Released Oracle7 for Unix
1993
Rollout of Oracle's Cooperative Development Environment (CDE).
Introduction of Oracle Industries and the Oracle Media Server.
1994
Oracle's headquarters moved to present location.
Released Oracle 7.1 and Oracle7 for the PC.
1995
Reported gross revenues of almost $3 billion.
1995
OraFAQ.com website launched.
1997
Oracle8 released (supports more users, more data, higher availability, and object-relational features)
1998
Oracle announces support for the Intel Linux operating system
1999
Oracle8i (the "i" is for internet) or Oracle 8.1.5 with Java integration (JVM in the database)
2000
Oracle8i Release 2 released
Oracle now not only the number one in Databases but also in ERP Applications
Oracle9i Application Server generally available: Oracle tools integrated in middle tier
2001
Oracle9i Release 1 (with RAC and Advanced Analytic Service)
2002
Oracle9i Release 2
2004
Oracle10g Release 1 (10.1.0) available ("g" is for grid, the latest buzzword)
2005
The Oracle FAQ (this site) is 10 years old!
2006
Oracle 10g XE(small data base free of cost for learning ) HTMlDB.

2007 Oracle 11g

EXAMAPERS123.BLOGSPOT.COM

Data Type Description

SUCCESS FOR CAREER

Data Type Description

VARCHAR2( len) Can store up to len number of characters. Each character would occupy one byte. Maximum width is 4000 characters.
VARCHAR(len) Same as VARCHAR2. But use VARCHAR2 as Oracle might change the usage of VARCHAR in future releases.
CHAR(len) Fixed length character data. If len is given then it can store up to len number of characters. Default width is 1. String is padded on the right with spaces until string is of len size. Maximum width is 2000.
NUMBER Can store numbers up to 40 digits plus decimal point and sign.
NUMBER (p ,s) P represents the maximum significant digits allowed. S is the number of digits on the right of the decimal point.
DATE Can store dates in the range 1-1-4712 B.C to 31-12-4712 AD.
LONG Variable length character values up to 2 gigabytes. Only one LONG column is allowed per table. You cannot use LONG datatype in functions, WHERE clause of SELECT, in indexing and subqueries.
RAW and LONG RAW Equivalent to VARCHAR2 and LONG respectively, but used for storing byte-oriented or binary data such as digital sound or graphics images.
CLOB, BLOB, NCLOB Used to store large character and binary objects. Each can accommodate up to 4 gigabytes. We will discuss more about it later in this book.
BFILE Stores a pointer to an external file. The content of the file resides in the file system of the operation system. Only the name of the file is stored in the column.
ROWID Stores a unique number that is used by Oracle to uniquely identify each row of the table.
NCHAR (size) Same as CHAR, but supports national language.
NVARCHAR2 (size) Same as VARCHAR2, but supports national language.

EXAMAPERS123.BLOGSPOT.COM

Cognizant Paper

Cognizant Paper
1. A says " the horse is not black".
B says " the horse is either brown or grey."
c says " the hoese is brown"
At least one is telling truth and atleast one is lying. tell
The colour of horse.
Answer : grey
2. A son and father goes for boating in river upstream . After rowing for 1 mile son notices the hat of his father falling in the river. After 5 min. he tells his father that his hat has fallen. So they turn around and are able to pick the hat at the point from where they began boating after 5 min. Tell the speed of river.
Ans...6 miles/hr

3 A+B+C+D=D+E+F+G=G+H+I=17 where each letter represent a number from 1 to
9. Find out what does letter D and G represent if letter A=4. (8 marks)
ans. D=5 G=1

4. Argentina had football team of 22 player of which captain is from Brazilian team and goalki from European team. For remainig palayer they have picked 6 from argentinan and 14 from european. Now for a team of 11 they must have goalki and captain so out of 9 now they plan to select 3 from argentinian and 6 from European. Find out no. of methods
available for it (2 marks)
Ans : 160600( check out for right no. 6C3 * 14C6)

5 Three thives were caught stealing sheep, mule and camel.
A says " B had stolen sheep "
C says " B had stolen mule"
B says he had stolen nothing.
the one who had stolen horse is speaking truth. the one who had stolen camel is lying . Tell who had stolen what? (5 marks)
ans. A- camel
B- mule
C- horse
6 a group of friends goes for dinner and gets bill of Rs 2400 Two of them says that they have forgotten their purse so remaining make an extra contribution of Rs 100 to pay up the bill. Tell the no. of person in that group. (3 marks)
Ans - 8 person

EXAMAPERS123.BLOGSPOT.COM

7. In a colony there are some families. Each of them have children but different in numbers.
Following are conditions
a> no of adult>no of sons>no of daughters>no of families.
b>each sister must have atleast one brother and should have at the most 1 sister.
c> no of children in one family exceeds the sum of no of children in the rest families.

Tell the no of families.(5 marks)
ans : 3 families

8.There are 6 people W,H,M,C,G,F who are murderer , victim , judge , police, witness, hangman. There was no eye witness only circumtancial witness. The murderer was sentenced to death.
Read following statement and determine who is who.

1. M knew both murderer and victim.
2. Judge asked C to discribe murder incident.
3. W was last to see F alive.
4. Police found G at the murder site.
5 H and W never met.