DBMS-Oracle-DML

What is the primary purpose of Data Manipulation Language (DML) in Oracle?

• To define database structure

• To manage user access control

• To manipulate data stored in the database

• To create database backups

Which SQL statement is used to retrieve data from one or more tables in Oracle?

• CREATE

• INSERT

• SELECT

• UPDATE

What is the purpose of the SQL INSERT statement in Oracle?

• To update existing records

• To delete data from a table

• To add new records to a table

• To create a new table

Which Oracle SQL statement is used to modify existing data in a table?

• ALTER

• DELETE

• INSERT

• UPDATE

What is the result of executing the Oracle SQL DELETE statement without a WHERE clause?

• All rows in the table are deleted.

• The table structure is deleted.

• An error occurs.

• No rows are deleted.

In Oracle, which SQL statement is used to remove a table's structure and data?

• DROP

• DELETE

• TRUNCATE

• REMOVE

What is the purpose of the Oracle SQL MERGE statement?

• To combine two tables into one

• To update or insert data based on a condition

• To create a new table from existing ones

• To perform a cross join between tables

Which clause is used to filter rows when using the Oracle SQL DELETE statement?

• WHERE

• FROM

• HAVING

• SELECT

In Oracle, which SQL statement is used to remove all rows from a table but retain the table structure?

• TRUNCATE

• DELETE

• DROP

• PURGE

What is the purpose of the Oracle SQL COMMIT statement?

• To roll back a transaction

• To save changes made in a transaction

• To delete data from a table

• To retrieve data from a table