Oracle - ALIASES DISTINCT Clause MCQ

Oracle – ALIASES DISTINCT Clause

1 / 20

1. What is an alias in Oracle SQL used for?

To give a table or column a temporary name

To update existing data

To delete a table from the database

To add a new column to a table

2 / 20

2. In Oracle SQL, what is the purpose of the DISTINCT keyword?

To perform mathematical calculations

To retrieve unique values from a column

To filter rows based on a condition

To join multiple tables

3 / 20

3. Which SQL keyword is used to assign an alias to a table or column in Oracle SQL?

SELECT

FROM

WHERE

4 / 20

4. What does the DISTINCT clause do in an Oracle SQL query?

Removes duplicate rows from the result set

Performs mathematical calculations

Filters rows based on a condition

Groups rows by a specific column

5 / 20

5. In Oracle SQL, what does an alias provide for a table or column?

A data type

A permanent name in the database

An index

A temporary name that can be used in queries

6 / 20

6. Which statement accurately describes the function of an alias in Oracle SQL?

It enforces data integrity constraints

It is used to delete data

It makes queries more readable and concise

It is required for all table and column references

7 / 20

7. What is the primary purpose of using DISTINCT in an Oracle SQL query?

To eliminate duplicate rows from the result set

To filter rows based on a condition

To join multiple tables

To perform mathematical calculations

8 / 20

8. Which SQL keyword is used to give a table or column a temporary name in Oracle SQL?

WHERE

FROM

SELECT

9 / 20

9. In Oracle SQL, what does the DISTINCT keyword do when used in a query?

It joins multiple tables

It retrieves unique values from a column

It filters rows based on a condition

It performs mathematical calculations

10 / 20

10. What is the role of an alias in Oracle SQL?

To enforce primary key constraints

To permanently rename a table

To provide a temporary name for a table or column

To filter rows based on a condition

11 / 20

11. Which SQL keyword allows you to rename a table or column temporarily in Oracle SQL?

WHERE

FROM

SELECT

12 / 20

12. In Oracle SQL, what is the primary function of the DISTINCT keyword in a query?

To calculate the average value

To retrieve unique values from a column

To join tables

To filter rows based on a condition

13 / 20

13. What is the purpose of using an alias in Oracle SQL?

To make queries more readable and concise

To perform complex calculations

To enforce data integrity constraints

To eliminate duplicate rows

14 / 20

14. Which SQL keyword is used to specify an alias for a table or column in Oracle SQL?

SELECT

WHERE

FROM

15 / 20

15. In Oracle SQL, what is the primary role of an alias for a table or column?

To create a new table

To enforce foreign key constraints

To provide a temporary name for reference in queries

To permanently rename a table

16 / 20

16. What does the DISTINCT clause do when used in an Oracle SQL query?

Removes duplicate rows from the result set

Filters rows based on a condition

Performs mathematical calculations

Groups rows by a specific column

17 / 20

17. Which SQL keyword is used to assign an alias to a table or column in Oracle SQL?

SELECT

FROM

WHERE

18 / 20

18. In Oracle SQL, what is the primary function of the DISTINCT keyword in a query?

To perform mathematical calculations

To retrieve unique values from a column

To filter rows based on a condition

To delete rows from a table

19 / 20

19. What is the primary purpose of using an alias in Oracle SQL?

To enforce data integrity constraints

To eliminate duplicate rows

To perform complex calculations

To make queries more readable and concise

20 / 20

20. In Oracle SQL, what does an alias provide for a table or column?

A permanent name in the database

A temporary name for reference in queries

An index

A data type

Your score is

Oracle – ALIASES DISTINCT Clause MCQ