Home » Other » Training & Certification » plz tell me
plz tell me [message #149557] Fri, 02 December 2005 04:33 Go to next message
genialsenthil
Messages: 26
Registered: June 2005
Location: Chennai
Junior Member
Hi pls i need answer for this question,

1.diff between pfile and spfile and its uses?

2.diff between locally managed tablespace and dictionary managed tablespace?

3.what is the main cause snapshot too old error?

4.what is difference undo segment and rollback segment?

5.if undo segment is lost can we recover the database?

6.what is the maxium number of redo log can v have and what is the maxium of members can we have database?

7.if we losted a initora file can we able to start the database?

8.what is default size to create a database?

9.can database have two rollback segments?

10.what are the different types tables in oracle?

11.what is partitioned table and what is the use?

12.What is advantages of export and import?

13.what are the new thing in oracle9i

Regards,
Senthil kumar. muthub4u@gmail.com
Re: plz tell me [message #149583 is a reply to message #149557] Fri, 02 December 2005 06:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Many can 'answer' your question.
But, how can you be sure that whatever me/anyone said is right?
What if my/anyone's 'answer' was just plainly wrong?
These questions are pretty basic and should be available in any book that deals with oracle database administration.
READ the book.
or
read the server concepts / administration manual.
If do not understand anything in that, Post here.
We can discuss/argue/demonstrate/provide proof-of-concept and clarify your doubt ( or make it worse. Smile. What are DBAs for? )
http://www.oracle.com/pls/db92/db92.docindex?remark=homepage

Almost all the questions are answered here
http://www.orafaq.com/faq/

The most generic questions like
what is biggest/smallest/lengthiest/best/worse/newest/oldest/difference between/ advantages of any oracle features are best accounted in oracle documentation.
And search this forum or google yourself before posting a question.
For example, the following question is hoariest and been asked a zillion zillion times.

>>13.what are the new thing in oracle9i

The right question would be

>>13.what are the OLD things in oracle9i and NEW things in 10gR2.

[Updated on: Fri, 02 December 2005 06:44]

Report message to a moderator

Re: plz tell me [message #149836 is a reply to message #149583] Mon, 05 December 2005 04:22 Go to previous message
naveen19
Messages: 24
Registered: November 2005
Location: Chennai
Junior Member

HI
MANISH THANKS FOR UR REPLY.

IF U DO IT PLZ ANSWER ALL THE QUESTIO U KNOWN,
AND ITS FOR INTERVIEW PREPARTION,PLZ HELP ME IN THIS ANSWERS.


1.if we losted a initora file can we able to start the database?

2.can database have two rollback segments?

3.what is the main cause snapshot too old error?

4.what is the maxium number of redo log can v have and what is the maxium of members can we have database?

REGARDS
SENTHIL KUMAR
Previous Topic: Not able to open periods - Pls help
Next Topic: Interview Questions
Goto Forum:
  


Current Time: Tue Aug 11 11:46:55 CDT 2020