Answer / Prem Pal

DCL stands for Data Control Language, which is a set of SQL commands used to control access to data in a database. Examples of DCL commands include GRANT (to give permissions), REVOKE (to take away permissions), and DENY (to explicitly deny permissions).

What is the difference between clustered and non-clustered index? : sql server DBA

1 Answers  

---

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

---

How would you begin to troubleshoot an ORA-3113 error?

1 Answers  

---

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---

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

1 Answers   Oracle,

---

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,

---

Explain an ORA-01555

2 Answers  

---

how can you find out if a table can be redefined?

1 Answers   Oracle,

---

what is logical system in sap basis

1 Answers  

---

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

2 Answers  

---

the process of adding a cpu in sql server is called..?

2 Answers   TCS,

---

what is asm?

1 Answers   Oracle,

---