Answer Posted / sanju

shut the database then do fllowing
1)In Parameter file set logfile destination
2)startup mount
3)alter database archivelog
4)alter database open
5)archive lo list;

How can you control the amount of free space in your index pages? : sql server DBA

1382

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1160

---

What is the importance of a recovery model? : sql server DBA

1083

---

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

2350

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

1036

---

Can you redefine a table online?

1156

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2220

---

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

8046

---

What the different topologies in which replication can be configured? : sql server DBA

1319

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2524

---

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

2089

---

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

1060

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1092

---

what are the types of connection load-balancing?

1046

---

What is transparent data encryption? : sql server DBA

1251

---