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

What will happen if the following statement is executed;

DELETE FROM employees where department_id  = &deptID;
COMMIT;

It will prompt for the department ID but transaction cannot be committed

It will raise error because DML statements cannot use substitution variables

It will prompt for the department ID to be deleted from the user and delete the record with the given department ID

None of the above

2 / 20

The DROP command is used to drop a comment in the data dictionary. True or False?

True

False

3 / 20

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

PROTECT TABLE

LOCK TABLE

SAVE POINT

ROLL BACK

4 / 20

_______ is not a transaction management SQL command.

SELECT

COMMIT

SAVEPOINT

ROLLBACK

5 / 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

6 / 20

In interactive data input, terminal commands are used to;

Select one or multiple inputs

Enter new data

Add and delete data

Detect and delete errors in data input

7 / 20

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

True

False

8 / 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

9 / 20

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

True

False

10 / 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

11 / 20

The _____ SQL command is used to delete a table from a database.

Truncate

Purge

Drop

Delete

12 / 20

What would be the output of the following command;

INSERT INTO EMPLOYEES (employee_id  , first_name , job_id) VALUES (51003,'BRUCE','CLERK');

It will throw an 'Constraint violated' ORA error

It will insert a new row with 51003 BRUCE CLERK values

It will throw an ORA error as there cannot be another BRUCE who is a CLERK

None of the above

13 / 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

14 / 20

What is true about the UPDATE command?

It can update unlimited rows at a time in bulk

It can update only one row at a time

It can update only 100 rows at a time

None of the above

15 / 20

What will happen if the following statement is executed;

DELETE FROM employees where department_id  = &deptID;
COMMIT;

It will prompt for the department ID but transaction cannot be committed

It will raise error because DML statements cannot use substitution variables

It will prompt for the department ID to be deleted from the user and delete the record with the given department ID

None of the above

16 / 20

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

Populate

Insert

Update

Select

17 / 20

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

True

False

18 / 20

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

SELECT

CREATE

SAVEPOINT

COMMIT

19 / 20

DDL stands for Data Demonstration Language. True or False?

True

False

20 / 20

Oracle raises exception if any of the data contained in the insert statement violates the constraint. True or False?

True

False

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.