what is analyze command ? what kind of statistics does it
generate?
Answers were Sorted based on User's Feedback
Answer / mr. chandra
analyze command is used to check the statics of the query
and performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / brahma prakash
It Analyze the cost of the query with shortest excution path
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the parameter mode that can be passed to a procedure?
9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS
What are the different types of record groups in oracle? Explain each of them
What is merge in oracle?
How to add a new column to an existing table with a default value?
List the various oracle database objects?
Can a field be used in a report without it appearing in any data group ?
select statement does not retrieve any records. what exception is raised?
How to save query output to a local file?
What is currency type in database ?
How to view all columns in an existing table?
Explain what are the different type of segments?