12 RULES OF RDBMS
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.
Is This Answer Correct ? | 2 Yes | 0 No |
What types of joins are used in writing subqueries?
What is the implicit cursor in oracle?
Query to retrieve record for a many to many relationship ?
How to assign a table row to a record variable?
What happens if the imported table already exists?
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
what are the differen between key flexifild and discriptive fiexifild.
How to add a new column to an existing table with a default value?
Explain the function of optimizer in oracle?
What is primefaces used for?
How to drop an index in oracle?
Write query to fetch second maximum salary from employee table.
4 Answers Bravura Solutions, HCL,