The following table called company is defined as follows:
id | name
----+------------------
1 | Pgsql,inc.
2 | Postgres Co.,Ltd
3 | SQL Company.
Select the most appropriate psql command for generating a text file company.txt with the following
content on the client side.
1,Pgsql \,inc.
2,Postgres Co. \,Ltd
3,SQL Company.

• A. \copycompany TO company.txt CSV
• B. \copycompany TO 'company.txt' DELIMITER ','
• C. \copycompany TO 'company.txt' WITH DELIMITER AS ',';
• D. \copycompany TO "company.txt"
• E. \copycompany TO 'company.txt' WITH ',';

Select the most suitable statement regarding PostgreSQL's pg_hba.conf configuration file.

• A. The authentication settings in the file are evaluated from the top line to the bottom line.
• B. You can set differentauthentications per table.
• C. You can use any number of authentication types on a single line.
• D. krb5 authentication can only be used for local connections.
• E. You cannot set different authentications per user.

The tables "t1" and "t2" are defined in the same way (they have the same data types and column
names). You want to select rows in "t1" which are not in "t2". Select a correct keyword to fill in the blank below.
SELECT * FROM t1 ______ SELECT * FROM t2;

• A. INTERSECT
• B. NAND
• C. EXCEPT
• D. UNION
• E. INTERSECT ALL

Select one incorrect statement concerning the following SQL statement. CREATE OR REPLACE VIEW sales_view AS SELECT * FROM sales_table ORDER BY sales_date DESC LIMIT 10;

• A. Replaces "sales_view" if it already exists.
• B. Defines the view called "sales_view".
• C. Some errors occur when "SELECT * FROM sales_table" is executed after the view is defined.
• D. You can confirm that the "sales_view" has been added by querying the view called "pg_views".
• E. When you 'SELECT' the "sales_view", it displays the first 10 records from the "sales_table" sorted by the "sales_date" column in descending order.

I would like to set the default character encoding for the client to Unicode.
Select the most appropriate configuration parameter in postgresql.conf from those below.

• A. client_encoding = UNICODE
• B. frontend_encoding = UNICODE
• C. backend_encoding = UNICODE
• D. encoding = UTF8
• E. default_encoding = UTF8