0
1. DBMS Developers
2. Application Developers
3. DBA
4. End user
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
What is the purpose of dbms?
What is the purpose of dbms?DBMS is a software that organises the creation, storage and maintenance of Databases for end users.
A DBMS lets you assign users to what?
groups
Explain the types of dbms users?
There are four types of DBMS users,Naive UsersOnline UsersApplication Program UsersDatabase AdministratorNote: The description of above points is currently not available.
What software allows users to create access and manage a data base?
dbms
Categories of users of DBMS?
In DBMS you can have users who have only select access or with only select+update+insert access or with select+update+insert+delete access. These users may or may not be granted permissions to alter the table schema. Also you can have administrators who can create/modify/delete tables
What is the use of dbms?
DataBase Management System (DBMS)is a software package# it allows data to be effectively stored, retrieved and manipulatedand # the data stored in a DBMS packege can be accessed by multiple users and by multiple application programs like (SQL Server, Oracle, Ms-Access) .Types of DBMS# Hierarachical DBMS (HDBMS)# Network DBMS (NDBMS)# Relational DBMS (RDBMS)# Object Oriented DataBase(OODB)# Distributed DBMS (DDBMS)
What is the language used by most of the DBMS for helping their users to access data?
query language
What is a Multi-user DBMS Architecture?
A Multi-user DBMS Architecture is one big system of users and queries. The use of these are to over look and execute plans safely and does not violate and integrity constraints.
What are the advantages DBMS?
-data redundancy:which reduce the redundancy-repetition of data -security-it provides security for various levels -data sharing-it allows multiple users to access and share the data becomes easier in dbms -data concurrency:it allow multiple users to acess the same data simultaniously
WHAT TASKS does dbms do?
A Database Management System or DBMS provides the interface between users and a database. Some of its tasks include: data integrity, security, recovery of data, support concurrent updates and update data.
What is DBMS and when it should not be used?
DBMS stands for Database Management System. It is software that manages and organizes databases, allowing users to store, retrieve, and modify data efficiently. However, there are situations where using a DBMS may not be appropriate. For example, if the amount of data to be stored is small, or if the data needs to be accessed and manipulated in a simple and straightforward manner, using a DBMS might be unnecessary and can add unnecessary complexity and overhead to the system.
What allows concurrent access by multiple users in a database?
Primarily it's based on rules about when changes to data are posted in a transaction and read by other users, which are part of the record-locking features of the DBMS. Some DBMS's manage this with undo and redo logs, which support snapshotting the data before the updates were started, so that other users can access the records before the update transaction was started.
