Answer Posted / anil kumar prajapati

olumn "Tablespace" format a13
column "Used MB" format 99,999,999
column "Free MB" format 99,999,999
column "Total MB" format 99,999,999
select
fs.tablespace_name "Tablespace",
(df.totalspace - fs.freespace) "Used MB",
fs.freespace "Free MB",
df.totalspace "Total MB",
round(100 * (fs.freespace / df.totalspace)) "Pct. Free"
from
(select
tablespace_name,
round(sum(bytes) / 1048576) TotalSpace
from
dba_data_files
group by
tablespace_name
) df,
(select
tablespace_name,
round(sum(bytes) / 1048576) FreeSpace
from
dba_free_space
group by
tablespace_name
) fs
where
df.tablespace_name = fs.tablespace_name;

how does an oracle clusterware manage crs resources?

1092

---

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

---

how can you process messages in order asynchronously?

976

---

What is replication? : sql server DBA

1179

---

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

2300

---

how can you enable flashback feature?

957

---

what do you understand by flashback feature of oracle?

995

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2720

---

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

1132

---

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

1072

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2157

---

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

1018

---

What is a system database and what is a user database? : sql server DBA

1237

---

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

998

---

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

---