IBM Exam C1000-085 Topic 4 Question 69 Discussion

Actual exam question for IBM's C1000-085 exam

Question #: 69
Topic #: 4

[All C1000-085 Questions]

How can a user update statistics on a table?

Aby running UPDATE STATISTICS

Bby running a query against the table

Cby running GENERATE STATISTICS

Dby restarting the database

Show Suggested Answer

Suggested Answer: A

by Ngoc at Sep 17, 2024, 10:31 PM

Limited Time Offer

25%

Off

Get Premium C1000-085 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Caren

2 months ago

I'm not sure, but I think it's C) by running GENERATE STATISTICS. That makes sense to me.

upvoted 0 times

...

Frederica

2 months ago

I agree with Hermila. Running UPDATE STATISTICS updates the statistics on a table.

upvoted 0 times

...

Hermila

3 months ago

I think the answer is A) by running UPDATE STATISTICS.

upvoted 0 times

...

Tamar

3 months ago

As a database enthusiast, I can tell you that option A is the way to go. Anything else is just voodoo magic!

upvoted 0 times

...

Kristel

3 months ago

C sounds promising, but I'm not familiar with the 'GENERATE STATISTICS' command. Gotta do some research on that one.

upvoted 0 times

...

Theodora

3 months ago

D is just silly. Restarting the database? That's like using a sledgehammer to crack a nut!

upvoted 0 times

...

Carmelina

3 months ago

B seems like a logical choice, but I'm not sure if that's enough to update the statistics. Hmm...

upvoted 0 times

...

Levi

3 months ago

Option A is the way to go! It's the most direct method to update statistics on a table.

upvoted 0 times

Karrie

2 months ago

Option A is definitely the most efficient way to update statistics on a table.

upvoted 0 times

...

Ashley

2 months ago

B) by running a query against the table

upvoted 0 times

...

Queenie

2 months ago

I always use option A to update statistics on a table.

upvoted 0 times

...

Marci

2 months ago

A) by running UPDATE STATISTICS

upvoted 0 times

...

Naomi

3 months ago

I always use UPDATE STATISTICS to make sure my table statistics are up to date.

upvoted 0 times

...

Paris

3 months ago

I agree, running UPDATE STATISTICS is the best way to update table statistics.

upvoted 0 times

...