Welcome to CHOOLS POSTGRE SQL ASSESSMENT (YOU HAVE ONLY 30 MINUTES TO COMPLETE THIS PART [20 Questions]) **** Wishing You All The Best **** Instructions : To start the quiz, please provide your name, email id and phone number. All questions are mandatory* Answering each question is required before going on to the next page of questions. Your response is subject to change at any time. After completed the quiz click the submit button. If, once the time is up, it will be automatically submitted. The report will be mailed to your email address after the quiz is finished. 1. In PostgreSQL, what is the purpose of the pgAdmin tool? Query Optimization Backup and Restore User Authentication Index Management2. Which statement is used to add a new column to an existing table in PostgreSQL? ADD COLUMN CREATE COLUMN ALTER TABLE ADD COLUMN INSERT COLUMN3. Which SQL operator is used for pattern matching in PostgreSQL? LIKE IN BETWEEN EXISTS4. Which statement is used to delete records from a table in PostgreSQL? DELETE REMOVE DROP TRUNCATE5. What does SQL stand for in the context of databases? Simple Query Language Standard Query Language Structured Query Language Systematic Query Language6. In PostgreSQL, how do you start a transaction explicitly? BEGIN; INITIATE TRANSACTION; START TRANSACTION; COMMENCE;7. What is the purpose of the pg_dump utility in PostgreSQL? To optimize query performance To create a new database To back up a PostgreSQL database To load data into a table8. What is the purpose of the VACUUM command in PostgreSQL? To create a virtual column To optimize query performance To reclaim storage occupied by dead tuples To rename a table9. What is the purpose of the SERIALIZE isolation level in PostgreSQL transactions? To lock the entire database To prevent dirty reads To ensure serial execution of transactions To allow uncommitted changes10. Which command is used to create a new database in PostgreSQL? CREATE TABLE CREATE SCHEMA CREATE DATABASE CREATE INSTANCE11. What is the purpose of the SERIAL data type in PostgreSQL? To store sequences of characters To automatically generate unique integer values To store floating-point numbers To represent binary data12. Which of the following is a PostgreSQL data type for storing text of variable length? CHAR VARCHAR TEXT STRING13. Which function is used to find the total number of rows in a table in PostgreSQL? COUNT SUM AVG MAX14. In PostgreSQL, what does the term "pg_ctl" refer to? Query Execution Control Database Control PostgreSQL Control Cluster Control15. In PostgreSQL, what is the purpose of the JOIN clause in a SELECT statement? To filter rows To sort the result set To combine rows from two or more tables To group rows based on a column16. In PostgreSQL, what does the term "pg_hba.conf" refer to? Database Configuration File Host-Based Access Control File Query Logging Configuration PostgreSQL Backup Archive17. What is the purpose of the COPY command in PostgreSQL? To copy data between tables To copy data between databases To copy data between servers To copy data between columns18. Which keyword is used to rename a table in PostgreSQL? MODIFY RENAME ALTER TABLE RENAME TO CHANGE19. Which clause is used to filter the result set in a SELECT statement in PostgreSQL? WHERE FILTER HAVING LIMIT5 out of 4Time is Up!
