What is DML (Data Manipulation Language)?

What is DML (Data Manipulation Language)?
by

1 Answer

Answer :

This language that enable user to access or manipulate data as organised by appropriate data  model.
∙ Procedural DML or Low level: DML requires a user to specify what data are needed and  how to get those data.
∙ Non-Procedural DML or High level: DML requires a user to specify what data are needed  without specifying how to get those data.
by

Related questions

DML is provided for (A) Description of logical structure of database. (B) Addition of new structures in the database system. (C) Manipulation & processing of database. (D) Definition of physical structure of database system.

Description : DML is provided for (A) Description of logical structure of database. (B) Addition of new structures in the database system. (C) Manipulation & processing of database. (D) Definition of physical structure of database system.

Last Answer : C) Manipulation & processing of database.

What is DML Compiler?

Description : What is DML Compiler?

Last Answer : It translates DML statements in a query language into low-level instruction that the query evaluation engine can understand

Say two examples of DML, two of DCL and two of DDL

Description : Say two examples of DML, two of DCL and two of DDL

Last Answer : Say two examples of DML, two of DCL and two of DDL

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

What is Data Storage - Definition Language?

Description : What is Data Storage - Definition Language?

Last Answer : The storage structures and access methods used by database system are specified by a set of definition in a special type of DDL called data storage-definition language.

What is DDL (Data Definition Language)?

Description : What is DDL (Data Definition Language)?

Last Answer : A data base schema is specifies by a set of definitions expressed by a special language called DDL.

Write the full forms of the following: (i) DDL (ii) DML -Technology

Description : Write the full forms of the following: (i) DDL (ii) DML -Technology

Last Answer : (i) DDL-Data Definition Language(ii) DML-Data Manipulation Language

What is the full form of DML ?

Description : What is the full form of DML ?

Last Answer : Full form of DML : Data Manipulation Language.

What is DML ?

Description : What is DML ?

Last Answer : DML is: The language used to manage and control all the information in a database is called DML .

What is the function of DML ?

Description : What is the function of DML ?

Last Answer : The function of DML is to: Retrieve any data from the database or add new data to the database , delete data or modify etc.

Anything that affects the database schema is a part of A) DML B) DCL C) DDL D) All of the above

Description : Anything that affects the database schema is a part of A) DML B) DCL C) DDL D) All of the above

Last Answer : D) All of the above

The database schema is written in (A) HLL (B) DML (C) DDL (D) DCL

Description : The database schema is written in (A) HLL (B) DML (C) DDL (D) DCL

Last Answer : (C) DDL

Which of the following contains output segments of AI programming? a) Printed language and synthesized b) Manipulation of physical object c) Locomotion d) All of the mentioned

Description : Which of the following contains output segments of AI programming? a) Printed language and synthesized b) Manipulation of physical object c) Locomotion d) All of the mentioned

Last Answer : d) All of the mentioned

Which of the following contains the output segments of Artificial Intelligence programming? a) Printed language and synthesized speech b) Manipulation of physical object c) Locomotion d) All of the mentioned

Description : Which of the following contains the output segments of Artificial Intelligence programming? a) Printed language and synthesized speech b) Manipulation of physical object c) Locomotion d) All of the mentioned

Last Answer : d) All of the mentioned

HTML stands for (A) Hyper Text Markup Language (B) Hyper Text Manipulation Language (C) Hyper Text Managing Links (D) Hyper Text Manipulating Links

Description : HTML stands for (A) Hyper Text Markup Language (B) Hyper Text Manipulation Language (C) Hyper Text Managing Links (D) Hyper Text Manipulating Links

Last Answer : (A) Hyper Text Markup Language

Computer based record keeping system is known as (a) Data Manipulation System -Technology

Description : Computer based record keeping system is known as (a) Data Manipulation System -Technology

Last Answer : (d) DBMS is a collection of programs that enable the user to create and maintain the database. Also, it is a computer-based record keeping system.

A modern electronic computer is a machine that is meant for A) Doing quick mathematical calculations B) Input, storage, manipulation and outputting of data C) Electronic data processing D) Performing repetitive tasks accurately

