Why do you analyze a schema object (table, index, or cluster)?

1.	Why do you analyze a schema object (table, index, or cluster)?
A.	No need to Collect and manage statistics for it
B.	Does not verify the validity of its storage format
C.	UnIdentify migrated and chained rows of a table or cluster
D.	None of the above
Answer» E.

Discussion

No Comment Found

Related MCQs

Which of the following errors are correctable?
In Suspended Statements which view is used When a statement is suspended the session invoking the statement is put into a wait state. A row is inserted into this view for the session with the EVENT column containing "statement suspended, wait error to be cleared"?
Which effects will a trigger have in the AFTER SUSPEND trigger whenever a resumable statement is suspended in any session?
Why do you analyze a schema object (table, index, or cluster)?
What can be included in the CREATE SCHEMA statement which is useful if you want to guarantee the creation of several tables, views, and grants in one operation?
DBMS_ADVISOR package procedures relevant to the segment advisor which package procedure name use this procedure to create the Segment Advisor task. Specify 'Segment Advisor as the value of the ADVISOR_NAME parameter?
In Schema Objects Data Dictionary Views which view List the name, type, and owner (USER view does not display owner) for all tables, views, synonyms, and sequences in the database?
The following query lists all of the base objects for the synonyms created by user jward. What is displayed by the following example?SELECT TABLE_OWNER, TABLE_NAME, SYNONYM_NAMEFROM DBA_SYNONYMSWHERE OWNER = 'JWARD';The following is the query output:TABLE_OWNER----TABLE_NAME----SYNONYM_NAME---------------------- ----------- -----------------SACHIN---------DEPT----------DEPTSACHIN---------EMP-----------EMP
Where are theLOBs and varrays stored?
How many levels can we request advice from the Segment Advisor?

Why do you analyze a schema object (table, index, or cluster)?

Discussion

No Comment Found

Related MCQs

Reply to Comment