Teradata Teradata Administration 1 — Questions and Answers
Question 1: Which SQL statement is used to create a new user in Teradata?
- CREATE USER (Correct answer)
- ADD USER
- INSERT USER
- MAKE USER
Correct 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.
Question 2: What does PERM space represent in Teradata?
- Temporary space used during query execution
- Permanent disk space allocated for storing tables and data (Correct answer)
- Space reserved for transaction journals
- Space used by the FastLoad utility
Correct 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.
Question 3: Which Teradata system view provides current space usage information for all databases and users?
- DBC.Tables
- DBC.Databases
- DBC.DiskSpace (Correct answer)
- DBC.SessionInfo
Correct 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.
Question 4: What happens when a Teradata user exceeds their allocated SPOOL space during a query?
- The query pauses and waits for space to free up
- The query fails with a 'no more spool space' error (Correct answer)
- The system automatically increases spool space
- The query results are written to the journal instead
Correct 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.
Question 5: Which Teradata system database stores all system catalog objects, including user definitions and access rights?
- SYSADMIN
- DBC (Correct answer)
- SYSTEMFE
- TDWM
Correct 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.
Question 6: Which command is used to change attributes of an existing Teradata user, such as their password or space allocation?
- ALTER USER (Correct answer)
- MODIFY USER
- UPDATE USER
- CHANGE USER
Correct 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.
Question 7: When a Teradata database object owner is dropped, what happens to the objects owned by that user?
- Objects are automatically transferred to DBC
- Objects are deleted along with the user (Correct answer)
- Objects remain but become inaccessible
- Objects are archived to spool space
Correct 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.
Teradata Teradata Administration 1
Which SQL statement is used to create a new user in Teradata?