Monday , August 15 2022
Home / cognitive class / Getting Started with PostgreSQL command line Cognitive Class Exam Answers:-

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

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

About Machine Learning

Check Also

Python for Data Science Cognitive Class Exam Answers:-

Course Name:- Python for Data Science Module 1. Python Basics Question 1. What is the …

Leave a Reply

Your email address will not be published.