nerdexam
Oracle

1Z0-062 · Question #271

In your database, USERS is the default permanent tablespace. Examine the commands and their outcome: You plan to execute the commands: Which two statements are true?

The correct answer is B. The MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table E. The MYTAB table is owned by the SYS user. When the SYS user (connected as SYSDBA) creates a table without specifying a tablespace, it is created in the SYS schema's default tablespace, which is SYSTEM, and can be fully utilized.

Managing Schema Objects

Question

In your database, USERS is the default permanent tablespace. Examine the commands and their outcome:

You plan to execute the commands:

Which two statements are true?

Options

  • AThe MYTAB table is created in the SYSTEM tablespace but no rows can be inserted into the
  • BThe MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table
  • CTheMYTAB table is created in the USERS tablespace but no rows can be inserted into the table
  • DThe CREATE TABLE statement generates an error because the SYSDBA privilege does not
  • EThe MYTAB table is owned by the SYS user.

How the community answered

(22 responses)
  • A
    5% (1)
  • B
    77% (17)
  • C
    5% (1)
  • D
    14% (3)

Why each option

When the SYS user (connected as SYSDBA) creates a table without specifying a tablespace, it is created in the SYS schema's default tablespace, which is SYSTEM, and can be fully utilized.

AThe MYTAB table is created in the SYSTEM tablespace but no rows can be inserted into the

It is incorrect that no rows can be inserted; the SYS user has all necessary privileges to insert data into tables they own.

BThe MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the tableCorrect

When a user connected as SYSDBA creates a table without specifying a tablespace, it defaults to the creator's default tablespace. For the SYS user, this is the SYSTEM tablespace. The SYS user has full privileges, including the ability to insert rows.

CTheMYTAB table is created in the USERS tablespace but no rows can be inserted into the table

The table is created in the SYSTEM tablespace, not USERS, because SYSTEM is the default permanent tablespace for the SYS schema, overriding the database's default of USERS for other users.

DThe CREATE TABLE statement generates an error because the SYSDBA privilege does not

The SYSDBA privilege grants comprehensive administrative capabilities, including the right to create tables, so the CREATE TABLE statement would not generate a privilege error.

EThe MYTAB table is owned by the SYS user.Correct

The table is created by the SYS user (through the SYSDBA connection), therefore the SYS user is the owner of the MYTAB table.

Concept tested: SYSDBA privileges, SYS schema default tablespace

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/admin-privileges.html#GUID-B452D3F5-F193-4BCE-A17D-BB4570DAB325

Topics

#Default tablespace#SYS user#CREATE TABLE#SYSTEM tablespace

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-062 Practice