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'
)

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2166

---

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

7911

---

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

1126

---

Why would you use sql agent? : sql server DBA

1081

---

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2107

---

. 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 difference between the 2 operating modes of database mirroring? : sql server DBA

993

---

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

1070

---

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

2295

---

internal architecture

2193

---

How to start SQL Server in minimal configuration mode?

7969

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2617

---

What is a correlated sub-query? : sql server DBA

1084

---

what do you understand by flashback feature of oracle?

993

---

What are the different sql server versions you have worked on? : sql server DBA

1011

---