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 ?
I and II only
In a distributed database, location transparency means that whoever accesses the data need not know at which site a relation or fragment is physically stored; the DDBMS finds and fetches it.
Statement I is true: end users issue queries as though all the data were held at one place.
Statement II is true: application programmers write programs against the global schema without coding site names, so the programs need not change when data is moved.
Statement III is false: the people who manage the distributed database (database administrators/managers) design fragmentation, allocation and replication, so the distribution is exactly what they must see; transparency is provided for those who use the data, not for those who place it.
Thus only I and II hold.
Hence, the answer is I and II only.
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 ?
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.
Semi-join strategies are techniques for query processing in distributed database system. Which of the following is a semi-join technique ?
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.
