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.

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

2253

---

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

2036

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2340

---

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

1080

---

what is logical system in sap basis

1641

---

What are the recovery models for a database? : sql server DBA

1132

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2113

---

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

1976

---

What the different components in replication and what is their use? : sql server DBA

1051

---

Explain materialized views and how they are used.

2443

---

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?

1987

---

What happens on checkpoint? : sql server DBA

1095

---

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2109

---

what are the types of connection load-balancing?

1000

---

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

2622

---