PostgreSQL Exam PGCES-02 Topic 11 Question 43 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 43
Topic #: 11

[All PGCES-02 Questions]

Select two incorrect statements regarding 'DOMAIN'.

AWhen defining a domain, you can add a default value and constraints to the original data.

BDomain is a namespace existing between databases and objects such as tables.

CA domain is created by 'CREATE DOMAIN'.

DA domain can be used as a column type when defining a table.

ETo define a domain, both input and output functions are required.

Show Suggested Answer

Suggested Answer: A

by Viola at Apr 23, 2023, 07:35 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Hester

6 days ago

Wait, so are we supposed to select the two incorrect statements, or the two correct ones? This domain debate is starting to feel a bit like a domain name dispute!

upvoted 0 times

...

Leigha

8 days ago

I heard the exam committee was really dominating the question selection process this year. Looks like they wanted to make sure we knew our domains inside and out!

upvoted 0 times

...

Yep, B and E are the ones to go with. Domains are all about data types, not namespaces or input/output functions. Though I do wonder if the person who wrote this question was just testing our domain knowledge, or if they were trying to trip us up with some SQL trivia.

upvoted 0 times

Lindsey

8 days ago

I agree, B and E are definitely incorrect. Domains are all about data types.

upvoted 0 times

...

Romana

1 months ago

Hmm, I'm not sure about option A. Can you really add a default value and constraints to a domain? That seems like it would be more of a table-level thing.

upvoted 0 times

Novella

8 days ago

User 2: Yeah, that's right. Those belong at the table level, not the domain level.

upvoted 0 times

...

Gwen

15 days ago

User 1: No, you can't add a default value and constraints to a domain.

upvoted 0 times

...

Delmy

1 months ago

I agree with Leatha. B and E seem to be the incorrect statements here. Domains are not related to namespaces or databases, and you don't need both input and output functions.

upvoted 0 times

...

Gerri

1 months ago

I agree with both of you. Statement B and E are indeed incorrect.

upvoted 0 times

...

Tandra

1 months ago

I believe statement E is incorrect because only input functions are required to define a domain.

upvoted 0 times

...

Leatha

1 months ago

I think options B and E are incorrect. Domains are not namespaces, and you only need an input function to define a domain, not both input and output functions.

upvoted 0 times

Wilson

11 days ago

I think option E is incorrect too. You only need an input function to define a domain.

upvoted 0 times

...

Gail

13 days ago

I agree, option B is incorrect. Domains are not namespaces.

upvoted 0 times

...

Vincent

1 months ago

I think statement B is incorrect because a domain is not a namespace.

upvoted 0 times

...

PostgreSQL Exam PGCES-02 Topic 11 Question 43 Discussion

Contribute your Thoughts:

Hester

Leigha

Arlette

Lindsey

Romana

Novella

Gwen

Delmy

Gerri

Tandra

Leatha

Wilson

Gail

Vincent