Answer Posted / 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;

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1039

---

when does an alert gets signaled?

980

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

937

---

how can you schedule a job in database?

1043

---

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

4383

---

What are the different types of indexes available in sql server? : sql server DBA

1109

---

What would you do with an "in-doubt" distributed transaction?

1831

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

1013

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1187

---

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

2374

---

What is the default port no on which sql server listens? : sql server DBA

1083

---

What are the different ways you can create databases in sql server? : sql server DBA

1076

---

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

1105

---

what functionality does oracle provide to secure sensitive information?

941

---

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

1223

---