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

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

---

what is the use of home directory???

1 Answers   HP,

---

what is a crs resource?

0 Answers   Oracle,

---

What types of replication are supported in sql server? : sql server DBA

0 Answers  

---

---

which background process will run @ the time of creation of catalog database

1 Answers   CSC,

---

what is incremental checkpoint?

1 Answers   CTS,

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers  

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  

---

deleted of control file how will u recover control file?

4 Answers   CTS,

---

How do you add a data file to a tablespace?

3 Answers  

---