Deal of The Day! 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
10 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
10 months ago
I agree with Hermila. Running UPDATE STATISTICS updates the statistics on a table.
upvoted 0 times
...
Hermila
11 months ago
I think the answer is A) by running UPDATE STATISTICS.
upvoted 0 times
...
Tamar
11 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
11 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
11 months ago
D is just silly. Restarting the database? That's like using a sledgehammer to crack a nut!
upvoted 0 times
...
Carmelina
11 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
11 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
10 months ago
Option A is definitely the most efficient way to update statistics on a table.
upvoted 0 times
...
Ashley
10 months ago
B) by running a query against the table
upvoted 0 times
...
Queenie
10 months ago
I always use option A to update statistics on a table.
upvoted 0 times
...
Marci
10 months ago
A) by running UPDATE STATISTICS
upvoted 0 times
...
Naomi
11 months ago
I always use UPDATE STATISTICS to make sure my table statistics are up to date.
upvoted 0 times
...
Paris
11 months ago
I agree, running UPDATE STATISTICS is the best way to update table statistics.
upvoted 0 times
...
...

Save Cancel