Home » MCQs » Oracle MCQs

Oracle Aliases MCQs

Oracle Aliases MCQs: This section contains multiple-choice questions and answers on aliases in Oracle.
Submitted by Anushree Goswami, on June 22, 2022

1. Aliasing can be performed in ____ names in Oracle.

1. Table
2. Column
3. Both A and B
4. None of the above

Answer: C) Both A and B

Explanation:

Aliasing can be performed in both table names and column names in Oracle.

Discuss this Question

---

2. To alias a column or table is to give it a ____ value.

1. Temporary
2. Permanent
3. Random
4. Specific

Answer: A) Temporary

Explanation:

To alias, a column or table is to give it a temporary value.

Discuss this Question

---

3. What is the syntax for column in Oracle Aliases?

1. column_name AS alias_name
2. alias_name AS alias_name
3. column_name AS column_name
4. alias_name AS column_name

Answer: A) column_name AS alias_name

Explanation:

Syntax for column in Oracle Aliases is: column_name AS alias_name.

Discuss this Question

---

4. What is the syntax for table in Oracle Aliases?

1. table_name alias_name
2. alias_name alias_name
3. alias_name table_name
4. Table_name table_name

Answer: A) table_name alias_name

Explanation:

Syntax for table in Oracle Aliases is: table_name alias_name.

Discuss this Question

---

5. What are the parameters in the syntax of Oracle Aliases?

1. Column_name
2. Table_name
3. Alias_name
4. All of the above

Answer: D) All of the above

Explanation:

The parameters in the syntax of Oracle Aliases are -

1. Column_name
2. Table_name
3. Alias_name

Discuss this Question

---

6. A ____ is the original name of the column.

1. Table_name
2. Column_name
3. Alias_name
4. None

Answer: B) Column_name

Explanation:

A column_name is the original name of the column.

Discuss this Question

---

7. A ____ is the original name of the table.

1. Alias_name
2. Table_data
3. Table_column
4. Table_name

Answer: D) Table_name

Explanation:

A table_name is the original name of the table.

Discuss this Question

---

8. An ____ is the temporary name of the table.

1. Alias_name
2. Name_alias
3. Alias_temporary
4. Temporary_alias

Answer: A) Alias_name

Explanation:

An alias_name is the temporary name of the table.

Discuss this Question

---

9. Which of the following is not the parameter in the syntax of Oracle aliases?

1. Alias_name
2. Website_name
3. Column_name
4. Table_name

Answer: B) Website_name

Explanation:

Website_name could be a parameter in the example of oracle aliases but it is not the actual parameter in the syntax of Oracle aliases.

Discuss this Question

---

10. AS component comes under -

1. Column
2. Table
3. Both A and B
4. None of the above

Answer: A) Column

Explanation:

AS component comes under Column in the syntax of column in oracle aliases.

Discuss this Question

---

---