Oracle - Tables and Views MCQ

Oracle – Tables and Views

1 / 21

1. What is the primary purpose of an Oracle table?

To create reports

To perform complex calculations

To store structured data

To enforce data integrity

2 / 21

2. Which SQL statement is used to create a new table in Oracle?

INSERT INTO

CREATE TABLE

SELECT FROM

ALTER TABLE

3 / 21

3. In Oracle, what is a database view?

A stored procedure

A virtual table based on the result of an SQL query

A physical table

A primary key constraint

4 / 21

4. What does the SQL statement “CREATE VIEW” do in Oracle?

Creates a virtual table based on an SQL query

Modifies table structure

Inserts data into a table

Deletes a table

5 / 21

5. Which SQL command is used to add a new column to an existing Oracle table?

CREATE TABLE

INSERT INTO

DROP TABLE

ALTER TABLE

6 / 21

6. In Oracle, what is the purpose of a primary key constraint in a table?

To ensure the uniqueness of values in a column

To store complex calculations

To allow duplicate values in a column

To create virtual tables

7 / 21

7. What is the primary role of the SQL statement “ALTER TABLE” in Oracle?

To modify the structure of an existing table

To insert data into a table

To delete a table

To create a new table

8 / 21

8. In Oracle SQL, how can you delete a table and all its data?

Using the ALTER TABLE statement

Using the DELETE statement

Using the CREATE TABLE statement

Using the DROP TABLE statement

9 / 21

9. Which SQL command is used to delete a table and all its data in Oracle?

DROP TABLE

CREATE TABLE

ALTER TABLE

INSERT INTO

10 / 21

10. In Oracle, what is the purpose of a foreign key constraint in a table?

To ensure the uniqueness of values in a column

To create virtual tables

To allow duplicate values in a column

To establish a relationship between two tables

11 / 21

11. What SQL statement is used to create a new table in Oracle?

SELECT INTO

INSERT INTO

CREATE TABLE

ALTER TABLE

12 / 21

12. Which Oracle SQL statement is used to create a new table based on the structure and data of an existing table?

CREATE TABLE AS

ALTER TABLE

DROP TABLE

SELECT INTO

13 / 21

13. In Oracle, what is the primary purpose of the CREATE TABLE AS statement?

To delete a table and its data

To insert data into a table

To modify the structure of an existing table

To create a new table based on the structure and data of an existing table

14 / 21

14. What SQL statement is used to modify the structure of an existing table in Oracle?

ALTER TABLE

DROP TABLE

CREATE TABLE

INSERT INTO

15 / 21

15. In Oracle SQL, how can you remove an existing table and all its data?

Using the CREATE TABLE statement

Using the DELETE statement

Using the ALTER TABLE statement

Using the DROP TABLE statement

16 / 21

16. Which Oracle SQL statement is used to create a temporary table that is visible to all sessions?

GLOBAL TEMPORARY TABLE

LOCAL TEMPORARY TABLE

ALTER TABLE

CREATE TABLE AS

17 / 21

17. In Oracle, what is the purpose of a GLOBAL TEMPORARY TABLE?

To create a permanent table

To create a temporary table that is visible to all sessions

To insert data into a table

To modify the structure of an existing table

18 / 21

18. What SQL statement is used to create a temporary table that is only visible to the current session in Oracle?

CREATE TABLE AS

GLOBAL TEMPORARY TABLE

LOCAL TEMPORARY TABLE

ALTER TABLE

19 / 21

19. In Oracle SQL, what is the primary purpose of a LOCAL TEMPORARY TABLE?

To create a temporary table that is only visible to the current session

To create a permanent table

To insert data into a table

To delete a table and its data

20 / 21

20. What does the CREATE VIEW statement in Oracle SQL allow you to do?

Create a virtual table based on the result of an SQL query

Delete a table and its data

Insert data into a table

Modify the structure of an existing table

21 / 21

21. Which SQL statement is used to create a new table in Oracle?

CREATE TABLE

INSERT INTO

ALTER TABLE

SELECT INTO

Your score is

Oracle – Tables and Views MCQ