Which of the following is the correct syntax to create a domain named positive_int that only allows positive integers?

easy📝 Syntax Q12 of 15

PostgreSQL - Advanced Features

Which of the following is the correct syntax to create a domain named positive_int that only allows positive integers?

ACREATE DOMAIN positive_int AS integer CHECK (VALUE > 0);

BCREATE DOMAIN positive_int TYPE integer WHERE VALUE > 0;

CCREATE DOMAIN positive_int AS integer VALIDATE (VALUE > 0);

DCREATE DOMAIN positive_int AS integer IF VALUE > 0;

Step-by-Step Solution

Solution:

Step 1: Recall the correct syntax for domain creation
The syntax is: CREATE DOMAIN name AS base_type CHECK (condition);
Step 2: Match the syntax with options
CREATE DOMAIN positive_int AS integer CHECK (VALUE > 0); matches the correct syntax with CHECK and VALUE keyword.
Final Answer:
CREATE DOMAIN positive_int AS integer CHECK (VALUE > 0); -> Option A
Quick Check:
CREATE DOMAIN ... AS ... CHECK(...) [OK]

Quick Trick: Use CHECK with VALUE keyword in domain creation [OK]

Common Mistakes:

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free