Answer Posted / n

Ps -ef

how can you find out if a table can be redefined?

1057

---

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

1181

---

what is a user-defined lock?

1137

---

what are the types of connection load-balancing?

1043

---

How would you go about verifying the network name that the local_listener is currently using?

3270

---

Why would you use sql agent? : sql server DBA

1130

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2552

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2085

---

Which autogrowth database setting is good? : sql server DBA

1237

---

What is transparent data encryption? : sql server DBA

1251

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2342

---

What are statistics, under what circumstances they go out of date, how do you update them?

2308

---

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1805

---

. 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?

2490

---

What are the commands used in dcl? : sql server DBA

1129

---