Exam 1z0-082 All Questions

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

Exam 1z0-082 topic 1 question 80 discussion

Actual exam question from Oracle's 1z0-082

Question #: 80
Topic #: 1

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

Suggested Answer: BDF 🗳️

by Rivaldo11 at July 12, 2020, 8:36 p.m.

Comments

Submit Cancel

Rivaldo11

Highly Voted 3 years, 5 months ago

B, C and F

upvoted 25 times

NowOrNever

3 years, 5 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

3 years, 4 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

3 years, 3 months ago

Sorry BCF of course

upvoted 2 times

...

RaNik69

Most Recent 7 months, 1 week ago

Selected Answer: BCF

BCF are correct

upvoted 1 times

...

Rcravi

1 year, 9 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, 9 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

3 years 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, 12 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, 12 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

3 years, 3 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

3 years, 4 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, 12 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

...