Which of the following is the correct SQL syntax to create a subscription named 'sub1' connecting to a publisher at 'host=192.168.1.10' for publication 'pub1'?

easy📝 Syntax Q3 of 15

PostgreSQL - Advanced Features

ACREATE SUBSCRIPTION sub1 CONNECTION 'host=192.168.1.10' PUBLICATION pub1;

BCREATE SUBSCRIPTION sub1 CONNECTION 'host=192.168.1.10' PUBLICATIONS pub1;

CCREATE SUBSCRIPTION sub1 CONNECTION 'host=192.168.1.10' FOR PUBLICATION pub1;

DCREATE SUBSCRIPTION sub1 CONNECTION 'host=192.168.1.10' PUBLICATION 'pub1';

Step-by-Step Solution

Solution:

Step 1: Recall correct syntax for CREATE SUBSCRIPTION
The syntax is CREATE SUBSCRIPTION name CONNECTION 'conninfo' PUBLICATION pubname;
Step 2: Check each option for syntax errors
CREATE SUBSCRIPTION sub1 CONNECTION 'host=192.168.1.10' PUBLICATION pub1; matches syntax exactly; B uses plural PUBLICATIONS (wrong); C uses FOR PUBLICATION (wrong); D quotes publication name (not required).
Final Answer:
CREATE SUBSCRIPTION sub1 CONNECTION 'host=192.168.1.10' PUBLICATION pub1; -> Option A
Quick Check:
Correct CREATE SUBSCRIPTION syntax = CREATE SUBSCRIPTION sub1 CONNECTION 'host=192.168.1.10' PUBLICATION pub1; [OK]

Quick Trick: Use PUBLICATION (singular) without quotes in CREATE SUBSCRIPTION [OK]

Common Mistakes:

Using PUBLICATIONS instead of PUBLICATION
Adding FOR before PUBLICATION
Quoting publication name incorrectly

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

Which of the following is the correct SQL syntax to create a subscription named 'sub1' connecting to a publisher at 'host=192.168.1.10' for publication 'pub1'?

Step 1: Recall correct syntax for CREATE SUBSCRIPTION

Step 2: Check each option for syntax errors

Final Answer:

Quick Check:

Want More Practice?