what is the difference between cluster and non cluster index? : Sql dba

0 Answers  

---

Give the order of sql select?

0 Answers  

---

Can we enter data in a table in design view?

0 Answers  

---

What is the reports view in oracle sql developer?

0 Answers  

---

How to handle bulk data?

0 Answers  

---

---

Write a sql query to find the names of employees that begin with ‘a’?

0 Answers  

---

When is the update_statistics command used?

0 Answers  

---

explain the difference between delete , truncate and drop commands? : Sql dba

0 Answers  

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

What is having clause in sql?

0 Answers  

---

write the Sql query for creating database backup?

7 Answers   TCS,

---

what is Difference between Having and Where clause?

5 Answers   IBM,

---