Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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?

Show Suggested Answer Hide 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
...
...

Save Cancel