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 fill factor? : sql server DBA

739

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2096

---

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

652

---

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

636

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

1827

---

---

what are the differences of where and if in SAS?

1753

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

787

---

what is the diffrence between core dba and apps dba?

2195

---

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

666

---

suppose you want to audit specific activities on sensitive data. How can you achieve that?

633

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

673

---

What is dcl? : sql server DBA

751

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1604

---

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

767

---

Why does Oracle not permit the use of PCTUSED with indexes?

2443

---