Description : A modern electronic computer is a machine that is meant for A) Doing quick mathematical calculations B) Input, storage, manipulation and outputting of data C) Electronic data processing D) Performing repetitive tasks accurately

Last Answer : Answer : B

In data transfer manipulation designing as instruction set for a system isa complex_ a. Art b. System Cc. Computer d. None of these

Description : In data transfer manipulation designing as instruction set for a system isa complex_ a. Art b. System Cc. Computer d. None of these

Last Answer : a. Art

How many types of basically Data manipulation: 1 2 3 ap 4

Description : How many types of basically Data manipulation: 1 2 3 ap 4

Last Answer : 3

Which is data manipulation types are. a. Arithmetic instruction b. Shift instruction c. Logical and bit manipulation instructions d. All of these

Description : Which is data manipulation types are. a. Arithmetic instruction b. Shift instruction c. Logical and bit manipulation instructions d. All of these

Last Answer : d. All of these

In which instruction are used to perform Boolean operation on non-numerical data: a. Logical and bit manipulation b. Shift manipulation c. Circular manipulation d. None of these

Description : In which instruction are used to perform Boolean operation on non-numerical data: a. Logical and bit manipulation b. Shift manipulation c. Circular manipulation d. None of these

Last Answer : a. Logical and bit manipulation

A modern electronic computer is a machine that is meant for a. Doing quick mathematical calculations b. Input, storage, manipulation and outputting of data c. Electronic data processing d. Performing repetitive tasks accuratel

Description : A modern electronic computer is a machine that is meant for a. Doing quick mathematical calculations b. Input, storage, manipulation and outputting of data c. Electronic data processing d. Performing repetitive tasks accuratel

Last Answer : Input, storage, manipulation and outputting of data

Which application-level protocol plays a crucial role in carrying out the data definition and manipulation in addition to X-500 features? a. TCP b. LDAP c. FTP d. None of the above

Description : Which application-level protocol plays a crucial role in carrying out the data definition and manipulation in addition to X-500 features? a. TCP b. LDAP c. FTP d. None of the above

Last Answer : b. LDAP

Errors in computer results could be due to 1) encoding of data 2) transmission of data 3) manipulation of data 4) all of the above

Description : Errors in computer results could be due to 1) encoding of data 2) transmission of data 3) manipulation of data 4) all of the above

Last Answer : 4) all of the above

A modern electronic computer is a machine that is meant for a. Doing quick mathematical calculations b. Input, storage, manipulation and outputting of data c. Electronic data processing d. Performing repetitive tasks accurately

Description : A modern electronic computer is a machine that is meant for a. Doing quick mathematical calculations b. Input, storage, manipulation and outputting of data c. Electronic data processing d. Performing repetitive tasks accurately

Last Answer : b. Input, storage, manipulation and outputting of data

Digital forensic is all of them except: a. Extraction of computer data b. Preservation of computer data c. Interpretation of computer data d. Manipulation of computer data

Description : Digital forensic is all of them except: a. Extraction of computer data b. Preservation of computer data c. Interpretation of computer data d. Manipulation of computer data

Last Answer : b. Preservation of computer data

Digital forensics is all of them except: a. Extraction of computer data. b. Preservation of computer data. c. Interpretation of computer data. d. Manipulation of computer data.

Description : Digital forensics is all of them except: a. Extraction of computer data. b. Preservation of computer data. c. Interpretation of computer data. d. Manipulation of computer data.

Last Answer : d. Manipulation of computer data.

Digital forensics is all of them except: (A) Extraction of computer data. (B) Preservation of computer data. (C) Interpretation of computer data. (D) Manipulation of computer data.

Description : Digital forensics is all of them except: (A) Extraction of computer data. (B) Preservation of computer data. (C) Interpretation of computer data. (D) Manipulation of computer data.

Last Answer : (D) Manipulation of computer data.

Digital forensics is all of them except: A. Extraction of computer data. B. Preservation of computer data. C. Interpretation of computer data. D. Manipulation of computer data.

Description : Digital forensics is all of them except: A. Extraction of computer data. B. Preservation of computer data. C. Interpretation of computer data. D. Manipulation of computer data.

Last Answer : D. Manipulation of computer data.

