Oracle - Language Fundamentals MCQ

Oracle – Language Fundamentals

1 / 25

1. What does SQL stand for in the context of Oracle Database?

Scripted Query Language

Structured Query Language

Sequential Query Language

Simple Query Language

2 / 25

2. Which SQL statement is used to retrieve data from a table?

SELECT

DELETE

INSERT

UPDATE

3 / 25

3. What is the primary purpose of the WHERE clause in an SQL query?

To specify the order of results

To group rows together

To filter rows based on conditions

To join multiple tables

4 / 25

4. Which data type is used to store fixed-length character strings in Oracle?

CHAR

VARCHAR2

NUMBER

DATE

5 / 25

5. In SQL, which keyword is used to add new rows to a table?

DELETE

UPDATE

SELECT

INSERT

6 / 25

6. What SQL statement is used to modify existing data in a table?

SELECT

DELETE

UPDATE

INSERT

7 / 25

7. What does the SQL statement DELETE do?

Creates a new table

Removes data from a table

Updates data in a table

Adds new data to a table

8 / 25

8. What is the purpose of the SQL JOIN operation?

To filter rows in a table

To group rows together

To combine rows from multiple tables

To sort rows in a table

9 / 25

9. Which SQL clause is used to sort the result set in ascending order?

SORT BY

ORDER BY

ASCENDING

SORT ASC

10 / 25

10. In SQL, what is the purpose of the GROUP BY clause?

To filter rows based on conditions

To group rows with the same values

To sort rows in descending order

To perform calculations on columns

11 / 25

11. What does the SQL HAVING clause do?

Combines rows from multiple tables

Sorts rows in a table

Filters rows in a table

Filters grouped rows based on conditions

12 / 25

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

CREATE TABLE

INSERT

DELETE

SELECT

13 / 25

13. In SQL, what is the purpose of the UNIQUE constraint?

To create an index on a column

To ensure that values in a column are unique

To group rows together

To specify a default value for a column

14 / 25

14. What is the primary role of the PRIMARY KEY constraint in Oracle?

To ensure that values in a column are unique

To create an index on a column

To filter rows based on conditions

To specify a default value for a column

15 / 25

15. What does the SQL INDEX do?

Updates data in a table

Improves the speed of data retrieval

Adds a new row to a table

Removes a row from a table

16 / 25

16. Which SQL statement is used to retrieve all columns from a table?

GET COLUMNS

SHOW COLUMNS

SELECT *

SELECT COLUMN

17 / 25

17. What is the purpose of the SQL DISTINCT keyword?

To perform calculations on columns

To add new columns to a result set

To filter rows based on conditions

To delete duplicate rows from a result set

18 / 25

18. In SQL, what is the result of the COUNT(*) function?

The sum of all values in a column

The maximum value in a column

The number of rows in a table

The average value in a column

19 / 25

19. Which SQL clause is used to specify conditions for retrieving rows from a table?

SELECT

ORDER BY

WHERE

FROM

20 / 25

20. What is the purpose of the SQL BETWEEN operator?

To filter rows with values within a specified range

To compare two columns

To check if a value exists in a column

To sort rows in ascending order

21 / 25

21. Which SQL statement is used to add a new column to an existing table?

ALTER TABLE

ADD COLUMN

INSERT COLUMN

CREATE COLUMN

22 / 25

22. What is the primary role of the FOREIGN KEY constraint in Oracle?

To specify a default value for a column

To ensure that values in a column are unique

To create an index on a column

To enforce referential integrity between tables

23 / 25

23. Which SQL statement is used to remove a table and all its data from the database?

ERASE TABLE

DROP TABLE

DELETE TABLE

REMOVE TABLE

24 / 25

24. What does the SQL TRUNCATE TABLE statement do?

Modifies the structure of a table

Adds a new column to a table

Renames a table

Removes all data from a table

25 / 25

25. In SQL, what is the purpose of the ROLLBACK statement?

Ends a transaction and makes changes permanent

Removes a column from a table

Adds a new column to a table

Undoes changes made in a transaction

Your score is

0%

Oracle – Language Fundamentals MCQ