Tell me about standby database? What are some of the configurations of it? What should we watch out for?
509Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)
707What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
518Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
535Post New Oracle DBA (Database Administration) Questions
What is a database instance?
You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?
What does >> do?
Why do we need a database?
Tell me about standby database? What are some of the configurations of it? What should we watch out for?
How many types of dba are there?
What are the various ingredients of sga?
What operator tests column for the absence of data?
Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
What is a junior dba?
List five most important parameter in 9i affecting performance?
When configuring sqlnet on the client what files need to be set up?
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
What is the full form of dba?
Which rman command is used to create an exact replica of a database innew host?