what are the roles and responsibilities of teradata DBA ?



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

Post New Answer

More Teradata Interview Questions

What is the command in bteq to check for session settings ?

0 Answers  


Which Teradata concept allows more than one model generation?

1 Answers   TCS,


Describe the between keyword in teradata?

0 Answers  


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

0 Answers  


What is difference between user and database in teradata?

0 Answers  






What are the various indexes in teradata? Why are they preferred?

0 Answers  


What does sleep function does in fast load?

0 Answers  


Discuss the advantages of using partitioned primary index in a query?

0 Answers  


If RDBMS is halted what will you do ?

0 Answers   Teradata,


Explain vproc in teradata?

0 Answers  


hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. yedu my email-id: jakkayedukondalu@gmail.com@gmail.com

0 Answers  


How do you design aggregate tables using teradata?

1 Answers  


Categories