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';

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,

---

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

0 Answers  

---

How would you determine the time zone under which a database was operating?

2 Answers  

---

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  

---

How do you add a data file to a tablespace?

3 Answers  

---

wat is global index and local indes

1 Answers   Oracle,

---

Explain the use of table functions.

1 Answers  

---

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

0 Answers   Oracle,

---

How can we know the exact updation date of a particular database?

2 Answers   Satyam,

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  

---

how can you implement fine-grained auditing?

0 Answers   Oracle,

---