Answer / prasuna

Granting view means giving access to the view that is
already created where as creating a view means creating a
new view
granting privileges to a view is a dcl command
where as creating a view is a ddl command

Answer / swapna

Granting depends upon the user, he may give permission for
others to manipulation on the table. But in case of views
others can only retrive the table.
granting is dcl command
creating is ddl command

how will u find statistics of a database objects?

2 Answers   iFlex,

---

How many types of normalization are there?

0 Answers  

---

Write one update command to update seqno field of a table on the basis of row number.

4 Answers   HCL,

---

How do we tune the code?

2 Answers  

---

How do u count no of rows in a table?

8 Answers   CTS,

---

---

I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 Answers  

---

Explain clause in sql?

0 Answers  

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

0 Answers   CTS,

---

query to retrive the employees whose sal is greater than avg sal

10 Answers   TCS,

---

Can we write create command in the plsql block?if possible how?

2 Answers  

---

How to connect a sql*plus session to an oracle server?

0 Answers  

---

What is offset in sql query?

0 Answers  

---