what are the roles and responsibilities of teradata DBA ?
- 1 Answers
- 27115 Views
- TCS, I also Faced
- E-Mail Answers
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 difference between bpo and call centre?
Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M
How to copy teradata scripts from ur remote desktop to server machine?
In the Primary Index, what is the score of AMPs that are actively involved?
What is partitioned primary index (ppi)?
How do you load Multiple files to a table by using fastload scripts?
What are the newly developed features of Teradata?
On which column will you take primary index???
How can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale
Can you connect multiload from ab initio?
Can we Suggest as how is the process to get a job in teradata in current market??Is it easier???
Write a program to show the parser component used in teradata?
Teradata 
