what are the roles and responsibilities of teradata DBA ?
Answer / prakash.k
Following are the different functions which a DBA can perform:
1. User Management – Creation and managing Users, Databases, Roles, Profiles and Accounts.
2. Space Allocation – Assigning Permanent Space, Spool Space and Temporary Space.
3. Access of Database Objects – Granting and Revoking Access Rights on different database objects.
4. Security Control – Handling logon and logoff rules for Users.
5. System Maintenance – Specification of system defaults, restart etc.
6. System Performance – Use of Performance Monitor(PMON), Priority Scheduler and Job Scheduling.
7. Resource Monitoring – Database Query Log(DBQL) and Access Logging.
8. Data Archives, Restores and Recovery – ARC Utility and Permanent Journals.
| Is This Answer Correct ? | 25 Yes | 1 No |
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Explain teradata utilities. What is multiload, fast load, tpump?
Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this regard. Thanks in advance.
What is the purpose of indexes?
What is a node in teradata? Explain
in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that
What is a clique?
What is stored procedure in teradata?
What do you mean by teradata sql assistant?
plz explain parlla distribution and subtable concept in teradata
Explain the term 'row' related to relational database management system?
Explain the advantages of partitioned primary index in a query?