Getting Started with PostgreSQL command line Cognitive Class Exam Answers:-

Related Articles

Data Analysis with Python Cognitive Class Exam Answers:-

January 25, 2022

Data Science Tools Cognitive Class Exam Answers:-

January 25, 2022

Node-RED: basics to bots Cognitive Class Exam Answers:-

January 24, 2022

Course  Name :- Getting Started with PostgreSQL command line

Getting Started with PostgreSQL command line Cognitive Class Final Exam Answers:-

Question 1. Which one of these statements is incorrect?

• PostgreSQL is a free open source object-relational database management system.
• PostgreSQL originates from the POSTGRES project at the University of Maryland more than 30 years ago.
• PostgreSQL is a popular database choice for OLTP, data analytics, and geographic information systems.
• None of the above statements

Question 2.Which tool can you use to both design and create a Postgres database?

• pgAdmin
• psql
• ERD Tool
• Query Tool

Question 3.After restoring a database using pg_restore command, which of the following items are recreated in the database?

• Data types
• Tables
• Data
• All of the above

Question 4.When you first connect to a PostgreSQL database server, which database do you connect to?

• The template0 database.
• The default database.
• No database. You must create a new database before you can connect one.
• None of the above statements

Question 5.Which one of the following commands can be used to create .dump backup file of a table from your database in PostgreSQL command line interface of Cloud IDE?

Tip: Try to run and validate the options for a table of Sakila Database in Cloud IDE terminal.

• pg_dump –username=postgres –host=localhost –password –dbname=database_name –table=table_name -F c > backup.dump
• pg_dump –username=postgres –host=localhost –password –dbname=database_name –table=table_name -F p > backup.dump
• pg_dump –username=postgres –host=localhost –password –dbname=database_name –table=table_name -F t > backup.dump
• None of the above