Advantages of DBMS?

Advantages of DBMS?
by

1 Answer

Answer :

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

Related questions

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.

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.

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

Description : What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

Last Answer : Complete database recovery from disk failure is possible only in ARCHIVELOG mode. Online database backup is possible only in ARCHIVELOG mode.

What are the advantages of VIEW ?

Description : What are the advantages of VIEW ?

Last Answer : To protect some of the columns of a table from other users.To hide complexity of a query.To hide complexity of calculations.

What are the advantages of having a Package ?

Description : What are the advantages of having a Package ?

Last Answer : Increased functionality (for example,global package variables can be declared and used by any proecdure in the package) and performance (for example all objects of the package are parsed compiled, and loaded into memory once)

What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

Description : What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

Last Answer : % TYPE provides the data type of a variable or a database column to that variable. % ROWTYPE provides the record type that represents a entire row of a table or view or columns selected in ... database definition of a column in a table changes, the data type of a variable changes accordingly.

What are advantages fo Stored Procedures?

Description : What are advantages fo Stored Procedures?

Last Answer : Extensibility,Modularity, Reusability, Maintainability and one time compilation.

What is a package ? What are the advantages of packages ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Description : What is a package ? What are the advantages of packages ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Last Answer : The PRAGMA EXECPTION_INIT tells the complier to associate an exception with an oracle error. To get an error message of a specific oracle error. e.g. PRAGMA EXCEPTION_INIT (exception name, oracle error number)

It is possible to use raw devices as data files and what is the advantages over file. system files ?

Description : It is possible to use raw devices as data files and what is the advantages over file. system files ?

Last Answer : Yes. The advantages over file system files. I/O will be improved because Oracle is bye-passing the kernnel which writing into disk. Disk Corruption will be very less.

What are the advantages of views?

Description : What are the advantages of views?

Last Answer : Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table. - Hide data complexity. - Simplify commands for the user. - Present the data in a different perspective from that of the base table. - Store complex queries.

What are stored-procedures? And what are the advantages of using them.

Description : What are stored-procedures? And what are the advantages of using them.

Last Answer : Stored procedures are database objects that perform a user defined operation. A stored procedure can have a set of compound SQL statements. A stored procedure executes the SQL commands and returns the result to the client. Stored procedures are used to reduce network traffic.

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

Which DBMS program ?

Description : Which DBMS program ?

Last Answer : FoxPro DBMS program

Which DBMS program ?

Description : Which DBMS program ?

Last Answer : FoxPro DBMS program.

What are the basic functions of DBMS ?

Description : What are the basic functions of DBMS ?

Last 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 ... Updating the database. 10) Provide data security and control the user. 11) Data Backup and Recovery .

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 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.

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 full Data Base Management System.

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 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

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