From the objective of OSS-DB Exam Silver
- Operation and Management - installation method (how to use database management command)
Sample Question
1.02
Information about the ALTER TABLE statement can be
found from the psql command-Prompt using which of
the following?
- man alter table
- howto alter table
- describe alter table
- help alter table
※This sample exam is different from those that appear in the actual OSS-DB Exam.
2018/04/06
Answer and Explanation
In psql, several meta commands that begin with (backslash, in many Japanese environments) are prepared, and you can check the table list, structure, etc. And you can display help for the command.
To display how to use various commands of SQL, enter \h or \help followed by the SQL command name.
There is no meta command called man, howto, so an error occurs. When describe is executed, it is regarded as a meta command called des and a list of external servers is displayed.
Therefore, the correct answer is D.