exam questions

Exam 1z0-071 All Questions

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

Exam 1z0-071 topic 1 question 110 discussion

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

Which two are true about creating tables in an Oracle database? (Choose two.)

  • A. Creating an external table will automatically create a file using the specified directory and file name.
  • B. A system privilege is required.
  • C. The same table name can be used for tables in different schemas.
  • D. A primary key constraint is mandatory.
  • E. A CREATE TABLE statement can specify the maximum number of rows the table will contain.
Show Suggested Answer Hide Answer
Suggested Answer: BC 🗳️

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
Thameur01
4 days, 10 hours ago
Selected Answer: BC
BC is correct
upvoted 1 times
...
hmatinnn
5 months, 1 week ago
Selected Answer: BC
Should be BC
upvoted 1 times
...
yanoolthecool
7 months ago
Selected Answer: BC
BC cuz google says: 'System privileges allow a user to perform a particular database operation or class of database operations. For example, to create a table, the user needs the create table privilege.' 'Objects have privileges associated with them, such as insert, update and delete a table.'
upvoted 1 times
...
zangado
7 months, 4 weeks ago
Selected Answer: BC
To create a relational table in your own schema, you must have the CREATE TABLE system privilege. To create a table in another user's schema, you must have the CREATE ANY TABLE system privilege. A) is wrong because external table creates a file only if it's created with 'CREATE AS SELECT' statement
upvoted 3 times
...
lucemqy
8 months, 2 weeks ago
Selected Answer: AC
Should be AC since CREATE TABLE does not require system privilege just object privilege. CREATE ANY TABLE require system privilege
upvoted 1 times
yanoolthecool
7 months ago
'System privileges allow a user to perform a particular database operation or class of database operations. For example, to create a table, the user needs the create table privilege.' 'Objects have privileges associated with them, such as insert, update and delete a table.'
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