Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


what is data independence exactly? give an example

Answers were Sorted based on User's Feedback



what is data independence exactly? give an example..

Answer / sravya

There are two types of data independence

1. Logical data independence: The ability to change the
logical (conceptual) schema without changing the External
schema (User View) is called logical data independence. For
example, the addition or removal of new entities,
attributes, or relationships to the conceptual schema should
be possible without having to change existing external
schemas or having to rewrite existing application programs.

2 Physical data independence: The ability to change the
physical schema without changing the logical schema is
called physical data independence. For example, a change to
the internal schema, such as using different file
organization or storage structures, storage devices, or
indexing strategy, should be possible without having to
change the conceptual or external schemas.

Is This Answer Correct ?    127 Yes 11 No

what is data independence exactly? give an example..

Answer / guneetinder singh

Data independence means when we bring out changes in lower
levels then upper level does not feel any affect.
i.e. changing internal level does not affect conceptual level.

Is This Answer Correct ?    77 Yes 10 No

what is data independence exactly? give an example..

Answer / mohammad ikram

Physical data independence
- the capacity to change the internal schema without
having to change the conceptual (or external) schema
- internal schema may change to improve the performance
(e.g., creating additional access structure)

Is This Answer Correct ?    17 Yes 4 No

what is data independence exactly? give an example..

Answer / noor alam

The separation of data descriptions from the application
programs (or user-interfaces) that uses the data is called
data independence.

Is This Answer Correct ?    8 Yes 3 No

what is data independence exactly? give an example..

Answer / monika

Data independance:
It includes the isolation of data from application program.
There are 2 types of data independance:
1.Logical data independance:
The ability to change the conceptual schema without
altering the external schema or application programs.
2.Physical data independance:
It is ability to change the internal schema without
changing the conceptual or external schema.

Is This Answer Correct ?    4 Yes 4 No

what is data independence exactly? give an example..

Answer / mohammad aquib

When the logical structure of database changes , application program are only minimally affected and requires very little modification ,it is called data independent

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

what is the difference between dbms and rdbms?

3 Answers   Oracle,


how to find the second highest salary in a given table????

5 Answers  


How to call a trigger inside a stored procedure?Give an example.

2 Answers  


what are indexes..how many types of index's are there and what are they?

7 Answers   Green Info Solutions, TCS,


WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.

3 Answers  


Is it possible to split the print reviewer into more than one region ?

0 Answers   Oracle,


Explain the family trees and connection by clause

0 Answers  


 How to use an oracle sequence generator in a mapping?

0 Answers   Informatica,


Explain what are the advantages of views?

0 Answers  


How to increment dates by 1 in oracle?

0 Answers  


HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT

5 Answers   College School Exams Tests, DELL,


If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1809)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)