Oracle 1Z0-071 Exam - Topic 4 Question 117 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 117
Topic #: 4

[All 1Z0-071 Questions]

Which three are true about the CREATE TABLE command?

AIt can include the CREATE...INDEX statement for creating an index to enforce the primary key constraint.

BThe owner of the table should have space quota available on the tablespace where the table is defined.

CIt implicitly executes a commit.

DIt implicitly rolls back any pending transactions.

EA user must have the CREATE ANY TABLE privilege to create tables.

FThe owner of the table must have the UNLIMITED TABLESPACE system privilege.

Show Suggested Answer

Suggested Answer: B, C, E

A . False - The CREATE TABLE command cannot include a CREATE INDEX statement within it. Indexes to enforce constraints like primary keys are generally created automatically when the constraint is defined, or they must be created separately using the CREATE INDEX command.

B . True - The owner of the table needs to have enough space quota on the tablespace where the table is going to be created, unless they have the UNLIMITED TABLESPACE privilege. This ensures that the database can allocate the necessary space for the table. Reference: Oracle Database SQL Language Reference, 12c Release 1 (12.1).

C . True - The CREATE TABLE command implicitly commits the current transaction before it executes. This behavior ensures that table creation does not interfere with transactional consistency. Reference: Oracle Database SQL Language Reference, 12c Release 1 (12.1).

D . False - It does not implicitly roll back any pending transactions; rather, it commits them.

E . True - A user must have the CREATE ANY TABLE privilege to create tables in any schema other than their own. To create tables in their own schema, they need the CREATE TABLE privilege. Reference: Oracle Database Security Guide, 12c Release 1 (12.1).

F . False - While the UNLIMITED TABLESPACE privilege allows storing data without quota restrictions on any tablespace, it is not a mandatory requirement for a table owner. Owners can create tables as long as they have sufficient quotas on the specific tablespaces.

by Paris at Jun 10, 2025, 08:04 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-071 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Cory

3 months ago

F is a bit misleading, not every owner needs UNLIMITED TABLESPACE.

upvoted 0 times

...

Thad

3 months ago

Wait, does it really roll back pending transactions? That sounds weird.

upvoted 0 times

...

Casey

3 months ago

B is definitely true, space quota is a must!

upvoted 0 times

...

Felicitas

3 months ago

E is correct, you need that privilege for sure.

upvoted 0 times

...

Janet

4 months ago

I thought CREATE TABLE would auto-commit, but C seems off.

upvoted 0 times

...

Frank

4 months ago

I vaguely remember that option D might be true, but I can't remember if it rolls back pending transactions or not. It’s a bit confusing!

upvoted 0 times

...

Daniela

4 months ago

I feel like I've seen a question similar to this before, and I think option E is correct. You usually need specific privileges to create tables.

upvoted 0 times

...

Tracey

4 months ago

I'm not so sure about option C. I remember something about commits, but I can't recall if CREATE TABLE does that automatically.

upvoted 0 times

...

Serina

5 months ago

I think option B is definitely true because the owner needs space in the tablespace to create a table.

upvoted 0 times

...

Moon

5 months ago

Alright, time to put my SQL knowledge to the test. I'll read through the options, eliminate the ones that are clearly false, and then select the three that are true about the CREATE TABLE command.

upvoted 0 times

...

Moon

5 months ago

I'm a bit confused by some of these options. I'll need to think through each one carefully to determine which ones are accurate statements. Hopefully, I can narrow it down to the correct three.

upvoted 0 times

...

Val

5 months ago

I've got this! I'm pretty confident I know the CREATE TABLE command well. I'll quickly go through each option and select the three that are true.

upvoted 0 times

...

Cheryl

5 months ago

Okay, let's see. I know the CREATE TABLE command is used to create a new table, but I'm not sure about the specifics of the options here. I'll need to review my notes to make sure I understand the details.

upvoted 0 times

...

Vallie

5 months ago

Hmm, this looks like a tricky one. I'll need to carefully read through each option and think about which ones are true statements about the CREATE TABLE command.

upvoted 0 times

...

Tatum

9 months ago

Hmm, I'm a bit confused. Does the CREATE TABLE command also make me a sandwich? I'm asking for a friend. *winks*

upvoted 0 times

Yoko

7 months ago

E) A user must have the CREATE ANY TABLE privilege to create tables.

upvoted 0 times

...

Sanjuana

8 months ago

B) The owner of the table should have space quota available on the tablespace where the table is defined.

upvoted 0 times

...

Chan

8 months ago

A) It can include the CREATE...INDEX statement for creating an index to enforce the primary key constraint.

upvoted 0 times

...

Veronika

9 months ago

F is definitely true. The table owner needs the UNLIMITED TABLESPACE privilege to create tables. Who wouldn't know that? *chuckles*

upvoted 0 times

...

Merilyn

9 months ago

I agree with Kiley, A and F make sense.

upvoted 0 times

...

German

9 months ago

I'm pretty sure C and D are false. The CREATE TABLE command doesn't commit or roll back any transactions. That's just silly.

upvoted 0 times

Elouise

8 months ago

Yeah, you're right. C and D are definitely false. The CREATE TABLE command doesn't commit or roll back transactions.

upvoted 0 times

...

Marylin

8 months ago

F) The owner of the table must have the UNLIMITED TABLESPACE system privilege.

upvoted 0 times

...

Evangelina

8 months ago

E) A user must have the CREATE ANY TABLE privilege to create tables.

upvoted 0 times

...

Sheridan

8 months ago

B) The owner of the table should have space quota available on the tablespace where the table is defined.

upvoted 0 times

...

Allene

8 months ago

A) It can include the CREATE...INDEX statement for creating an index to enforce the primary key constraint.

upvoted 0 times

...

Kiley

9 months ago

I believe A and F are also true.

upvoted 0 times

...

Lenna

9 months ago

I think B and E are true.

upvoted 0 times

...

Carisa

9 months ago

A, B, and E seem to be the correct answers. The CREATE TABLE command can create an index for the primary key, the table owner needs space quota, and a user needs the CREATE ANY TABLE privilege to create tables.

upvoted 0 times