DBMS - Database Management System Online Test


In practice, a client–server database system generally refers to a of personal computers (PCs).

systems must be capable of handling thousands of orders placed at the same time.

In the data model the database is represented as a group of related tables.

The consists of the memory components of Oracle and various background processes.

The overall design of the database is called the schema.

level describes what data are actually stored in the database.

Each transactional table handler implements its own to handle all locking and concurrency needs.

Data independence is usually considered from points of view.

The translates the various DML statements into low-level file system commands.

data independence implies that application programs need not be changed if fields are added to an existing record.