Answer Posted / md azhar alvi

At the time of database creation SYSTEM.DBF AND SYSAUX.DBF tablespaces are created.

SYSTEM.DBF contains the data dictionary views and objects which in owned by sysdba.

in oracle 11g if we are omitting the creation of sysaux.dbf tablespace oracle will automatically create the sysaux.dbf tablespace.

sysaux.dbf contain repository values of oracle tools.

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2520

---

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

1129

---

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1160

---

Where would you look for errors from the database engine?

2897

---

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

2249

---

What is the importance of a recovery model? : sql server DBA

1080

---

who owns the operating system files created by the utl_file package?

1125

---

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

1163

---

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

1036

---

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

1934

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2013

---

What the different types of replication and why are they used? : sql server DBA

1227

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

2036

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2613

---

What are statistics, under what circumstances they go out of date, how do you update them?

2309

---