Answer / guest

I. to modify datatype of a column ?
ii. to add a column with NOT NULL constraint ?

To Modify the datatype of a column the column must be empty.

To add a column with NOT NULL constrain, the table must be
empty.

What is difference between Procedures and Functions ?

6 Answers   Hi Caliber IT,

---

What does count (*) mean?

0 Answers  

---

What is a field in a database?

0 Answers  

---

In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,

---

How do you explain an index?

0 Answers  

---

How many types of triggers are there in pl sql?

0 Answers  

---

Explain spool.

0 Answers  

---

What are aggregate and scalar functions?

0 Answers  

---

Explain what is dbms?

0 Answers  

---

Can we use distinct and group by together?

0 Answers  

---

Can we insert in view in sql?

0 Answers  

---

Regarding joins what are the differences you observed in oracle 9i and sql server?

3 Answers   Choice Solutions,

---