Home » Other » Training & Certification » Interview questions
Interview questions [message #168253] Wed, 19 April 2006 08:31 Go to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
received via PM


My questions are
1)Advantages of Oracle 9i over prior releases?
2)Differences between CHAR,VARCHAR and VARCHAR2?
3)Features of 10g?
4)briefly about oracle versions(like oracle 7i,8i.....) till?

Thank you!

shanti


MHE
Re: Interview questions [message #168256 is a reply to message #168253] Wed, 19 April 2006 08:46 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
1) Read the documentation. The site requires a free account. Search for the "Oracle9i Database New Features"
Some highlights of 9iR1: CASE statements, ANSI-compliant joins, introduction of TIMESTAMP data types, the use of SPFILE/PFILE, DBMS_METADATA, ...

2) CHAR is blank-padded, VARCHAR2 isn't. VARCHAR is in fact the same as VARCHAR2 but this might change in the future so Oracle recommends you to use VARCHAR2.

3) For 10g there's also a new features guide on the site mentioned above.

4) look here.

MHE

[Updated on: Mon, 19 June 2006 01:15]

Report message to a moderator

Previous Topic: Pls answer my question
Next Topic: Triggers Objective Question
Goto Forum:
  


Current Time: Thu Apr 02 01:41:26 CDT 2020