Answer / naresh

CREATE DATABASE DB1
LOGFILE
GROUP 1 '/oracle/oradata/db1/redo1a.log' size 5m,
GROUP 2 '/oracle/oradata/db2/redo2a.log' size 5m
TABLESPACE USERS datafile '/oracle/oradata/db1/system.dbf'
size 100m
AUTOEXTEND ON,
DEFAULT TEMPORARY TABLESPACE
tempfile '/oracle/oradata/db1/temp.dbf' size 10m AUTOEXTEND
ON,
TABLESPACE UNDO datafile '/oracle/oradata/db1/undo.dbf'
size 10m
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET US16UTF16;

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

Hot backup procedure?

2 Answers  

---

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

---

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

---

How can you gather statistics on a table?

3 Answers  

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

1 Answers   IBM,

---

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

0 Answers  

---

how can you enable flashback feature?

1 Answers   Oracle,

---

How do you open a cluster administrator? : sql server DBA

1 Answers  

---

Explain CREATE DATABASE syntax?

2 Answers  

---

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

---

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---