Elearning , Interview Questions And Answers

Google

28. The value of x is between 0 & 1 which is the larger? A) x B) x^2 C)
-x D) 1/x Ans : (D)
ORACLE TEST 1. What are the difference b/w candidate key, primary key and unique key?
2.
What is difference b/w pre query and post query? 3. How many number of columns can be created in a single table. 4. What is meant by ROWID? Why we need it? 5. What is transaction? 6. Difference b/w function, procedure? 7. Which one is the best way to find out the number of rows in a table, state by following a) count (1) b) count (*), count (rowed) One table is given and questions based on this table. 1. Write query to delete a single column in a table. 2. Write query to add one more column in a existing table. 3. Write query to delete only 2 duplicate records in a table.But the table they have given contains 3 duplicate records. How to do it.
4.
Some SELECT statements queries they asked like using group by, ordered by, where...etc.


Hosted by www.Geocities.ws

1