Course Name :- Create Tables and Load Data in PostgreSQL using pgAdmin
Create Tables and Load Data in PostgreSQL using pgAdmin Cognitive Class Final Exam Answers:-
Question 1.When loading data into a PostgreSQL table, what is the default delimiter for data files?
- Quotation marks
Question 2.When creating a new table in a database using pgAdmin, on which tab of the Create Table dialog box do you specify data types?
Question 3.Which tool can you use to both design and create a Postgres database?
- ERD Tool
- Query Tool
Question 4. When you run SQL queries in the pgAdmin Query Tool, you can always edit the results. (T/F)
Question 5.You created a new table in your database and later decide that you want to ensure that one of the fields always contains a value. What should you do?
- Turn on the Primary key option for the field.
- Turn on the Not NULL option for the field.
- There is no need to change anything in your table definition to make this happen.
- None of the above.