What are the basic functions of DBMS ?

What are the basic functions of DBMS ?
by

1 Answer

Answer :

Answer : The basic tasks of DBMS are- 1) Database creation , data entry and data storage. 2) To search and correct the wrong data. 3) Deleting unnecessary data / records. 4) Searching and querying specific data / records. 5) Create and print the report. 6) Sort the database by any field. 6) Reduce data duplication 6) Print the entire database or part of the database if necessary. 9) Updating the database. 10) Provide data security and control the user. 11) Data Backup and Recovery .
by

Related questions

What are the main functions of DBMS ?

Description : What are the main functions of DBMS ?

Last Answer : Answer : The three main functions of DBMS are a) Database creation. B) Database interrogation and c) Database maintenance.

Which DBMS program ?

Description : Which DBMS program ?

Last Answer : FoxPro DBMS program

Which DBMS program ?

Description : Which DBMS program ?

Last Answer : FoxPro DBMS program.

DBMS works with which software ?

Description : DBMS works with which software ?

Last Answer : Answer : Oracle , MySql , MS -Sql, Microsoft Access, FoxPro , etc.

DBMS can be divided into how many parts ?

Description : DBMS can be divided into how many parts ?

Last Answer : DBMS can be divided into 3 parts. Namely: a) Client Server Database . B) Distributed Database c) Web Enable Database .

What is DBMS or Database Management System ?

Description : What is DBMS or Database Management System ?

Last Answer : DataBase Management System is the full form of DBMS . DBMS is a set of programs required for accessing , storing , controlling and managing interconnected information called database management systems.

What is the full form of DBMS ?

Description : What is the full form of DBMS ?

Last Answer : DBMS stands for: Database Management System.

What is DBMS ?

Description : What is DBMS ?

Last Answer : DBMS is a software-controlled system that determines database management , data space , security , data collection permissions, and more.

What are the functions of protocol in data communication ?

Description : What are the functions of protocol in data communication ?

Last Answer : The rules for exchanging data or information that actually exist in the form of software are called protocols. Communication software or protocols perform the following tasks in order to transmit data ... The components of a data transcript system are modem , transmitter , switch , receiver etc.

What are all the mathematical and logical functions performed on a computer ?

Description : What are all the mathematical and logical functions performed on a computer ?

Last Answer : All mathematical and logical functions in computer are performed by Central Processing Unit .

What are the rules for simplifying logic functions ?

Description : What are the rules for simplifying logic functions ?

Last Answer : Logical functions are executed through logic gates. So if the logical functions are simple, in reality the use of logic gate is easier. Boolean formulas can be used to simplify complex logical expressions. ... that can be found is to do it first. All other (+) operations must be completed.

How Many Basic Logic Gates ?

Description : How Many Basic Logic Gates ?

Last Answer : Basic Logic Gate three. OR, AND, NOT

What is Visual Basic ?

Description : What is Visual Basic ?

Last Answer : Visual Basic is a third generation event driven programming language.

How many basic logical operations ?

Description : How many basic logical operations ?

Last Answer : 3 basic logical operations.

What are the basic tags of HTML ?

Description : What are the basic tags of HTML ?

Last Answer : The basic tag of HTML is 4.

Explain Database Management. What are the features of DBMS? -Technology

Description : Explain Database Management. What are the features of DBMS? -Technology

Last Answer : It refers to the software that is responsible for storing, maintaining and utilising a database. It enables a user to define, create and maintain the database and provide controlled access on it. A ... Data security e.g. MS-Access, Corel Paradox, Lotus Approach, MySQL, OpenOffice.org Base etc.

Write the purpose of DBMS. -Technology

Description : Write the purpose of DBMS. -Technology

Last Answer : DBMS is used to store logically related information at a centralized location. It facilitates data sharing among all the applications requiring it.

Define the term DBMS. -Technology

Description : Define the term DBMS. -Technology

Last Answer : The full form of DBMS is a Database Management System. It is a computer based record keeping system.

State the primary goal of a DBMS. -Technology

Description : State the primary goal of a DBMS. -Technology

Last Answer : To provide a convenient and efficient environment in which we can store and retrieve information.

What do you mean by DBMS? -Technology

Description : What do you mean by DBMS? -Technology

