Teradata Administration Flashcards

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

Answer: CREATE USER

CREATE USER is the standard DDL statement in Teradata used to define a new user account with attributes such as password, permanent space, and spool space.

What does PERM space represent in Teradata?

Answer: Permanent disk space allocated for storing tables and data

PERM (permanent) space is the maximum disk space allocated to a user or database for permanently storing tables, views, and other objects.

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

Answer: DBC.DiskSpace

DBC.DiskSpace is the system view that reports current permanent, spool, and temporary space usage for every database and user in the system.

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

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

Exceeding SPOOL space causes the query to abort immediately with an error, as Teradata cannot store intermediate query results beyond the allocated limit.

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

Answer: DBC

The DBC (Database Computer) system database contains all data dictionary tables and views that store metadata about users, databases, tables, access rights, and system configuration.

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

Answer: ALTER USER

ALTER USER is the correct DDL statement to modify attributes of an existing Teradata user, consistent with standard SQL ALTER syntax for schema objects.

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

Answer: Objects are deleted along with the user

Dropping a Teradata user also drops all objects owned by that user, so the DROP USER statement will fail if the user owns any objects unless those objects are first dropped or transferred.