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

Exam 1z0-082 All Questions

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

Exam 1z0-082 topic 1 question 80 discussion

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

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)

  • A. The sales user must have a quota on the TEMP tablespace
  • B. The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema
  • C. The sales user must have been granted the CREATE SESSION privilege
  • D. The sales user must have their quota on the users tablespace removed
  • E. The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema
  • F. The sales user must have been granted the CREATE TABLE privilege
Show Suggested Answer Hide Answer
Suggested Answer: BDF 🗳️
by Rivaldo11 at July 12, 2020, 8:36 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
Rivaldo11
Highly Voted 2 years, 11 months ago
B, C and F
upvoted 25 times
NowOrNever
2 years, 10 months ago
BDF https://blogs.oracle.com/sql/how-to-create-users-grant-them-privileges-and-remove-them-in-oracle-database https://docs.oracle.com/database/121/DBSEG/users.htm#DBSEG002 You can assign each user a tablespace quota for any tablespace, except a temporary tablespace.
upvoted 1 times
adoptc94
2 years, 9 months ago
Why would D be right? The database checks the users quota in the tablespace that he wants to create the object in. Having quota in another tablespace isn't any issue so why would you need to remove the quota from tablespace users to be able to create objects in tablespace sales_q1? The right answers are: B -> The user need quota in the tablespace he wants to create the object (sales_q1) C -> User needs to be able to create a session (login in) to the database to create objects in the first place F -> User needs to have the right privilege to create the object (in this case a table) D is complete nonsense given the question and won't help in any way to create objects in sales_q1 tablespace
upvoted 4 times
NowOrNever
2 years, 8 months ago
Sorry BCF of course
upvoted 2 times
...
...
...
...
RaNik69
Most Recent 2 weeks, 6 days ago
Selected Answer: BCF
BCF are correct
upvoted 1 times
...
Rcravi
1 year, 2 months ago
Correct - CEF A - you cant assign quota on TEMP tablespace B - you do not need any quota for creating table in any tablespace D - is wrong as you are not creating table in users, so this is not concerning to the question Correct - C,F - these are the basic privileges required. E - For holding the data, quota is required.
upvoted 1 times
Rcravi
1 year, 2 months ago
Update/correction E - is correct when asked for inserting the data. So E is wrong for this question B- is correct when deferred_segment_creation is set to FALSE, you need quota on sales_Q1 tablespace. correct answers are B C and F.
upvoted 3 times
...
...
Ekos
2 years, 6 months ago
C,E,F is the correct answer. b is wrong. we dont need any initial extents when we create table. the segments are needed when we start insert the data.
upvoted 2 times
SimoneF
2 years, 5 months ago
Read the question again: it clearly states "Segment creation is not deferred." exactly to prevent this objection. And E is false anyway, cause the question also asks for the requirements for the creation of the tables, not for their population.
upvoted 1 times
...
SimoneF
2 years, 5 months ago
Sorry one more thing: E is also false cause SALES_Q1 is not the only tablespace where sales has quota, so we don't know if all the tables in that schema will reside there or on USERS. So, SALES_Q1 doesn't necessarily have to be as big as all the data that the schema will have.
upvoted 1 times
...
...
Mandar79
2 years, 9 months ago
BCF is correct https://docs.oracle.com/database/121/DBSEG/users.htm#DBSEG99778 When you create a new user account, you should enable this user to access the database
upvoted 3 times
...
Chansi
2 years, 10 months ago
Isn't it CEF ? What if the user is executing Create as Select so just B won't work rt ?
upvoted 2 times
SimoneF
2 years, 5 months ago
There are two problems with E: first and most notably, user sales can (and not randomly, does) have quota on other tablespaces, so not all of his tables have to reside on SALES_Q1. Second, the question asks what's necessary for the user to be able to create tables. To create a select, meaning creating and filling them, is not a necessary requirement. Even if the space wouldn't be necessary to insert all the data, to be enough for hosting the initial extents would satisfy the minimum requirement, which is to create the tables (hence, the structure) to begin with.
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago