Oracle DBA Interview Questions

Questions: 226

Comments: 399

Oracle DBA Tags

—

Backup, DBMS, Parallel Server, Replication

Showing Questions 101-110 of 226 Questions

<< Previous 7 8 9 10 [11] 12 13 14 15 16 Next >>

Sponsored Links

Oracle DBA Interview Questions

Sorting Options :

When a database is started, Which file is accessed first?

Latest Answer: you want to starting up a database by using STARTUP command....SQL>STARTUPto start instance, database must read the intialization parameter from either a server parameter file(SPFILE)or a traditional text intialization parameter file.When you ...

Read Answers (2) | Asked by : shridhar

Answer Question Subscribe

What is difference between latch,locks and enqueue ?

Latest Answer: Often the word "lock" is synonymous to enqueue. In this document, "enqueue" will be used for the locking mechanism that you can find in V$LOCK. "locking" will be used when talking about requesting an enqueue, waiting on an ...

Read Answers (1) | Asked by : jayant Nimje

Answer Question Subscribe

When a user comes to you and asks that a particular SQL query is taking more time. How will you solve

When a user comes to you and asks that a particular SQL query is taking more time. How will you solve this?

Read Answers (1) | Asked by : anjibabu padala

Answer Question Subscribe

Is it possible to drop more than one table using single sql statement? if yes then how.

Latest Answer: Try using substitution variable likeDROP TABLE &table_name ...

Read Answers (4) | Asked by : ambrish20

Answer Question Subscribe

What is the difference between materialized view and snapshots

Latest Answer: snapshots can't upated. While MV can be updated contantley. ...

Read Answers (2) | Asked by : sanju`

Answer Question Subscribe

How many maximum number of columns can be part of Primary Key in a table in Oracle 9i and 10g?

Latest Answer: You can set primary key on table upto 16 columns of table in oracle 9i and 10g ...

Read Answers (1) | Asked by : Sachin Talwar

Answer Question Subscribe

What is RAP?

View Question | Asked by : sreedhar

Answer Question Subscribe

What is RAC? What is Data Migration? What is Data Pumping?

Latest Answer: And.. I think, the question is about Data Migration - something related to migrating data between different databases.I have done using different tools like Data Junction, Informatica, even PL/SQL and SQL Loader. ...

Read Answers (2) | Asked by : brad1

Answer Question Subscribe

How to estimate size of database?

Latest Answer: select sum ( bytes) from dba_data_files ;select sum(bytes) from v$log;select sum ( bytes ) from dba_temp_files ;Total sum of all the three will give the database size . ...

Read Answers (3) | Asked by : PARTHA SINHA

Answer Question Subscribe

Oracle DBA Questionswhat happen when we kill smon,what happen when we kill pmonwhat is fracture block

Oracle DBA Questionswhat happen when we kill smon,what happen when we kill pmonwhat is fracture block and how to fix itwhat is corrupted block and how to fix itwhat are the oracle threads are going to start ,when we start the databasehow to check index is working properly ,what are the steps to be taken andon what basis we have to decide particular index has to rebuild not all indexeswhat steps to be taken if receive a call that performance has gone down as dba what steps has be takenWhat possible

View Question | Asked by : Ibad

Tags : Backup

Answer Question Subscribe

View page << Previous 7 8 9 10 [11] 12 13 14 15 16 Next >>

Go Top

#	User Name	Count
1	Pragati.rch	42
2	shanthiavari	33
3	cmanne	10
4	senthilora	7
5	satyam_Ora	6
6	rajendra_thanekar	6
7	hasanvtu	5
8	hemant.agarwal03	5
9	nafees	5
10	baala	4

Get Latest Updates Via RSS Reader or by Email
Forum Discussion
Knowledge Base
Learning Series
Freelance Jobs
GeekInterview Blog
Testing Interview Questions
Oracle Interview Questions
Java Interview Questions
Latest Placement Papers
Free Training
Learn AJAX