Check Point Certified Automation Specialist (CCAS) — Question 25

PostgreSQL is a powerful, open source relational database management system. Check Point offers a command for viewing the database to interact with Postgres interactive shell. Which command do you need to enter the PostgreSQL interactive shell?

Answer options

• A. mysql_client cpm postgres
• B. mysql -u root
• C. psql_client cpm postgres
• D. psql_client postgres cpm

Correct answer: C

Explanation

The correct command to enter the PostgreSQL interactive shell is 'psql_client cpm postgres', which is specifically designed for PostgreSQL. The other options do not reflect the correct command syntax for PostgreSQL and either refer to MySQL or are incorrectly formatted.