Advertise your Business Here      Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new    Refer this Site               Login  |  Sign Up                         To Refer this Site to Your Friends   Click Here

Categories  >>  Software  >>  Databases  >>  DB Administration          Oracle Interview Questions    SQL Server Interview Questions    MS Access Interview Questions    MySQL Interview Questions    Postgre Interview Questions    Sybase Interview Questions    DB Architecture Interview Questions    DB Administration Interview Questions    DB Development Interview Questions    SQL PLSQL Interview Questions    Databases AllOther Interview Questions What are the ways tablespaces can be managed and how do they differ? No Answer is Posted For this Question Be the First to Post Answer

 

Other DB Administration Interview Questions
Question	Asked @	Answers
How many memory layers are in the shared pool?		2
How do you find out from the RMAN catalog if a particular archive log has been backed-up?		1
When a user process fails, what background process cleans up after it?		1
What is the difference between the SQL Loader and IMPORT utilities?		2
Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?	Wipro	3
How would you determine what sessions are connected and what resources they are waiting for?		2
What column differentiates the V$ views to the GV$ views and how?		1
Give the two types of tables involved in producing a star schema and the type of data theyhold.		1
What is blocking and how would you troubleshoot it?		1
Name three advisory statistics you can collect.		1
Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility		1
How do you resize a data file?		2
CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva	CTS	1
what is incremental checkpoint?	CTS	1
When creating a user, what permissions must you grant to allow them to connect to the database?		2
I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?		1
Give the reasoning behind using an index.		2
Explain CREATE DATABASE syntax?		1
what is ora 600?		1
Explain the difference between a hot backup and a cold backup and the benefits associated with each?	TCS	4
For more DB Administration Interview Questions Click Here

         

Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |            Copyright © 2007  ALLInterview.com.  All Rights Reserved. ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com