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 is the diffrence between core dba and apps dba?

2087

---

What is the difference between clustered and non-clustered index? : sql server DBA

545

---

What the different topologies in which replication can be configured? : sql server DBA

656

---

internal architecture

1755

---

how can you get actual data change values from previous transactions in oracle?

609

---

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

596

---

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

1977

---

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

576

---

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

1832

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1586

---

how can a session indicate its interest in receiving alerts?

563

---

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

514

---

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

575

---

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

579

---

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

546

---