Answer / guest

If we find that fragmentation of space in a tablespace is
high (contiguous space on our disk appears as
non-contiguous),we can coalesce any free space using the

ALTER TABLESPACE TABLESPACE_NAME COALESCE ; command

We must have the ALTER TABLESPACE system privilege to
coalesce tablespaces.

Regards
Abhinav Phadnis

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

how can you create a user-defined lock?

0 Answers   Oracle,

---

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---

what is the diffrence between core dba and apps dba?

0 Answers   Cap Gemini,

---

what do you understand by fine-grained auditing?

0 Answers   Oracle,

---

how can you communicate with operating system files from oracle?

0 Answers   Oracle,

---

how can you connect from 10g user to 11g user??

0 Answers   HP,

---

What is the difference between Datapump & export/import?

2 Answers  

---