Multiple choice

The temporary name of a table or a column is known as _____.

  1. view

  2. object

  3. synonym

  4. alias
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Alias is the temporary name given to a table or a column. An alias is quite useful where the name of the table is lengthy and the name has to be written more than once in a statement. A table alias is generally a word with one or two letters that can substitute a table name. For example, if the name of a table is sales_1999, then instead of writing sales_1999 everytime it is required, we can create an alias an use it. Consider the following statement: Select s.data from sales_1999 where s.no=101 in the above statement. S is an alias and it is used as a substitution for the word sales_1999.

Keep practicing — related questions