Computer forensics do not involve_____activity. A. Preservation of computer data. B. Exraction of computer data. C. Manipulation of computer data. D. Interpretation of computer data.

Description : Computer forensics do not involve_____activity. A. Preservation of computer data. B. Exraction of computer data. C. Manipulation of computer data. D. Interpretation of computer data.

Last Answer : C. Manipulation of computer data. 

Digital forensics is all of them except: A. Extraction of computer data. B. Preservation of computer data. C. Interpretation of computer data. D. Manipulation of computer data.

Description : Digital forensics is all of them except: A. Extraction of computer data. B. Preservation of computer data. C. Interpretation of computer data. D. Manipulation of computer data.

Last Answer : D. Manipulation of computer data. 

What is SDL (Storage Definition Language)?

Description : What is SDL (Storage Definition Language)?

Last Answer : This language is to specify the internal schema. This language may specify the mapping between two schemas

What is VDL (View Definition Language)?

Description : What is VDL (View Definition Language)?

Last Answer : It specifies user views and their mappings to the conceptual schema.

Can a repeating frame be created without a data group as a base?

Description : Can a repeating frame be created without a data group as a base?

Last Answer : No

Can one resize tablespaces and data files? (for DBA)

Description : Can one resize tablespaces and data files? (for DBA)

Last Answer : One can manually increase or decrease the size of a datafile from Oracle 7.2 using the command. ALTER DATABASE DATAFILE 'filename2' RESIZE 100M; Because you can change the ... UNLIMITED DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) ONLINE PERMANENT;

What view would you use to look at the size of a data file?

Description : What view would you use to look at the size of a data file?

Last Answer : DBA_DATA_FILES

How do you resize a data file?

Description : How do you resize a data file?

Last Answer : ALTER DATABASE DATAFILE RESIZE ;

How do you add a data file to a tablespace

Description : How do you add a data file to a tablespace

Last Answer : ALTER TABLESPACE ADD DATAFILE SIZE

Give the two types of tables involved in producing a star schema and the type of data they hold.

Description : Give the two types of tables involved in producing a star schema and the type of data they hold.

Last Answer : Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.

Explain the difference between a data block, an extent and a segment.

Description : Explain the difference between a data block, an extent and a segment.

Last Answer : A data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings ... that an object takes when grouped together are considered the segment of the database object.

Is it possible to insert comments into sql statements return in the data model editor?

Description : Is it possible to insert comments into sql statements return in the data model editor?

Last Answer : Yes

The join defined by the default data link is an outer join yes or no?

Description : The join defined by the default data link is an outer join yes or no?

Last Answer : Yes

Can a field be used in a report without it appearing in any data group?

Description : Can a field be used in a report without it appearing in any data group?

Last Answer : Yes

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?

Description : For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?

Last Answer : Yes

What are the characteristics of data files?

Description : What are the characteristics of data files?

Last Answer : A data file can be associated with only one database. Once created a data file can't change size. One or more data files form a logical unit of database storage called a tablespace.

What is a data segment?

Description : What is a data segment?

Last Answer : Each non-clustered table has a data segment. All of the table's data is stored in the extents of its data segment. Each cluster has a data segment. The data of every table in the cluster is stored in the cluster's data segment.

How to define data block size?

Description : How to define data block size?

Last Answer : A data block size is specified for each Oracle database when the database is created. A database users and allocated free database space in Oracle data blocks. Block size is specified in init.ora file and cannot be changed latter.

What is data block?

Description : What is data block?

Last Answer : Oracle database's data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk.

Physical Storage of the Data

Description : Physical Storage of the Data

Last Answer : The finest level of granularity of the data base are the data blocks. Data Block :: One Data Block correspond to specific number of physical database space Extent :: Extent is the number of ... Index has index segment that stores data c) Roll Back Segment :: Temporarily store 'undo' information

Table Space,Data Files,Parameter File, Control Files

Description : Table Space,Data Files,Parameter File, Control Files

Last Answer : Table Space :: The table space is useful for storing the data in the database.When a database is created two table spaces are created. a) System Table space :: This data file stores all the tables ... They contain the Db name, name and location of dbs, data files ,redo log files and time stamp.