Oracle SQL Multiple Choice Questions and Answers on DML Commands for Freshers

1. The language used application programs to request data from the DBMS is referred to as __________

a) DML
b) DDL
c) Query language
d) All of the Mentioned

Answer: a

Explanation: Data Manipulation Language (DML) statements are used for managing data in database. DML commands are not auto-committed. It means changes made by DML command are not permanent to database, it can be rolled back.

2. In SQL, which of the following is not a data Manipulation Language Commands?

a) Delete
b) Truncate
c) Update
d) Create

Answer: b

Explanation: The SQL TRUNCATE TABLE command is used to delete complete data from an existing table.You can also use DROP TABLE command to delete complete table but it would remove complete table structure form the database and you would need to re-create this table once again if you wish you store some data.

3. Which of the following is not a type of SQL statement?

a) Data Manipulation Language (DML)
b) Data Definition Language (DDL)
c) Data Control Language (DCL)
d) Data Communication Language (DCL)

Answer: d

Explanation: Data Communication Language (DCL) is not a type of SQL statement.

4. Which of the following is not included in DML (Data Manipulation Language)

a) INSERT
b) UPDATE
c) DELETE
d) CREATE

Answer: d

Explanation: The CREATE TABLE statement is used to create a table in a database.Tables are organized into rows and columns; and each table must have a name.

5. TRUNCATE statement in SQL is a –

a) DML statement
b) DDL statement
c) DCL statement
d) TCL statement

Answer: b

Explanation: The SQL TRUNCATE TABLE command is used to delete complete data from an existing table.so its a DDL statement.

6. In SQL, which command is used to add new rows to a table?

a) Alter Table
b) Add row
c) Insert
d) Append

Answer: c

Explanation: Alter Table will change the structure of the table.

7. Stack is also called __________

a) First In First Out (LIFO)
b) Last In First Out (FIFO)
c) First In Last Out (FILO)
d) First Come First Served (FCFS)

Answer: c

Explanation: Stack works on the First In Last Out.

8. A table that displays data redundancies yields ____________ anomalies.

a) Update
b) Insertion
c) Deletion
d) All of the Mentioned

Answer: d

Explanation: Table that displays data redundancies yields update, insertion, deletion anomalies.

9. A type of query that is placed within a WHERE or HAVING clause of another query is called

a) Master query
b) Sub query
c) Super query
d) Multi-query

Answer: b

Explanation: Sub-query that is placed within a WHERE or HAVING clause of another query.

10. The three language components of a database management system (DBMS) like DDL, DCL, DML.
Two different types of people (users and practitioners) are concerned with them. Which of them do users of a DBMS usually deal with?

a) DDL
b) DML
c) DDL and DCL
d) DCL and DML

Answer: b

Explanation: The users and practitioners are concerned with only Data manipulation language component of DBMS.