COMPUTER SOFTWARE
APPLICATION SOFTWARE
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Organise and manipulate data
|
|
|
Translation into other languages
|
|
|
Carry out queries on database data and produce report
|
|
|
Add, delete and modify data in a table
|
Detailed explanation-1: -Database languages are commonly divided into Data Definition Language (DDL), Data Control Language (DCL), Data Manipulation Language (DML), and Transaction Control Language (TCL).
Detailed explanation-2: -Database Language is a special type of programming language used to define and manipulate a database. These are four different types: DDL, DML, DCL, and TCL. DDL commands are used to alter/create schema and metadata of the database. DML commands are used to access and manipulate data stored in existing schema objects.
Detailed explanation-3: -A DML is often a sublanguage of a broader database language such as SQL, with the DML comprising some of the operators in the language. Used for adding (inserting), deleting, and modifying (updating) data in a database. Used for creating and modifying database objects such as tables, indices, and users.
Detailed explanation-4: -Elimination of redundant data. Enabling data access easy for the user. Providing a source of mass storage of data. Allowing multiple users to access the database at the same time. Providing appropriate and quick response to user queries.