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

Explain the concept of the DUAL table.

3 Answers  

---

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

---

what are the types of connection load-balancing?

0 Answers   Oracle,

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  

---

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

---

What command would you use to create a backup control file?

2 Answers  

---

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

---

How to determine the service pack currently installed on SQL Server?

1 Answers  

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

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

0 Answers  

---