Understanding Oracle Data Manipulation – Intermediate-Level Quiz

Oracle Data Manipulation Quiz

Test your skills in Oracle SQL as you tackle questions on inserting, updating, deleting, and querying data. This quiz is perfect for both beginners and experienced users looking to refresh their knowledge. Get ready to enhance your understanding of data manipulation in Oracle. Good luck!

1 / 20

______ is used to store, retrieve, modify, delete, insert, and data in a database.

DML

DDL

TCL

DCL

2 / 20

The ALTER command is used to alter the structure of a database. True or False?

True

False

3 / 20

What is the difference between the UPSERT and MERGE statements?

UPSERT is the latest term adopted for MERGE statement, which has turned obsolete

MERGE does INSERT, UPDATE and DELETE, UPSERT does only UPDATE and INSERT

UPSERT is the latest term adopted for MERGE statement, which has turned obsolete

There is no difference

4 / 20

When existing rows in a table are inserted, modified or removed from a table, it is done through a DDL statement. True or False?

True

False

5 / 20

TCL is used to manage transactions in a database. True or False?

True

False

6 / 20

What does ACID mean with respect to relational database?

Atomicity, Consistency, Isolation, Durability

Accuracy, Consistency, Isolation, Database

Atomicity, Concurrency, Isolation, Durability

Accuracy, Concurrency, Isolation, Durability

7 / 20

Which among the following is a common technique for inserting rows into a table?

Manually typing each value into the INSERT clause

Using SET operators

Using SELECT clause

None of the above

8 / 20

Which of the following commands is used to populate table rows with data?

Populate

Insert

Update

Select

9 / 20

What is the highest level of data abstraction in the database management system?

Physical level

Sub level

View level

Logical level

10 / 20

Which of the following best defines a transaction?

A transaction consists of either a collection of DML statements or a DDL or DCL or TCL statement to form a logical unit of work in a database session

A transaction consists of DDL statements on the database schema

A transaction consists of collection of DML and DDL statements in different sessions of the database

A transaction consists of COMMIT or ROLLBACK in a database session

11 / 20

Which of the following is a DML command of Oracle?

CREATE

DELETE

ALTER

DROP

12 / 20

Which of the following objects can be the data source in a MERGE statement?

A sub-query only

A table or a sub-query

A table only

All of the above

13 / 20

DDL stands for Data Demonstration Language. True or False?

True

False

14 / 20

Which of the following columns in a table are not usually updated?

LOB columns in the table

A primary key column which also serves as foreign key reference in another table

Which of the following columns in a table are not usually updated?

All of the above

15 / 20

Delete statements are used to delete records with and without conditions. True or False?

True

False

16 / 20

Which of the following commands / statements would end a transaction?

SELECT

CREATE

SAVEPOINT

COMMIT

17 / 20

_______ is not a transaction management SQL command.

SELECT

COMMIT

SAVEPOINT

ROLLBACK

18 / 20

Which of the following DML commands can be considered to be a hybrid of INSERT and UPDATE in a single statement?

SELECT

INTERSECT

MERGE

INSERT

19 / 20

Which of the following commands prevents other users from making changes to a table?

PROTECT TABLE

LOCK TABLE

SAVE POINT

ROLL BACK

20 / 20

What among the following is true about the DELETE statement?

It is not mandatory to write a WHERE clause with the DELETE statement

DELETE can remove data from multiple tables at a time

The DELETE statement has to be accompanied by the WHERE clause

None of the above

Your score is

The average score is 0%

Oracle Data Manipulation involves performing operations to retrieve, insert, update, and delete data within Oracle databases. It focuses on the use of SQL Data Manipulation Language (DML) commands like SELECT, INSERT, UPDATE, and DELETE.

This topic also covers filtering, sorting, and aggregating data to effectively manage and analyze database content.

This Oracle Data Manipulation quiz is designed for database developers, DBAs, and beginners to learn and apply SQL commands for managing data.