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.

What is a level of granularity of a fact table?

0 Answers  

---

Hash collision?

3 Answers   Satyam,

---

what is meant by Hot amp?

2 Answers   IBM, Satyam,

---

What is meant by MATCHTAG in multiload utility?

2 Answers   Satyam,

---

write lock is compatiable with which type of lock?

6 Answers   Infosys,

---

What is dimensional modeling?

0 Answers  

---

which utitility can use for loading the data from non-teradata to teradata ?

5 Answers   Wipro,

---

i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me

8 Answers   Satyam,

---

What are the various indexes in teradata?

0 Answers  

---

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

1 Answers   IBM,

---

What is bteq script in teradata?

0 Answers  

---

What are default access rights in teradata?

0 Answers  

---