PostgreSQL Exam PGCES-02 Topic 7 Question 31 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 31
Topic #: 7

[All PGCES-02 Questions]

Select two suitable statements regarding creating a new table.

AThere is no upper limit to the number of columns in a table.

BA newly created table is empty and has 0 rows.

CYou can only use alphabetic characters for a table name.

DThe row name must be within 16 characters.

EThe SQL 'CREATE TABLE' statement is used to create a new table.

Show Suggested Answer

Suggested Answer: A

by Simona at Aug 19, 2022, 09:27 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Crissy

7 days ago

I think A is also a correct statement. There's no hard limit on the number of columns in a table, as long as you don't exceed the overall database size limit. But B and E are the clear winners here.

upvoted 0 times

...

Glory

11 days ago

Haha, imagine trying to create a table with just 16 character row names. That would be a nightmare! But B and E are definitely the right answers here.

upvoted 0 times

...

Lonna

14 days ago

I'm not sure about the upper limit on columns, but I know the table name can use alphanumeric characters, not just alphabetic. And the row name length limit is definitely longer than 16 characters.

upvoted 0 times

...

Ivan

16 days ago

B and E seem correct to me. A table is definitely created empty with 0 rows, and the CREATE TABLE statement is used to create a new table.

upvoted 0 times

Shelia

5 days ago

B and E are correct. A table starts empty with 0 rows.

upvoted 0 times

...

Ronald

20 days ago

I'm not sure about statement A. Isn't there a limit to the number of columns a table can have?

upvoted 0 times

...

Meghann

21 days ago

I agree with you, Trinidad. Statement A makes sense because a table can have as many columns as needed, and statement B is true because a new table starts with 0 rows.

upvoted 0 times

...

Trinidad

22 days ago

I think statement A and B are suitable for creating a new table.

upvoted 0 times

...