Oracle Exam 1Z0-908 Topic 4 Question 74 Discussion

Actual exam question for Oracle's 1Z0-908 exam

Question #: 74
Topic #: 4

[All 1Z0-908 Questions]

Examine this query and its output:

Which two statements are true? (Choose two.)

AThe root user had the largest number of modified rows for a SELECT statement.

BUser bob had the largest total time waiting for locks.

CThe root user had the largest single wait time.

DThe app user had the highest total number of rows read from storage engines.

EUser bob had a significantly higher ratio of SELECT + INSERT statements to QUIT than both app and root users.

Show Suggested Answer

Suggested Answer: D, E

by Kenneth at Mar 16, 2024, 07:14 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-908 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Brice

1 years ago

I'm leaning towards statement E. User bob did have a significantly higher ratio of SELECT + INSERT statements to QUIT than both app and root users.

upvoted 0 times

...

Glenn

1 years ago

I believe statement D could be true because the app user had the highest total number of rows read from storage engines.

upvoted 0 times

...

Talia

1 years ago

I think statement C is also true. The root user had the largest single wait time.

upvoted 0 times

...

Valentin

1 years ago

I agree with statement B. User bob had the largest total time waiting for locks.

upvoted 0 times

...

Helene

1 years ago

I think statement A is true because the root user had the largest number of modified rows for a SELECT statement.

upvoted 0 times

...

Lamar

1 years ago

That's a valid point, Glennis. But what about option B? User Mattie had the largest total time waiting for locks.

upvoted 0 times

...

Glennis

1 years ago

I'm not sure about option E, but I think option D might be true because the app user had the highest total number of rows read from storage engines.

upvoted 0 times

...

Mattie

1 years ago

I agree with Lamar, but I also believe option E is true because User Mattie had a significantly higher ratio of SELECT + INSERT statements to QUIT.

upvoted 0 times

...

Lamar

1 years ago

I think option A is true because the root user had the largest number of modified rows for a SELECT statement.

upvoted 0 times

...