Answer Posted / binod

Noway, it can't be possibleto take ONLINE backup if the
database is running in an noarchievelog mode..

FOR altering the database into archieve log mode the
following steps should be consider-
1.shutdown your database
2.reopen the database but this time with the "mount" option
which will mount the instance but not open it.
3.Now your database can be back up

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

7753

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2614

---

how can a session indicate its interest in receiving alerts?

979

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2640

---

what are the performance views in an oracle rac environment?

1000

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

949

---

What is transparent data encryption? : sql server DBA

1114

---

What are the different ways you can create databases in sql server? : sql server DBA

1076

---

What are the different types of indexes available in sql server? : sql server DBA

1108

---

how can you record information about current session?

976

---

Where do you find the default index fill factor and how to change it? : sql server DBA

1021

---

what functionality does oracle provide to secure sensitive information?

941

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1944

---

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

1702

---

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

994

---