Oracle Exam 1Z0-902 Topic 3 Question 50 Discussion

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

Question #: 50
Topic #: 3

You want to examine how much Smart Scan activity is occurring.

Which two would provide the information you require?

Athe number of full table scans that accessed the table

Bthe number of Smart Scans performed for the table on all the storage servers, as shown when performing a list activerequest command using CELLCLI on all the cells

Cthe number of serial queries that accessed the table

Dthe number of parallel queries that accessed the table

Ethe number of Smart Scans performed for the table on all the storage servers, as shown when performing a list ACTIVEREQUEST command using EXACLI on all the cells

Show Suggested Answer

Suggested Answer: A, B, F

To drop all celldisks on all the storage servers in an X9M-2 quarter rack, you should use the CELLADMIN account, which has the necessary privileges to perform this task. You can use the CELLCLI command-line interface to drop the celldisks. The best way to do this is by calling CELLCLI on all cells using DCLI (Oracle Database Command Line Interface) which allows you to run commands on multiple servers at once. Alternatively, you can use an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli. It is not recommended to use the CELLMONITOR account, as it has a more limited set of privileges. It is also important to note that EXACLI is not a valid tool for this task

https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.html

by Elza at Sep 14, 2024, 01:30 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Marla

28 days ago

Wait, I thought this was a question about smart phones, not Smart Scans! Oh well, I guess B and E are the way to go. At least that's what all the other candidates seem to think.

upvoted 0 times

Pamella

3 days ago

I agree, B and E would provide the information we need.

upvoted 0 times

...

Mattie

29 days ago

Hmm, I think B and E are the correct answers here. The question is specifically asking about Smart Scan activity, and those two options are the only ones that mention that. Although I do have to admit, the wording on some of these other options is pretty confusing.

upvoted 0 times

...

Elenora

1 months ago

Haha, this question is a real brain-teaser! I'm going to go with B and E, since they seem to be the only ones actually talking about Smart Scans. A and D are just talking about regular table scans and queries, which isn't quite what the question is asking for.

upvoted 0 times

...

Rosendo

1 months ago

I'm not sure about this one. I was thinking A and D might be the right answers, since they mention full table scans and parallel queries, which could be related to Smart Scan activity. But I guess B and E are the better choices.

upvoted 0 times

Johnetta

4 days ago

I think B and E are the correct options to get the information on Smart Scan activity.

upvoted 0 times

...

Florinda

6 days ago

E) the number of Smart Scans performed for the table on all the storage servers, as shown when performing a list ACTIVEREQUEST command using EXACLI on all the cells

upvoted 0 times

...

Rose

8 days ago

I think B is the correct choice because it specifically mentions Smart Scans on storage servers.

upvoted 0 times

...

Shayne

10 days ago

B) the number of Smart Scans performed for the table on all the storage servers, as shown when performing a list activerequest command using CELLCLI on all the cells

upvoted 0 times

...

Julianna

11 days ago

A) the number of full table scans that accessed the table

upvoted 0 times

...

Laila

14 days ago

B) the number of Smart Scans performed for the table on all the storage servers, as shown when performing a list activerequest command using CELLCLI on all the cells

upvoted 0 times

...

Shenika

19 days ago

A) the number of full table scans that accessed the table

upvoted 0 times

...

Chanel

2 months ago

I think the correct answers are B and E. The question is specifically asking about Smart Scan activity, and B and E both mention information about Smart Scans performed on the storage servers.

upvoted 0 times