Last Answer : It is a collection of programs that enables users to create, maintain database and control all the access to the database. It is a computer based record keeping system. DBMS is a software package that ... .DBMS is actually a tool that is used to perform any kind of operation on data in database.

Which of the following is not related to an application software? (a) Word processor (b) DBMS -Technology

Description : Which of the following is not related to an application software? (a) Word processor (b) DBMS -Technology

Last Answer : (c) Application software is a software which carries out a specific task like Word processor, spreadsheet, DBMS etc. Among the given options, operating system is related to system software.

DBMS is a program that controls the creation, maintenance and use of database. Here, DBMS referred to -Technology

Description : DBMS is a program that controls the creation, maintenance and use of database. Here, DBMS referred to -Technology

Last Answer : (c) Here, DBMS stands for Database Management System.

What is the full form of 'DBMS' ? -How To ?

Description : What is the full form of 'DBMS' ? -How To ?

Last Answer : The full form of 'DBMS' is Data Base Management System

What is the full form of DBMS ?

Description : What is the full form of DBMS ?

Last Answer : DBMS full Data Base Management System.

What is Lack of flexibility in DBMS?

Description : What is Lack of flexibility in DBMS?

Last Answer : Need answer

Which of the following is not the responsibility of the utilities component of DBMS software? A. creating the physical and logicaldesigns B. removingflaggedrecords for deletion C. creatingand maintaining the data dictionary D. monitoring performance E. None of the above

Description : Which of the following is not the responsibility of the utilities component of DBMS software? A. creating the physical and logicaldesigns B. removingflaggedrecords for deletion C. creatingand maintaining the data dictionary D. monitoring performance E. None of the above

Last Answer : creating the physical and logicaldesigns

In order to use a DBMS, it is important to understand A. the physical schema B. all sub-schemas that thesystem supports C. one subschema D. both (a)and (b) E. None of the above

Description : In order to use a DBMS, it is important to understand A. the physical schema B. all sub-schemas that thesystem supports C. one subschema D. both (a)and (b) E. None of the above

Last Answer : one subschema

Information can betransferred betweenthe DBMS and a A. spreadsheet program B. word processor program C. graphicsprogram D. AH of the above E. None of the above

Description : Information can betransferred betweenthe DBMS and a A. spreadsheet program B. word processor program C. graphicsprogram D. AH of the above E. None of the above

Last Answer : AH of the above

. A _____ DBMS distributesdata processing tasks between the workstation anda network server. A. Network B. Relational C. Client Server D. Hierarchical E. None of the above

Description : . A _____ DBMS distributesdata processing tasks between the workstation anda network server. A. Network B. Relational C. Client Server D. Hierarchical E. None of the above

Last Answer : Client Server

There arecertain packages that allow people to define data items, place these items in particular records, combine therecords into designated files and then manipulate and retrieve the storeddata. What arethey called? A. Data storage system B. Database management system (DBMS) C. Batch processingsystem D. Data communication package E. None of the above

Description : There arecertain packages that allow people to define data items, place these items in particular records, combine therecords into designated files and then manipulate and retrieve the storeddata. What arethey ... (DBMS) C. Batch processingsystem D. Data communication package E. None of the above

Last Answer : Database management system (DBMS)

A DBMS that runs on many different operating systems is said to be__________. A) scalable B) robust C) platform independent D) distributed

Description : A DBMS that runs on many different operating systems is said to be__________. A) scalable B) robust C) platform independent D) distributed

Last Answer : platform independent

The most open source DBMS. A) Microsoft SQL Server B) Microsoft Access C) MySQL D) Oracle

Description : The most open source DBMS. A) Microsoft SQL Server B) Microsoft Access C) MySQL D) Oracle

Last Answer : MySQL

The most popular commercial DBMS. A) Microsoft SQL Server B) Microsoft Access C) MySQL D) Oracle

Description : The most popular commercial DBMS. A) Microsoft SQL Server B) Microsoft Access C) MySQL D) Oracle

Last Answer : Oracle

DBMS stands for: a) Data Base Management Software b) Data Base Management System c) Diode Base Management System d) None of These

Description : DBMS stands for: a) Data Base Management Software b) Data Base Management System c) Diode Base Management System d) None of These

Last Answer : b) Data Base Management System

