Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

IBM C1000-085 Exam - 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

Delisa

6 months ago

Restarting the database? That sounds off...

upvoted 0 times

...

Ryann

6 months ago

B is not correct, just FYI.

upvoted 0 times

...

Sarah

7 months ago

Wait, is GENERATE STATISTICS even a thing?

upvoted 0 times

...

Janet

7 months ago

Definitely A, that's the standard way!

upvoted 0 times

...

Abel

7 months ago

You can update stats by running UPDATE STATISTICS.

upvoted 0 times

...

Jerry

7 months ago

Restarting the database definitely doesn't sound right for updating statistics; I think that's just for other maintenance tasks.

upvoted 0 times

...

Regenia

7 months ago

I feel like GENERATE STATISTICS sounds familiar, but I don't think that's the right command for updating stats.

upvoted 0 times

...

Rose

8 months ago

I remember a practice question where we had to choose between UPDATE STATISTICS and something else, but I can't recall what the other option was.

upvoted 0 times

...

Danica

8 months ago

I think we talked about using UPDATE STATISTICS in class, but I'm not completely sure if that's the only way.

upvoted 0 times

...

Lashandra

8 months ago

I'm a bit confused on this one. I know we need to update statistics, but I'm not sure if that's done through a query, a command, or something else. I'll have to review my notes to be sure.

upvoted 0 times

...

Brittni

8 months ago

Okay, let me walk through this step-by-step. I believe the correct answer is A - running UPDATE STATISTICS. That's the SQL command specifically designed for updating table statistics, so that makes the most sense to me.

upvoted 0 times

...

Willow

8 months ago

Hmm, I'm not sure about this one. I know we can update statistics, but I'm not familiar with the exact syntax. I'll have to think this through carefully.

upvoted 0 times

...

Cherry

8 months ago

I think the answer is A - running UPDATE STATISTICS. That sounds like the most direct way to update the statistics on a table.

upvoted 0 times

...

Caren

2 years 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 years ago

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

upvoted 0 times

...

Hermila

2 years ago

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

upvoted 0 times

...

Tamar

2 years 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

2 years 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

2 years ago

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

upvoted 0 times

...

Carmelina

2 years 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

2 years 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 years ago

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

upvoted 0 times

...

Ashley

2 years ago

B) by running a query against the table

upvoted 0 times

...

Queenie

2 years ago

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

upvoted 0 times

...

Marci

2 years ago

A) by running UPDATE STATISTICS

upvoted 0 times

...

Naomi

2 years ago

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

upvoted 0 times

...

Paris

2 years ago

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

upvoted 0 times

...

...