exam questions

Exam 1z0-062 All Questions

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

Exam 1z0-062 topic 1 question 193 discussion

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

In your Oracle 12c database, you plan to execute the command:
SQL> CREATE TABLESPACE tbs1 DATAFILE /u02/oracle/data/tbs01.dbf SIZE 50M;
The u02 file system has 1 GB of free space available.
What is the outcome?

  • A. It creates a locally managed tablespace with manual segment space management enabled.
  • B. It raises an error because extent management is not specified.
  • C. It creates a locally managed tablespace with automatic segment space management enabled.
  • D. It creates a dictionary-managed tablespace with manual segment space management enabled.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
References:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces002.htm#ADMIN11359

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
Currently there are no comments in this discussion, be the first to comment!
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