Answer Posted / ramesh

From Scott Schema

1.Desc Dept

2.Select Table_name,Column_name,Data_type,nullable from
user_tab_columns wheRE table_name = 'DEPT'

what functionality does oracle provide to secure sensitive information?

995

---

Query processing is slow(eg select query)how will u solve that

7915

---

What is dbcc? : sql server DBA

1292

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2203

---

How do you open a cluster administrator? : sql server DBA

1104

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1026

---

what do you understand by flashback feature of oracle?

995

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2443

---

what is the use of ocr?

1033

---

What is the default fill factor value? : sql server DBA

1130

---

how can you initialize log miner?

1147

---

What is dcl? : sql server DBA

1271

---

What types of replication are supported in sql server? : sql server DBA

1298

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3761

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1079

---