What Do You Know About Data Manipulation Language?
A data manipulation language (or DML) is a family of syntax elements used in a database to select, insert, delete and update data. Take this quiz to find out what you truly know about DML.
- 1.
Which of the following SQL statements is used to retrieve and manipulate data?
- A.
TCL
- B.
DML
- C.
DDL
- D.
DCL
Correct Answer
B. DMLExplanation
DML stands for Data Manipulation Language and is used to retrieve and manipulate data in SQL. It includes statements such as SELECT, INSERT, UPDATE, and DELETE, which are used to query and modify data in a database. DML statements allow users to retrieve specific data from tables, insert new data, update existing data, and delete unwanted data.Rate this question:
-
- 2.
Which of these DML commands is used to retrieve rows from a table?
- A.
Select
- B.
Retrieve
- C.
Commit
- D.
Save point
Correct Answer
A. SelectExplanation
The correct answer is "select." This DML command is used to retrieve rows from a table. It allows you to specify the columns and conditions to filter the data you want to retrieve. The "retrieve" option is not a valid DML command. "Commit" is used to save changes made to the database, and "save point" is used to mark a specific point in a transaction for rollback purposes.Rate this question:
-
- 3.
This command modifies one or more data.
- A.
Select
- B.
Modify
- C.
Update
- D.
Change
Correct Answer
C. UpdateExplanation
The command "update" is the correct answer because it is commonly used to modify one or more data in a database. It is specifically designed for making changes to existing data, allowing users to update the values of specific columns or rows in a table. The other options, "select," "modify," and "change," do not specifically indicate the action of modifying data and are not commonly used for this purpose.Rate this question:
-
- 4.
Which of these commands adds one or more records to a database?
- A.
Insert
- B.
Delete
- C.
Vector
- D.
Update
Correct Answer
A. InsertExplanation
The command "insert" is used to add one or more records to a database. This command allows new data to be inserted into a specific table and creates a new record or row in the database with the provided information. It is commonly used when there is a need to add new data or information into an existing database. The "insert" command is essential for maintaining and updating the content of a database.Rate this question:
-
- 5.
The SELECT statement embedded within another SELECT statement is called...
- A.
Subject
- B.
Data
- C.
Sublet
- D.
Subselect
Correct Answer
D. SubselectExplanation
A subselect is a SELECT statement that is embedded within another SELECT statement. It is used to retrieve data from one or more tables and is typically used as a subquery within the WHERE or HAVING clause of the outer query. The subselect allows for more complex and specific queries by providing a way to filter and manipulate data before it is returned in the outer query's result set.Rate this question:
-
- 6.
The ____ command removes one or more record from the database.
- A.
Delete
- B.
Remove
- C.
Vector
- D.
Select
Correct Answer
A. DeleteExplanation
The "delete" command is used to remove one or more records from the database. This command is commonly used in database management systems to delete specific data entries or entire rows from a table. It allows users to remove unwanted or outdated information from the database, ensuring data integrity and maintaining an accurate and up-to-date database.Rate this question:
-
- 7.
Which of these statements is a limited DML statement?
- A.
Delete
- B.
Insert
- C.
Select
- D.
Update
Correct Answer
C. SelectExplanation
A limited DML statement refers to a statement that does not modify or change data in the database. Among the given options, the "select" statement is the only one that retrieves data from the database without making any changes to it. The "delete," "insert," and "update" statements, on the other hand, are DML statements that respectively remove data, add new data, and modify existing data in the database. Therefore, the correct answer is "select."Rate this question:
-
- 8.
All of these DML statements are supported fully in PL/SQL except...
- A.
Select
- B.
Call
- C.
Update
- D.
Delete
Correct Answer
B. CallExplanation
The SELECT, UPDATE, and DELETE statements are all fully supported in PL/SQL. However, the CALL statement is not supported in PL/SQL. The CALL statement is used to invoke a stored procedure or function in other programming languages such as Java or C#. In PL/SQL, stored procedures and functions are invoked using the EXECUTE statement.Rate this question:
-
- 9.
Which of the following is not a DML command?
- A.
Update
- B.
Select
- C.
Delete
- D.
Drop
Correct Answer
D. DropExplanation
The DROP command is not a Data Manipulation Language (DML) command. DML commands are used to manipulate data within a database, such as updating, selecting, or deleting records. The DROP command, on the other hand, is a Data Definition Language (DDL) command used to remove objects from the database, such as tables or indexes.Rate this question:
-
- 10.
Which of the following is returned by the MIN function?
- A.
Minute
- B.
Smallest value
- C.
Vector
- D.
Largest value
Correct Answer
B. Smallest valueExplanation
The MIN function is used to find the smallest value in a set of values. Therefore, the correct answer is "smallest value".Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Sep 01, 2023Quiz Edited by
ProProfs Editorial Team -
Dec 17, 2017Quiz Created by
Cripstwick
Back to top