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 can you implement fine-grained auditing?

1064

---

what is grd?

1047

---

What is dcl? : sql server DBA

1184

---

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

1042

---

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

950

---

what are the differences of where and if in SAS?

2130

---

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?

1944

---

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

2407

---

Explain about your sql server dba experience? : sql server DBA

1022

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2190

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2612

---

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

992

---

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

2879

---

Explain materialized views and how they are used.

2380

---

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

2134

---