Infosys Certified PostgreSQL Administrator
Practice with real exam-pattern questions for Infosys Certified PostgreSQL Administrator. Each question includes a detailed explanation to help you understand the concept, not just memorise the answer. Try 10 questions free — no login required.
Full question bank for this exam + 1,357+ others. Cancel anytime.
Join Premium10 Infosys Certified PostgreSQL Administrator practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified PostgreSQL Administrator certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
WAL stands for:
- ✓
Write Ahead Log
Correct - B
Write Ahead List
- C
Write Anywhere List
- D
Write Anywhere Logging
- ✓
- Question 2
Which of the following utility is used to perform SQL dump operations?
- ✓
pg_dump
Correct - B
pg_sql
- C
pg_backup
- D
pg_upgrade
- ✓
- Question 3
Which of the following methods will provide a faster upgradation?
- ✓
pg_dump
Correct - B
pg_dumpall
- C
pg_upgrade
- D
replication
- ✓
- Question 4
Which of the following command helps in backing up of information of tablespaces and roles?
- ✓
pg_dump
Correct - B
pg_dumpall
- C
backup
- D
Roles and tablespace information cannot be backed up
- ✓
- Question 5
Which of the following is/are default tablespace(s) in PostgreSQL?
- ✓
pg_default
Correct - B
pg_logical
- C
pg_global
- D
pg_stat
- ✓
- Question 6
By default, in what subdirectory of the database data directory are WAL logs contained in PostgreSQL 12?
- ✓
pg_global
Correct - B
pg_default
- C
pg_log
- D
pg_wal
- ✓
- Question 7
Which of the following statements are TRUE regarding pg_dumpall? (Choose any 2 options)
- ✓
pg_dumpall helps in dumping contents of each database present in a cluster
Correct - B
pg_dumpall helps in dumping contents of a particular database alone
- C
pg_dumpall dumps information of roles, tablespaces and tables
- D
pg_dumpall dumps information of tables alone
- E
pg_dumpall is for dumping information of large databases only
- ✓
- Question 8
As a PostgreSQL DBA, which of the following command(s) can be used to establish a connection to database Engineering?
(i) postgres=# \c Engineering;
(ii) $ psql -h localhost -p 5432 -U postgres Engineering
- ✓
only (i)
Correct - B
either (i) or (ii)
- C
only (ii)
- D
neither (i) nor (ii)
- ✓
- Question 9
Assume that we have a CSV file – “CarDetails.csv” in D drive. The contents of the file are as shown below.
A table “Car” is created successfully in PostgreSQL database with following CREATE Command.
CREATE TABLE Car
(
Model_ID numeric NOT NULL,
Model_Name character varying,
Manufacturer character varying,
Year_Of_Release numeric,
CONSTRAINT Car_pkey PRIMARY KEY (Model_ID)
)
If we want only the following data to be imported into Car table, what is the command to be executed?
- ✓
COPY car(model_id,model_name,manufacturer) FROM 'D:\CarDetails.csv' DELIMITER ',' CSV HEADER;
Correct - B
COPY car FROM 'D:\CarDetails.csv' DELIMITER ',' CSV HEADER;
- C
The given requirement cannot be met using COPY command
- D
COPY car() FROM 'D:\CarDetails.csv' DELIMITER ',';
- ✓
- Question 10
Which of the following statement is TRUE regarding the streaming replication? (Choose any 3 options)
- ✓
Master can directly copy the logs to the standby server
Correct - B
The standby server connects to the master to receive the WAL chunks
- C
The streaming of WAL chunks need not wait for the WAL file to be filled
- D
The streaming of WAL can happen only after the WAL file is filled
- E
By default the replication mode will be synchronous
- ✓
More in IMS Academy
Infosys Certified WebSphere Application Server 8.5 Administrator
Infosys Certified Windows 11 Administrator - Associate
Infosys Certified Windows Server 2022 Administrator – Associate
Pay once. Clear every cert this year.
One subscription, full Telegram channel access, every PDF posted during your membership.
- Full access to all 1,357+ certifications
- Monthly updated question banks
- Telegram private channel access
- Cancel anytime
- Everything in Monthly
- Save ₹2,100 vs monthly billing
- Priority answer key requests
- Best for increasing DQ score fast
- Everything in Quarterly
- Lifetime channel access — no renewals
- All future certifications included
- Priority response from admin team
Common questions, straight answers.
A monthly-updated Telegram channel where we post real exam-pattern question banks and detailed answer keys for 1,357+ Infosys Lex certifications. You join once, you get every PDF posted during your membership.
Right after payment on our Graphy page, you'll receive a private invite link to the Telegram channel. Access is instant — usually under 30 seconds.
We compile question banks from the actual Lex test pattern, sourced and verified by 180K+ community members who've recently cleared these exams. Match rate is consistently 85–95%.
Every single month. When Infosys rolls out new versions of certifications, we post updated dumps within 7–10 days. You'll see channel activity weekly.
Clearing certifications is one of the highest-weighted DQ factors. Members typically clear 3–5 certifications in their first 3 months, which moves DQ scores up by a full band.