Oracle SQL DDL and DML Operations Quiz

Submit

2. Which command is used to modify an existing table's structure in Oracle?

MODIFY TABLE

UPDATE TABLE

ALTER TABLE

CHANGE TABLE

Submit

4. What does the COMMIT command do?

Reverses all changes made in the current transaction

Saves all changes permanently to the database

Pauses the current transaction

Deletes the current transaction

5. DML transactions can be rolled back using the ROLLBACK command. True or False?

True

False

6. In a CREATE TABLE statement, which keyword defines a column that must have a value?

REQUIRED

NOT NULL

MANDATORY

MUST HAVE

7. Which statement is used to remove specific rows from a table?

DROP

DELETE

REMOVE

TRUNCATE

Submit

9. Which of the following is a valid way to insert multiple rows in Oracle?

INSERT INTO table VALUES (1, 'A'), (2, 'B')

INSERT INTO table VALUES (1, 'A'); INSERT INTO table VALUES (2, 'B')

INSERT ALL INTO table VALUES (1, 'A') INTO table VALUES (2, 'B') SELECT * FROM dual

Both b and c are valid

10. Can you use a WHERE clause with an INSERT statement?

True

False

11. Which DDL statement is used to create a new table in Oracle?

CREATE TABLE

INSERT TABLE

ALTER TABLE

DROP TABLE

12. Which constraint ensures that values in a column match values in another table?

PRIMARY KEY

UNIQUE

FOREIGN KEY

CHECK

13. What is a PRIMARY KEY constraint?

Allows duplicate and NULL values

Uniquely identifies each row and prevents NULL values

Only prevents duplicate values

Allows NULL values but prevents duplicates

14. Which keyword is used to add a new column to an existing table?

ALTER TABLE ... ADD

ALTER TABLE ... INSERT

CREATE COLUMN

UPDATE TABLE ... ADD

15. In Oracle, DDL statements are automatically committed. True or False?

True

False

16. What does the UPDATE statement do in Oracle SQL?

Adds new rows to a table

Modifies existing data in a table

Removes all rows from a table

Creates a new table

17. Which DML statement is used to add new rows to a table?

UPDATE

INSERT

SELECT

ALTER

18. What is the difference between DELETE and TRUNCATE?

DELETE removes rows; TRUNCATE removes the table

DELETE is slower; TRUNCATE is faster and cannot be rolled back

TRUNCATE removes rows; DELETE removes the table

Both are identical in functionality

19. Which command removes an entire table and its data from the database?

DELETE

TRUNCATE

DROP TABLE

REMOVE TABLE

20. What is the primary purpose of the ALTER TABLE statement?

Delete table data permanently

Modify table structure or properties

Insert rows into a table

Create a backup of the table

Oracle SQL Associate DDL and DML Operations Quiz

1. The ______ statement retrieves data from one or more tables.

2.

What first name or nickname would you like us to use?

2. Which command is used to modify an existing table's structure in Oracle?

3. The ______ constraint ensures that all values in a column are unique.

4. What does the COMMIT command do?

5. DML transactions can be rolled back using the ROLLBACK command. True or False?

6. In a CREATE TABLE statement, which keyword defines a column that must have a value?

7. Which statement is used to remove specific rows from a table?

8. The ______ clause is used to sort query results in ascending or descending order.

9. Which of the following is a valid way to insert multiple rows in Oracle?

10. Can you use a WHERE clause with an INSERT statement?

11. Which DDL statement is used to create a new table in Oracle?

12. Which constraint ensures that values in a column match values in another table?

13. What is a PRIMARY KEY constraint?

14. Which keyword is used to add a new column to an existing table?

15. In Oracle, DDL statements are automatically committed. True or False?

16. What does the UPDATE statement do in Oracle SQL?

17. Which DML statement is used to add new rows to a table?

18. What is the difference between DELETE and TRUNCATE?

19. Which command removes an entire table and its data from the database?

20. What is the primary purpose of the ALTER TABLE statement?