Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
How to add another datafile to a tablespace?
How to create a stored function in oracle?
Can you drop an index associated with a unique or primary key constraint?
Explain the use of record length option in exp command.
What is the difference between truncate & delete command?
How to retrieve data from an explicit cursor?
What is oracle instant client?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What is a database table in oracle?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How do I uninstall oracle 11g?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How to best split csv strings in oracle 9i?
How do I know if oracle is installed on windows?
