Job offersCompaniesTestsBlogI'm an employerSign upLog in
Home>IT Tests>Questions>Add a unique constraint on the email column while creating the users table in PostgreSQL.

Question from the PostgreSQL test

Add a unique constraint on the email column while creating the users table in PostgreSQL.

Easy

Consider the SQL statement below for creating a table with a constraint in PostgreSQL. Which option correctly adds a unique constraint on the email column while creating the users table?

CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(255)
);
Author: abdelghaniStatus: PublishedQuestion passed 39 times
Edit
0
Community EvaluationsNo one has reviewed this question yet, be the first!
Similar Questions
More questions about PostgreSQL
0
What is the command to back up a database in PostgreSQL?
0
What is the default port number for PostgreSQL database server?
0
Which clause is used in PostgreSQL to filter grouped records that do not meet a certain condition?
0
What does the ACID acronym stand for in the context of PostgreSQL transactions?
0
What PostgreSQL feature allows you to run functions on the database server-side?