Oracle DBA FAQ
Access 2010 moving from one record to another
I am now using an access program that was created years ago and I used it 5 yrs ago and am now back - and when I attempt to go from 1 record to another with the arrows at the bottom - it use to scan very quickly and now I have to click on the arrow each time to make it go from one record to another....
Disk have become damage and we have datafile on it.
I have some datafiles were there on a secondary disk and that disk has become damaged and new disk at this time not available. How will I recover from this situation? thanks in advance. ibrahim
What does error 0600 mean?
These are the internal errors. we have to contact Oracle Support
Transactions during hot backup
Where will the transactions be stored during hot backup? during hot backup we specify the tablespace during beginning backup mode and now if a user perform some transactions then where such transactions are stored?
In HOT backup mode users transaction/data is goes in their respective default tablespaces only since the datafile header will not update til the time you end the backup mode
How to find the startup time of instance?
how to get instance startup time
>select to_char(startup_time,'dd-mon-yyyy HH12:MI:SS ')"db startup time"
2 from sys.v$instance;
Use this simple command in SQLPlus or an a query retreival tool of your choice.
select To_char(startup_time, 'Mon-dd-yyyy hh24:mi AM') as STARTUP_TIME from v$instance;
Explain what are Oracle catlog & Oracle archive log ?
when the log writer writes into the redo logs i.e online redo logs in circular motion.when one redo log is full it switches to another redo log , at this point of transfer it is called log switch.
oracle catalog used for recovery purpose in RMAN our target database registered in catalog and storing metadata for the target database. Archivelog is also used for recovery purpose but its store red...
What is meant by remote backup?
suppose as a client u connected to server with the help of some third party tool and you are going to take backup from your server then that is called remote backup.
Explain in detail what are bdump, cdump & udump?
background dump (bdump) :--. > bdump is used for all the issues raised related to background process in our database. its also contain alert .log which contain all activities and issues related to da...
What is the use of catalog and no catalog in RMAN?
rman with catalog means our target database registered in catalog and its used for recovery purpose. its containing metadata about to database.
rman with no catalog means metadata stored in controlefile through the controlfile we can do the recovery.
How to take backup using RMAN backup, without catalogdb?
What are archive files? What are the uses with archive files?
Before discussing about archive files we will be discuss about redolog files ,these redologfiles records every operation done on the database, so when the datafiles are damaged, we can get complet...
Archives files are files which are placed together in a bunch for any particular work. Benefit of this is there is no chance of missing of files while transfer from one place to another, also you...
In the hint, pq_distribute, which is the outer distribution table and which is the inner distribution table?
How we can decide at run time that which database is going to use among Oracle, SQL server, ms access and so on available databases?
In DBMS, what is a relation?
Relation is defined as a set of tuples that have the same attributes.
What is pctincrease in Oracle? How the memory is allocated, reallocated and autoextended while creating tablespaces? What is meant by initial and default in tablespaces and how the next is a multiple of five times db_block_size?
What is dump destination?
What is growth factor?
What is pct increase parameter in segment?
What is pct free and pct used?
User Panel
Categories
Interview Coaching
Ads
Connect
Ads
Interview Question
Latest Questions
Ads
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.
NH
