ADVERTISEMENT
ADVERTISEMENT

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.


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.


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.


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.


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

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.


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.


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.


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.


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.



ADVERTISEMENT
ADVERTISEMENT


Comments and Discussions!



ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT

Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.