GeekInterview.com
Series: Subject: Topic:

Oracle DBA Interview Questions

Showing Questions 1 - 20 of 252 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

Why we use materialized view? Or when do I go for an materialized view

Asked By: Rakesh057 | Asked On: Jul 19th, 2014

Please give any scenario (or) example of its very help full?

Answered by: venkat Sidda on: Jul 28th, 2014

Performance of materialized view is greater than View

Version upgrade

Asked By: Rish Wish | Asked On: Jan 13th, 2014

How would you plan for an Oracle upgrade? What are the prerequisites?

Answered by: rohith on: Jul 21st, 2014

if u want to any up-gradation in oracle first we need to check version compatibility like if u want to upgrade from 10g to 11g the 10g version should be 10.2.0.4 or 10.2.0.5. then install the 11g sof...

Startup mount and startup nomount

Asked By: Malik | Asked On: Sep 14th, 2011

What is the difference between startup mount and startup nomount? When its used?

Answered by: pattiprashanth on: Jul 8th, 2014

Startup NoMount: when you trigger "startup nomount". oracle reads pfile/spfile parameters and view the controlfiles in this stage. Startup Mount: when you trigger "startup mount". oracle reads contro...

Answered by: sriniv@s.. on: May 14th, 2012

Start up No mount: instance started with help of parameter file & here control files are located.

Start up mount:database is mounted i.e control files are allocated & data files, redo logs are located.

Open: here allocated all data & redo logs.Now the database is ready to use.

Which process writes data from data files to database buffer cache?

Asked By: Interview Candidate | Asked On: May 7th, 2005

Answered by: mahesh on: Jun 19th, 2014

Buffer cache ..........datafiles :dbwr
data files ...............buffer cache :server process

Answered by: mahesh on: Jun 6th, 2014

Data files to buffer cache server process writes

Oracle admin scenario based question

Asked By: Pragati.rch | Asked On: Apr 19th, 2008

I have applied the following commands:shutdown abortstartupnow what will happen, will the database will give an error / it will work.

Answered by: karthik on: Jun 18th, 2014

Shut down Abort==> immediately shuts down the database. statup now==> no startup avail like this.starup force ==> shutdown abort + startup

Answered by: yogesh chadnae on: Oct 25th, 2011

no oracle will not give u an error but it will perform media recovery between mount and open stage. let me describe this their are 4 modes of shuttin down the database ...

What is the use of control file

Asked By: Interview Candidate | Asked On: Jul 7th, 2005

Answered by: pavan dba on: Jun 12th, 2014

Control file contains:
The database name
Names and locations of associated datafiles and redo log files
The time stamp of the database creation
The current log sequence number
Checkpoint information

Answered by: revathi on: Oct 16th, 2013

Control file is back bone of database. Contorl file having all information about redo log files and log files.

How do you kill a process in UNIX

Asked By: Pragati.rch | Asked On: Apr 19th, 2008

Answered by: hemu on: Mar 15th, 2014

Kill -9 (process id)
pkill (process name)

Answered by: Priyanka Shetty on: Jan 30th, 2014

Kill -9

Can you start a database without spfile in Oracle 9i?

Asked By: Interview Candidate | Asked On: Aug 24th, 2005

Answered by: Saddam Mulla on: Mar 2nd, 2014

Yes we can start oracle database without spfile but required pfile
(Spfile is a system file and pfile is a manual crest file)

Answered by: ajay on: Feb 5th, 2014

We can start the database but we required spfile or pfile mandatory

What is difference between spfile and init.Ora file???

Asked By: hasanvtu | Asked On: Nov 1st, 2006

Answered by: AJAY on: Feb 5th, 2014

Spfile is in binary format we cannot edit but in init.ora file we can edit

Answered by: manoj on: Jan 22nd, 2014

Spfile is in binary format or in encrypted type we cannot modify the values but pfile is in ASCII format we can change the values.

What parameter should be consider while defining the size of sga

Asked By: neha.awasthi1 | Asked On: May 18th, 2011

Answered by: arjun on: Feb 14th, 2013

Before 11g sga_target from 11g onwards memory_target is mandatory

Answered by: sridhar on: Aug 1st, 2011

Mandatory parameter are:
1.db_cache_size
2.log_buffer_size
3.shared_pool_size
4.sga_max_size

