Answer / guest

create table emp(EMPID number(9),SAL number(10));
Result:creates a table named EMP.
a)alter table EMP add DEPTNO number(9);
Result:a new coloumn DEPTNO is added to the existing table EMP.
b)alter table EMP rename to EMP-RENAMED;
Result:renames the table name EMP to EMP-RENAMED.
c)update EMP-RENAMED
set SAL=SAL+10000
where EMPID>=xxxx;
Result:updates the salaries of Table emp depending upon the condition.
d)alter table EMP-RENAMED modify SAL varchar2(15);
Result:alters the SAL coloumn datatype to varchar2.

Answer / arvind agrawal

if want a column in table emp then perform above operation
sql>add deptno into emp;

I m Abdullah Ansari compleated MCA from Jamia Hamdard,i have appeared the test of IBM on 2 august at oxford college of engineering Bangalore.waiting for hr round.. This is the first round for IBM.02/08/08 Paper consists of 4 sections 15 questions from matrices(time very less but no negative marking). 25 questions from series completion section (this section is very easy but negative marking) 15 questions from aptitude(little bit tough time limit 15 minute negative marking) 4th section is from computer science (c,c++,operating system,digital electronics ,basic question..) result came at 3 o'clock.i was selected... In interview they asked questions like 1 they asked about final yr project.. 2 what are dynamic and static memory location? 3 linked list and array difference between them. 4 what is function ? what is difference betwen function and inline function? 5 about structure 6 about binary tree, traversal, call by value. 7 storage class and many more basic questions..

0 Answers   IBM,

---

What are the main principles of OOP?

1 Answers  

---

What is the difference between compiled and interpreted languages?

1 Answers  

---

HOW TO FIND NUMBER OF TWOS IN N!(N FACTORIAL)??

0 Answers  

---

When we have more than one main function in a program how does the compiler know the starting point of the program, i mean from which main the execution or compilation of the program begins?

2 Answers   247Customer,

---

how can we get version of database ?

1 Answers  

---

write a program for finding the union of two integer array in java?

2 Answers  

---

Always use scope terminator like End-If with IF, End- Evaluate with Evaluate statement.Can somebody explain me the detail logical explanation?

0 Answers  

---

Explain recursion with an example.

1 Answers  

---

DIFFERENCE BETWEEN BINDING LANG AND BIND DIR WHEN USING IN SERVICE PGM

0 Answers   CTS,

---

.net 2005 supports how many languages?

4 Answers  

---

if try is followed by finally block what happen to exception occured in try block

3 Answers   Professional Access,

---