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 |
What is the command in bteq to check for session settings ?
Which Teradata concept allows more than one model generation?
Describe the between keyword in teradata?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What is difference between user and database in teradata?
What are the various indexes in teradata? Why are they preferred?
What does sleep function does in fast load?
Discuss the advantages of using partitioned primary index in a query?
If RDBMS is halted what will you do ?
Explain vproc in teradata?
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
How do you design aggregate tables using teradata?