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?
388Post New Oracle DBA (Database Administration) Questions
What is difference between co-related sub query and nested sub query?
What skills does a dba need?
What are the functions of administration?
List five most important parameter in 9i affecting performance?
What are types of data model?
What file will give you oracle instance status information? Where is it located?
What do you understand by recovery catalog?
What are the five main functions of a database administrator?
How can you determine if an oracle instance is up from the operating system level?
Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
What is dba training?
What is oracle dba role?
What should a dba know?
What is tkprof and how is it used?
What are the various ingredients of sga?