Layer exception handling

Asked By: shanthiavari | Asked On: Jun 10th, 2008

In exception handling we have some not_found and others. In inner layer we have some not_found and others. While executing which one whether outer layer or inner layer will check first?

Answered by: AK Badola on: Dec 17th, 2012

Inner layer

What is database link

Asked By: Interview Candidate | Asked On: Jul 7th, 2005

Answered by: Abhinav on: Nov 5th, 2012

A database link is a path to another database with the help of which a user can access the schema objects of later database.

Answered by: Jaydeep Galiya on: Oct 28th, 2012

Database link is an implementation of chaining.The database link behaves like a database but has no persistent storage.Instead,it points to data stored remotely.

How will you move a table from one schema to other ?

Asked By: Dinesh gunwant | Asked On: Oct 21st, 2011

Answered by: Nony on: Oct 7th, 2012

Alter table move tablespace USERS

Answered by: chandrasekar.s on: Jun 1st, 2012

Using alter table command we can move one table from one schema to other

Code
  1. SQL>create TABLE t1
  2. unrecoverable AS SELECT * FROM other_schema.t1;
  3.  

How to estimate size of database?

Asked By: PARTHA SINHA | Asked On: Jan 25th, 2007

Answered by: sanu on: Sep 26th, 2012

SQL> select a.datafile_size + b.temp_size + c.redo_size + d.controlfile_size "Total_size in GB" from ( select sum(bytes)/1024/1024/1024 as datafile_size from dba_data_files) a, ( select nvl(sum(by...

Answered by: prati on: Mar 7th, 2007

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 .

What is the difference between view and materialised view?

Asked By: madhuri_v123 | Asked On: Aug 23rd, 2012

Answered by: hanuman on: Sep 4th, 2012

View does not consume space and materialized view consume space

Answered by: manoj100 on: Aug 26th, 2012

A view is a simple select statement executed each time user runs query against it A materialized view is a physical persistent object used for performance improvement of summary data or replication. ...

Online backup of a control file

Asked By: Pragati.rch | Asked On: Apr 19th, 2008

Can you take online backup of a control file if yes, how?

Answered by: venu on: Sep 1st, 2012

Code
  1. SQL> ALTER DATABASE backup controlfile TO trace AS <PATH>
Specify the path where you want to store the controlfile backup.

Answered by: neha.awasthi1 on: May 18th, 2011

We can do this by suding RMAN:configure control file auto backup on;

Where can you check the state of the database after the startup command.

Asked By: Interview Candidate | Asked On: Oct 2nd, 2004

Answered by: venu on: Sep 1st, 2012

Code
  1. SELECT STATUS FROM v$instance
will give the required result.

Answered by: Wildy on: Jul 18th, 2011

Select instance_name, status, database_status, startup_time from v$instance;

Which functions can be improved by using transportable tablespaces?

Asked By: Interview Candidate | Asked On: Oct 2nd, 2004

Answered by: venu on: Sep 1st, 2012

The transportabel tablespaces enable us to transport data objects across different platforms.

Backing up or recovering a particular user/schema objects or data objects or tablespaces or entire databases is possible, which cannot be done using other backup techniques.

Answered by: Sriniv@s.. on: Jun 2nd, 2012

Moving data using transportable tablespace can be much faster than performing either export/import or unload/load of the same data.Bcz transporting a tablespace only requires the copying of datafiles & integrating the tablespace structural information.

What is SCN number in Oracle? Plz any one give me the explanation for SCN

Asked By: suri | Asked On: Sep 18th, 2006

Answered by: venu on: Sep 1st, 2012

SCN is generated by oracle when a transaction is successfully commited. This is referred to as SystemChangeNumber. We can think of it as a transaction id generated when we make some transaction in an ...

Answered by: SANTHOSH on: Aug 15th, 2012

SCN no is a number which is generated by the oracle, when we made any changes to the data that statements will be recorded in redo log files and every committed statement will be given this SCN no by oracle.

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

Asked By: anjibabu padala | Asked On: May 10th, 2007

Answered by: venu on: Sep 1st, 2012

We can also try the explainplan and tkprof utilities.

Answered by: Madhusmita Dash on: Jun 21st, 2012

I think we should check the indexing structure.May be for that it took more time.

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.