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

Arlette

2 hours ago

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

...

Romana

16 days 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

...

Delmy

18 days 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

19 days ago

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

upvoted 0 times

...

Tandra

20 days ago

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

upvoted 0 times

...

Leatha

23 days 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

...

Vincent

24 days ago

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

upvoted 0 times

...