Teradata Teradata Administration

Question 1

Which SQL statement is used to create a new user in Teradata?

Accepted Answer

CREATE USER

Answer

ADD USER

Answer

INSERT USER

Answer

MAKE USER

Question 2

What does PERM space represent in Teradata?

Accepted Answer

Permanent disk space allocated for storing tables and data

Answer

Temporary space used during query execution

Answer

Space reserved for transaction journals

Answer

Space used by the FastLoad utility

Question 3

Which Teradata system view provides current space usage information for all databases and users?

Accepted Answer

DBC.DiskSpace

Answer

DBC.Tables

Answer

DBC.Databases

Answer

DBC.SessionInfo

Question 4

What happens when a Teradata user exceeds their allocated SPOOL space during a query?

Accepted Answer

The query fails with a 'no more spool space' error

Answer

The query pauses and waits for space to free up

Answer

The system automatically increases spool space

Answer

The query results are written to the journal instead

Question 5

Which Teradata system database stores all system catalog objects, including user definitions and access rights?

Accepted Answer

DBC

Answer

SYSADMIN

Answer

SYSTEMFE

Answer

TDWM

Question 6

Which command is used to change attributes of an existing Teradata user, such as their password or space allocation?

Accepted Answer

ALTER USER

Answer

MODIFY USER

Answer

UPDATE USER

Answer

CHANGE USER

Question 7

When a Teradata database object owner is dropped, what happens to the objects owned by that user?

Accepted Answer

Objects are deleted along with the user

Answer

Objects are automatically transferred to DBC

Answer

Objects remain but become inaccessible

Answer

Objects are archived to spool space