Sample Exam Questions

From the objective of OSS-DB Exam Silver - General Knowledge - SQL General Knowledge

Sample Question

2.05

Choose the two descriptions that most accurately
describe DDL and DML?

  1. DDL stands for Data Drop Language, and refers to SQL commands that delete data, such as DROP TABLE or DELETE.
  2. DML is an abbreviation for Data Maintenance Language, and refers to SQL commands used for maintaining databases such as VACUUM and ANALYZE.
  3. DDL stands for Data Definition Language and refers to SQL commands that allow the definition of database objects, such as CREATE TABLE.
  4. DML is an abbreviation of Data Manipulation Language, and refers to SQL commands that perform data manipulation such as SELECT or UPDATE.
  5. DML is an abbreviation of Data Making Language, and refers to SQL commands that create data such as CREATE TABLE and INSERT.

※This sample exam is different from those that appear in the actual OSS-DB Exam.
2018/06/08

Answer and Explanation

SQL statements are generally divided into three types, DDL (Data Definition Language), DML (Data Manipulation Language), and DCL (Data Control Language). DDL refers to SQL commands that define and modify tables such as CREATE TABLE, ALTER TABLE and so forth.
DML refers to SQL commands that performs data manipulation such as SELECT, INSERT, UPDATE, DELETE.
DCL refers to SQL commands that control transactions such as COMMIT and ROLLBACK.

Therefore, the correct answers are C and D