Machine Learning Tutorials, Courses and Certifications
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
