ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-063 All Questions

View all questions & answers for the 1z0-063 exam
Go to Exam

Exam 1z0-063 topic 1 question 155 discussion

Actual exam question from Oracle's 1z0-063
Question #: 155
Topic #: 1
[All 1z0-063 Questions]

In a database supporting an OLTP workload, tables are frequently updated on both key and non-keycolumns.
Reports are also generated by joining multiple tables.
Which table organization or type would provide the best performance for this hybrid workload?

  • A. heap table with a primary key index
  • B. external table
  • C. hash clustered table
  • D. global temporary table
  • E. index clustered table
Show Suggested Answer Hide Answer
Suggested Answer: E 🗳️
by ErikJanssen at March 15, 2021, 8:45 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
donni
2 years, 10 months ago
I agree, it should be A
upvoted 1 times
...
ErikJanssen
4 years, 2 months ago
I would choose answer A because clustered tables are not recommended for oltp.
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel