Can you redefine a table online?

0 Answers   Oracle,

---

how will you see when the database was started using sql prompt?

2 Answers   IBM,

---

why do we give pctfree and pctused in create table statement?

1 Answers   CTS,

---

How do you add a data file to a tablespace?

3 Answers  

---

Name a tablespace automatically created when you create a database.

5 Answers  

---

---

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

0 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  

---

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

---

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

2 Answers  

---

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

---