20 multiple-choice questions about PostgreSQL SQL syntax

In PostgreSQL, which command is used to create an index on a table?

• INDEX

• CREATEINDEX

• ADDINDEX

• MAKEINDEX

What SQL command is used to rename a table in PostgreSQL?

• RENAMETABLE

• ALTERTABLERENAME

• RENAME

• CHANGETABLE

What is the purpose of the PostgreSQL `LIMIT` clause?

• To specify the maximum number of rows to return in a query result.

• To filter rows based on a condition.

• To sort rows in ascending order.

• To aggregate data across rows.

What keyword is used to specify the values to be inserted into a table in PostgreSQL?

• VALUES

• INTO

• INSERTVALUES

• ADDVALUES

What is the purpose of the PostgreSQL SELECT statement?

• To insert new data into a table.

• To delete rows from a table.

• To update existing data in a table.

• To retrieve data from a table.

In PostgreSQL, what clause is used to filter rows when retrieving data from a table?

• WHERE

• FILTER

• SELECT

• LIMIT

Which keyword is used to update data in a PostgreSQL table?

• CHANGE

• UPDATE

• MODIFY

• SET

In PostgreSQL, which keyword is used to specify a condition for filtering rows in a SELECT statement?

• FILTER

• WHERE

• HAVING

• CONDITION

What is the correct syntax for defining a primary key constraint in PostgreSQL?

• CONSTRAINT pk_name PRIMARY KEY(columns)

• PRIMARY KEY CONSTRAINT pk_name(columns)

• ADD CONSTRAINT pk_name PRIMARY KEY(columns)

• PRIMARY KEY(columns)

Which SQL statement is used to remove data from a PostgreSQL table?

• REMOVE

• DELETE

• DROP

• ERASE