GeekInterview.com
Series: Subject: Topic:
Question: 10 of 32

What is the use of  ANALYZE command  ?

To perform one of these function on an index,table, or cluster: - To collect statistics about object used by the optimizer and store them in the data dictionary. - To delete statistics about the object used by object from the data dictionary. - To validate the structure of the object. - To identify migrated and chained rows of the table or cluster.
Asked by: Interview Candidate | Asked on: Sep 6th, 2004

This Question is not yet answered!

Related Answered Questions

Related Open Questions

User Panel

Register
Login
Lost Password
Get Activation Code

Categories

Backup and Recovery

Basics

Concepts and Architecture

D2K

Data Access

Database Administration

Database security

Database Tuning

Distributed Processing

General

Memory Management

Oracle Forms 4.0

PL/SQL

Programmatic Constructs

RMAN Interview Questions

Scenarios

SQL

SQL Plus

System Architecture

Interview Coaching

Tell me about a skill you recently acquired or improved.

How do you handle difficult situations?

Do you like working in a team or alone? Explain.

What do you think about continuous learning?

What is your way of building rapport with a person you just met?

Do you find yourself busy most of the time? Why?

Do you seek advice from others when you have a question?

Have you gone above and beyond your job description?

Career Options for BCA Graduates

Has there been a time when you were presented a problem and solved it?

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.

Subscribe