Answer / jaleel

TO CHECK TAKINGUP SPACE
SQL> select sum(bytes)/1024/1024 "TABLESPACESIZE:MB"
from dba_segments where tablespace_name='TEST';

TO CHECK FREE SPACE
SQL> select sum(bytes)/1024/1024 "TABLESPACESIZE:MB"
from dba_free_space where tablespace_name='TEST';

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

---

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

0 Answers  

---

what are the types of connection load-balancing?

0 Answers   Oracle,

---

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

---

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers  

---

Name three advisory statistics you can collect.

1 Answers  

---

How would you extract DDL of a table without using a GUI tool?

0 Answers  

---

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

0 Answers   Oracle,

---

Give two examples of referential integrity constraints.

2 Answers  

---