Answer / povidyasagar

1. Data should be represent in the form of table.
2. data is logically accessible.
3. all the null vaules should be uniformly treated as
unknown values.
4. single language should be used to communicate with RDBMS
package.
5. every relational database should be self described.
oracle contains two types of tables.
(a) system tables -- tables which contains meta data of user
tables.
(b) user tables -- tables with business data.
6. logical data independence.
7. physical data independence.
8. altematives must be provided for viewing data.
9. every RDBMS package should supports setbased and
relational algebra operations.
10. integrity rule.
11. every RDBMS package should support distributed operations.
12. data integrity cannot be subverted.
Note: Any DBMS package supports 6 out of 12 codds rules.

can we insert any row to dual table if i got the permission from DBA

5 Answers   HCL, Tesco,

---

18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>

2 Answers   Wipro,

---

defination of bitmap index

0 Answers   NIIT,

---

Can you assign multiple query result rows to a variable?

0 Answers  

---

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3

3 Answers  

---

What happens if the update subquery returns multiple rows?

0 Answers  

---

What is raw datatype in oracle?

0 Answers  

---

What is connection pooling in oracle?

0 Answers  

---

1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

1 Answers   Wipro,

---

How to add a new column to an existing table with a default value?

0 Answers  

---

Explain can a view based on another view?

1 Answers  

---

Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

6 Answers   IBM,

---