In distributed databases, location transparency allows for database users, programmers and administrators to treat the data as if it is at one location. A SQL query with location transparency needs to specify :
Fragments
Distributed database systems offer levels of distribution transparency. With fragmentation transparency the user queries the global table and needs neither fragment names nor locations. With location transparency the user must name the fragments to be used but need not know where (at which site) each fragment is stored. With only local mapping transparency, the user must give both the fragment names and their locations.
So a SQL query written under location transparency still specifies the fragments, for example a UNION of the fragments of a table, while the sites remain hidden.
Specifying locations is exactly what location transparency removes; local formats are hidden by local mapping transparency; inheritance is an object-oriented concept with no role in addressing distributed fragments.
Fragments option is correct.
Similar Questions
A computer based information system is needed :
I. as it is difficult for administrative staff to process data.
II. due to rapid growth of information and communication technology.
III. due to growing size of organizations which need to process large volume of data.
IV. as timely and accurate decisions are to be taken.
Which of the above statement(s) is/are true ?
Location transparency allows :
I. Users to treat the data as if it is done at one location.
II. Programmers to treat the data as if it is at one location.
III. Managers to treat the data as if it is at one location.
Which one of the following is correct ?
Which of the following statements regarding the features of the object-oriented approach to databases are true ?
(a) The ability to develop more realistic models of the real world.
(b) The ability to represent the world in a non-geometric way.
(c) The ability to develop databases using natural language approaches.
(d) The need to split objects into their component parts.
(e) The ability to develop database models based on location rather than state and behaviour.
Codes :
Match the following database terms to their functions :
List - I List - II (a) Normalization (i) Enforces match of primary key to foreign key (b) Data Dictionary (ii) Reduces data redundancy in a database (c) Referential Integrity (iii) Defines view(s) of the database for particular user(s) (d) External Schema (iv) Contains metadata describing database structure Codes :
Database applications were built directly on top of file system to overcome the following drawbacks of using file-systems :
(a) Data redundancy and inconsistency
(b) Difficulty in accessing Data
(c) Data isolation
(d) Integrity problems
Manager’s salary details are hidden from the employee. This is called as
Match the LIST-I with LIST-II
LIST-I LIST-II A. Project Join Normal Form I. Concurrency B. The lost update problem II. Fifth Normal Form C. Discretionary Access Control III. SQL D. Data manipulation Language IV. Security Choose the correct answer from the options given below:
Arrange the following phases of database design in the correct order :
(A) Physical Design
(B) Conceptual Design
(C) Logical Design
(D) Requirement Analysis
Choose the correct answer from the options given below :
What will be the right sequence of the phases of database design-
A. Physical Design
B. Conceptual Design
C. Logical Design
D. Requirement collection and analysis
Choose the correct answer from the options given below:
Which of the following statements is/are true w.r.t. Enterprise Resource Planning (ERP) ?
(A) ERP automates and integrates majority of business processes.
(B) ERP provides access to information in a Real Time Environment.
(C) ERP is inexpensive to implement.
Important Questions from Database Introduction
DBMS does not serve as a tool for which of the following?
Which of the following is an advantage of ‘server-database’?
Which one of the following is considered as a threat to database and DBMS ?
Deductive model of DBMS is also known as ______.
_____ is a system database that contains description of the data in the database.
