Describe how you would monitor and control database
physical file size and growth?
Answer Posted / alok
connect as dba to the database and fire the query
show db_parameter_file; on oracle database (I am not sure
on query, u can search for a similar query)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What do you understand by local lookup?
What are the different types of parallelism in ab initio?
How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?
Suppose you find the term validation mentioned with a set of data, what does that simply represent?
How you can run a graph infinitely in ab initio?
What do you mean by the term data warehousing?
What are the different types of partition components in abinitio?
How would you find out whether a sql query is using the indices you expect?
What are the different types of parallelism used in abinitio?
How to create repository in abinitio for stand alone system(local nt)?
Explain about ab initio’s dependency analysis?
What do you mean by data sorting?
What is a cursor? Within a cursor, how would you update fields on the row just fetched?
What is the difference between rollup and scan?
What is the ab initio business rules environment (bre)?