※This sample exam is different from those that appear in the actual OSS-DB Exam.
2019/03/04
COPY is a proprietary extension of PostgreSQL that is not found in the standard SQL. You can output the contents of the table to a tab-delimited or comma-delimited text file, or you can import the text file and copy it to the table. By default, tab-delimited files are input and output.
When specifying a file name as an input / output destination of COPY, this is a file on the database server, and administrator authority is required for execution. However, if STDIN or STDOUT is specified, it can be executed with the privileges of general users.
The \copy meta command of psql is an interface connecting the file on the client machine and the COPY command, internally the COPY command is executed.
If you open the output file of the pg_dump command with a text editor, the data of the table with COPY FROM STDIN after CREATE TABLE is described. That is, when restoring, the COPY statement is executed. If - inserts is specified as an option when executing the pg_dump command, the INSERT statement is used instead of the COPY statement. For example, it would be useful when you want to restore with an RDBMS other than PostgreSQL.
Therefore, the correct answers are B and E.