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.
- Table
- Column
- Both A and B
- 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.
- Temporary
- Permanent
- Random
- 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?
- column_name AS alias_name
- alias_name AS alias_name
- column_name AS column_name
- 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?
- table_name alias_name
- alias_name alias_name
- alias_name table_name
- 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?
- Column_name
- Table_name
- Alias_name
- All of the above
Answer: D) All of the above
Explanation:
The parameters in the syntax of Oracle Aliases are -
- Column_name
- Table_name
- Alias_name
Discuss this Question
6. A ____ is the original name of the column.
- Table_name
- Column_name
- Alias_name
- 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.
- Alias_name
- Table_data
- Table_column
- 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.
- Alias_name
- Name_alias
- Alias_temporary
- 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?
- Alias_name
- Website_name
- Column_name
- 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 -
- Column
- Table
- Both A and B
- None of the above
Answer: A) Column
Explanation:
AS component comes under Column in the syntax of column in oracle aliases.
Discuss this Question