Answer Posted / rohit bhosale

Create Database [database_name] On Primary

(

Name='abc', Filename='path_of_mdf_file'

)

log on

(
Name='abc_log', Filename='path_of_ldf_file'

)



Eg:


Create database emp on primary

(
name='emp1', filename='d:\sql\emp.mdf'
)
log on

(
name='emp1_log', filename='d:\sql\emp_log.ldf'
)

how to restore files with rman?

2355

---

Which autogrowth database setting is good? : sql server DBA

1228

---

What are the operating modes in which database mirroring runs? : sql server DBA

1227

---

What are the steps you will take to improve performance of a poor performing query?

2896

---

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

2517

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2022

---

Why would you call update statistics? : sql server DBA

1032

---

how can you get actual data change values from previous transactions in oracle?

1137

---

what are the performance views in an oracle rac environment?

1116

---

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.

2215

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2572

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2491

---

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 the different topologies in which replication can be configured? : sql server DBA

1311

---

What is a system database and what is a user database? : sql server DBA

1306

---