exam questions

Exam 1z0-082 All Questions

View all questions & answers for the 1z0-082 exam

Exam 1z0-082 topic 1 question 131 discussion

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

Which two statements are true regarding indexes? (Choose two.)

  • A. A non-unique index can be altered to be unique.
  • B. An update to a table can result in no updates to any of the table's indexes.
  • C. The RECYCLE BIN never contains indexes.
  • D. An update to a table can result in updates to any or all of the table's indexes.
  • E. A table belonging to one user cannot have an index that belongs to a different user.
Show Suggested Answer Hide Answer
Suggested Answer: BD 🗳️

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
Rafafm
2 months, 4 weeks ago
B- you do an update on a single column that has no index. C- What Is the Recycle Bin? The recycle bin is actually a data dictionary table containing information about dropped objects. Dropped tables and any associated objects such as indexes, constraints, nested tables, and the likes are not removed and still occupy space. They continue to count against user space quotas, until specifically purged from the recycle bin or the unlikely situation where they must be purged by the database because of tablespace space constraints.
upvoted 1 times
...
musafir
1 year, 5 months ago
Selected Answer: BD
B and D are correct https://www.examtopics.com/discussions/oracle/view/20178-exam-1z0-071-topic-2-question-42-discussion/
upvoted 2 times
...
auwia
1 year, 6 months ago
Selected Answer: BD
Provided answer are corrects.
upvoted 3 times
...
j_tw
1 year, 8 months ago
Maybe BE?
upvoted 2 times
...
ahmadkrishan
1 year, 10 months ago
sry A + D correct
upvoted 1 times
...
ahmadkrishan
1 year, 10 months ago
E is true
upvoted 1 times
shotcom
1 year, 3 months ago
To create an index in another schema, all of the following conditions must be true: You have CREATE ANY INDEX system privilege. The owner of the other schema has a quota for the tablespaces to contain the index or index partitions, or UNLIMITED TABLESPACE system privilege. so E is not correct
upvoted 1 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago