GeekInterview.com
  I am new, Sign me up!
 

Oracle DBA Interview Questions


Oracle DBA Interview Questions

Questions: 231
Comments: 477
 Oracle DBA Tags
 Showing Questions 11-20 of 231 Questions
<< Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
 Sponsored Links

 
 Oracle DBA Interview Questions
Sorting Options :  

When the developer trying to compile the package. But the database gets hanged? What will you check?  
Latest Answer: We check the alert log file in bdump destination ...

When yesterday developer gives the following command: select count(*) from [table name]it gives the output within minutes, today the same command takes hours? What will you check? 
Latest Answer: Have a look into the following tables :DBA_HIST_SQLSTATdba_hist_snapshotby doing natural joins on these views for the SQL_ID, you will know about any plan changes happened. Do corrective actions as per the findings. ...

How will you rectify if one of the rollback segments gets corrupted 
Latest Answer: The only option available is to restore and recover the database followed by opening the database with resetlogs. ...

When exporting using filesize parameter, if three files is generated. How the Oracle name this three files?  
Latest Answer: When Export reaches the value you have specified for the maximum FILESIZE, Export stops writing to the current file, opens another export file with the next name specified by the FILE parameter, and continues until complete or the maximum value of FILESIZE ...

Three users at a time giving the following command: alter database backup controlfile to trace; How can you differentiate the file using the filename itself?  
Latest Answer: When you issue the command "alter database backup controlfile to trace ; " a trace file will be created in the user_dump destination.The default name of the trace file would look something similar to dbname_ora_5175.trc. The number 5175 is the unix process ...

When you execute: alter tablespace begin backup; How can Oracle engine can identify that the corresponding datafiles are in backupmode?  
Latest Answer: select * from v$backup; == in this view you can check for status,if it is ACTIVE that file is still in backup mode.Hope this helps you.ThanksKumar ...

What are the differences between database designing and database modeling?  
Latest Answer: Effective database design can help the development team reduce overall development time and costs. Undertaking the process of database design and creating a data model helps the team better understand the user's requirements and thus enables them ...

If the large table contains thousands of records and the application is accessing 35% of the table which method to use: index searching or full table scan?  
Latest Answer: To improve the performance we have to go for index searching. ...

In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Why?  
Latest Answer:  Gathering statistics can be very resource intensive for the server so avoid peak workload times to gather stale stats or Analyze Table . ...

How to check to memory gap once the SGA is started in Restricted mode?  

View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape