Which of the following statements concerning Object-Oriented databases is FALSE ?
Object-oriented databases are more adapt at handling structured (analytical) data than relational databases.
An object-oriented database stores data as objects. Each object encapsulates its attribute values together with the methods (procedures) that operate on them, and it supports complex types such as images, audio, video and nested structures.
Objects contain both data and the methods for processing the data: true, this is encapsulation.
Computational instructions are stored in the same place as the data: true, because the methods are stored with the objects themselves.
Object-oriented databases store more types of data than relational databases and access that data faster: true as stated in the standard comparison, since they hold complex and multimedia types and follow object references directly instead of performing joins.
Object-oriented databases are more adept at handling structured (analytical) data than relational databases: false. Highly structured, tabular, analytical data is the strength of the relational model; object-oriented databases are favoured for complex, unstructured or multimedia data.
Object-oriented databases are more adapt at handling structured (analytical) data than relational databases. option is correct.
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.
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.