PostgreSQL Exam PGCES-02 Topic 8 Question 70 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 70
Topic #: 8

I would like to insert the contents of the text file users.dat into the table t1 using psql.

Contents of text file users.dat: Definition of table t1: CREATE TABLE t1 (uname TEXT, pass TEXT, id INTEGER); Select the most appropriate input from those below.

A\copy t1 FROM users.dat WITH DELIMITER ':'

B\copy t1 TO users.dat WITH DELIMITER ':'

CINSERT INTO t1 FROM file('users.dat');

DINSERT INTO t1 SELECT uname, pass, id FROM file('users.dat');

E\insert t1 FROM users.dat WITH DELIMITER ':';

Show Suggested Answer

Suggested Answer: A, E

by Juan at Sep 11, 2024, 02:43 PM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Cora

18 days ago

I heard the table t1 is where they keep all the secret agent passwords. Time to get hacking!

upvoted 0 times

...

Avery

21 days ago

B) is the opposite of what we want to do. We're trying to import data, not export it.

upvoted 0 times

...

Giovanna

24 days ago

E) is just plain wrong. \\insert isn't even a valid psql command.

upvoted 0 times

Stephen

1 days ago

A) \\copy t1 FROM users.dat WITH DELIMITER ':'

upvoted 0 times

...

Weldon

1 months ago

D) looks good, but it's not the most appropriate answer. We need a way to directly import the file, not select from it.

upvoted 0 times

Cassie

13 days ago

B) \copy t1 TO users.dat WITH DELIMITER ':'

upvoted 0 times

...

Adell

15 days ago

A) \copy t1 FROM users.dat WITH DELIMITER ':'

upvoted 0 times

...

Jesus

1 months ago

A) is the correct answer. The \\copy command is used to import data from a file into a table, not the other way around.

upvoted 0 times

Clorinda

15 days ago

A) is the correct answer. The \\copy command is used to import data from a file into a table, not the other way around.

upvoted 0 times

...

Mertie

2 months ago

I'm not sure about the answer. I think it might be D) INSERT INTO t1 SELECT uname, pass, id FROM file('users.dat').

upvoted 0 times

...

Jade

2 months ago

I agree with Mariann. Option A seems to be the most appropriate choice for inserting the contents of the text file into the table.

upvoted 0 times

...

Mariann

2 months ago

I think the correct answer is A) \\copy t1 FROM users.dat WITH DELIMITER ':' because it is used to copy data from a file into a table in psql.

upvoted 0 times

...