Interested to Buy Any Domain ? << Click Here >> for more details...
what are the roles and responsibilities of teradata DBA ?
- 1 Answers
- 28222 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 basic teradata query language?
how to delete duplicate records in multi set table without using any tables
2 Answers Accenture, Nest, South Nests Software Solution, Spiro Solutions,
can we load 10 millions of records into target table by using tpump?
Explain the types of join supports by teradata?
How many codd's rules are satisfied by teradata database?
List the logical and conditional operators that are used with teradata along with their meanings?
Describe primary index in teradata. And what are the available primary index types?
In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?
Highlight the need for Performance Tuning.
Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are wrong format it is going to error table but i don't want load error table if any wrong format in Date column Pass "NULL" how can we do it fast load
Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?
What is use of compress in terdata?Explain?
Teradata 
