Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Oracle DBA (Database Administration) Interview Questions
Questions Answers Views Company eMail

What is the use of the drop option in the alter table command?

84

How do you use automatic pga memory management with oracle 9i and above?

68

Which function is used to find the largest integer less than or equal to aspecific value?

72

Explain procedure to change characterset of a database.

68

What is oracle archived redo log?

73

what does the no logging option do? Why would we use it?

69

What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?

68

List five most important parameter in 9i affecting performance?

78

What is the difference between rman and a traditional hotbackup?

1 157

How can you tell if an index on particular table is used or not used in 9i?

68

You see a wait on lms process in statspack, what does that mean?

76

What does the no logging option do? Why would we be careful of using it?

76

Tell me about standby database? What are some of the configurations of it?

64

When using oracle export/import what character set concerns might come up? How do you handle them?

88

Which date function is used to find the difference between two dates?

72


Post New Oracle DBA (Database Administration) Questions






Un-Answered Questions { Oracle DBA (Database Administration) }

How to drop an oracle database?

70


Which function is used to find the largest integer less than or equal to aspecific value?

72


What is the easiest method to create a file on unix?

66


Explain the wait events in statspack report 'db scattered read'?

69


What is the relation between database and instance?

66






If you see statistics that deal with "undo" what are they really talking about?

65


You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?

72


A tablespace has a table with 30 extents in it. Is this bad? Why or why not.

73


Is oracle dba in demand?

71


What parameters control copy latches?

78


What is difference between co-related sub query and nested sub query?

79


what does the no logging option do? Why would we use it?

69


What do you understand by recovery catalog?

71


Explain procedure to change characterset of a database.

68


You have taken a manual backup of a datafile using os. How rman will know about it?

76