DBMS stands for: a) Dynamic Bureau of Management System b) Document Base Management System c) Data Base Management System d) None of These

Description : DBMS stands for: a) Dynamic Bureau of Management System b) Document Base Management System c) Data Base Management System d) None of These

Last Answer : c) Data Base Management System

The software that is used to create text-based documents are referred to as ______ a) DBMS b) Suites c) Spreadsheets d) Word processors e) None of these

Description : The software that is used to create text-based documents are referred to as ______ a) DBMS b) Suites c) Spreadsheets d) Word processors e) None of these

Last Answer : d) Word processors

What is “transparent DBMS”?

Description : What is “transparent DBMS”?

Last Answer : It is one, which keeps its Physical Structure hidden from user.

What is durability in DBMS?

Description : What is durability in DBMS?

Last Answer : Once the DBMS informs the user that a transaction has successfully completed, its effects should persist even if the system crashes before all its changes are reflected on disk. This property is called durability.

Advantages of DBMS?

Description : Advantages of DBMS?

Last Answer : ∙ Redundancy is controlled. ∙ Unauthorized access is restricted. ∙ Providing multiple user interfaces. ∙ Enforcing integrity constraints. ∙ Providing backup and recovery.

What is DBMS?

Description : What is DBMS?

Last Answer : It is a collection of programs that enables user to create and maintain a database. In other words it is general-purpose software that provides the users with the processes of defining, constructing and manipulating the database for various applications.

Centralizing the integrity checking directly under the DBMS ………….. Duplication and ensures the consistency and validity of the database. A) Increases B) Skips C) Does not reduce D) Reduces

Description : Centralizing the integrity checking directly under the DBMS ………….. Duplication and ensures the consistency and validity of the database. A) Increases B) Skips C) Does not reduce D) Reduces

Last Answer : D) Reduces

ome of the utilities of DBMS are ............. i) Loading ii) Backup iii) File organization iv) Process Organization A) i, ii, and iv only B) i, ii and iii only C) ii, iii and iv only D) All i, ii, iii, and iv

Description : ome of the utilities of DBMS are ............. i) Loading ii) Backup iii) File organization iv) Process Organization A) i, ii, and iv only B) i, ii and iii only C) ii, iii and iv only D) All i, ii, iii, and iv

Last Answer : B) i, ii and iii only

The DBMS utility, ...................... allows to reconstruct the correct state of database from the backup and history of transactions. A) Backup B) Recovery C) Monitoring D) Data loading

Description : The DBMS utility, ...................... allows to reconstruct the correct state of database from the backup and history of transactions. A) Backup B) Recovery C) Monitoring D) Data loading

Last Answer : B) Recovery

DBMS is a collection of ………….. that enables user to create and maintain a database. A) Keys B) Translators C) Program D) Language Activity

Description : DBMS is a collection of ………….. that enables user to create and maintain a database. A) Keys B) Translators C) Program D) Language Activity

Last Answer : C) Program

It is better to use files than a DBMS when there are (A) Stringent real-time requirements. (B) Multiple users wish to access the data. (C) Complex relationships among data. (D) All of the above. t

Description : It is better to use files than a DBMS when there are (A) Stringent real-time requirements. (B) Multiple users wish to access the data. (C) Complex relationships among data. (D) All of the above.

Last Answer : (B) Multiple users wish to access the data.

DBMS provides the facility of accessing data from a database through (A) DDL (B) DML (C) DBA (D) Schema

Description : DBMS provides the facility of accessing data from a database through (A) DDL (B) DML (C) DBA (D) Schema 

Last Answer : (B) DML

In a Database Managemnt System (DBMS), the content and the location of the data is defined by the ____. (1) Multi Dimensional data (2) Sequence data (3) Meta data (4) Sub data

Description : In a Database Managemnt System (DBMS), the content and the location of the data is defined by the ____. (1) Multi Dimensional data (2) Sequence data (3) Meta data (4) Sub data

Last Answer : Meta data

Identify the DBMS among the following. (1) MS-Access (2) MS-Power Point (3) PL/SQL (4) MS-Excel

Description : Identify the DBMS among the following. (1) MS-Access (2) MS-Power Point (3) PL/SQL (4) MS-Excel

Last Answer : PL/SQL