GeekInterview.com
Submitted Questions

What is the difference between temp file and data file?

Asked By: innovative | Asked On: Feb 1st, 2006
2 answers

Answered by: kumaresan.m on: Sep 12th, 2006

1)Database can be opened without tempfiles in the temporary tablespace.

2) Tempfiles can't be renamed.

3)Tempfiles doesn't need recovery.

4)Segments in temporary tablespace are dropped when no longer required.

Answered by: love_oracle on: Feb 13th, 2006

diffierence between tempfile and datafile are:1)tempfile does not want recovery2)tempfile can't be taken offline3)data of the tempfile lost when the oracle server shutdown

User Panel

Register
Login
Lost Password
Get Activation Code

Categories

Engineering

Interview Coaching

Interview Questions

Tech FAQs

Interview Coaching

BPO Career for BTech Graduates

Describe a time when you had to work under pressure.

Career Options for BCA Graduates

How to Overcome Employment Gap during interview.

What do you do when things do not go as planned? Cite an example.

Has there been a time when you were presented a problem and solved it?

What was the most important decision you ever had to make?

What are the career opportunities available for MCA Graduates?

What will you do when you are not able to get your message across to your audience?

Have you gone above and beyond your job description?

Interview Question

 Ask Interview Question?

 

Career Counselling

 Have Career Question?

 Ask Chandra

 Ask Only Career questions.

Follow us: