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

Exam 1z0-052 All Questions

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

Exam 1z0-052 topic 3 question 137 discussion

Actual exam question from Oracle's 1z0-052
Question #: 137
Topic #: 3
[All 1z0-052 Questions]

In a database, EXAMPLE is the default tablespace and DEFERRED_SEGMENT_CREATION is FALSE.
Examine these commands executed by SYS:

What will be the outcome and why?

  • A. U1.TAB1 will be created
  • B. It will fail because U1 has no quota on EXAMPLE
  • C. It will fail because U1 has no default tablespace
  • D. It will fail because U1 does not have the CREATE TABLE privilege
  • E. It will fail because U1 does not have the CREATE SESSION privilege
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
Reference: http://www.dba-oracle.com/t_oracle_deferred_segment_creation.htm
by giovi411 at June 21, 2019, 2:47 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
Goe
5 years, 11 months ago
correct answer is B.
upvoted 1 times
...
giovi411
6 years, 1 month ago
It will fail because U1 has no quota on EXAMPLE
upvoted 2 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