Home » MCQs » SQLite MCQs

Which of the following is/are the syntax of ANALYZE statement?

80. Which of the following is/are the syntax of ANALYZE statement?

1. ANALYZE;
2. ANALYZE database_name;
3. ANALYZE database_name.table_name;
4. All of the above

Answer: D) All of the above

Explanation:

The following are the syntax of ANALYZE statement -

1. ANALYZE;
2. ANALYZE database_name;
3. ANALYZE database_name.table_name;