The table "t1" is defined by the following SQL statement:

CREATE TABLE t1 (id integer, name varchar(20)); PostgreSQL CE PGCES-02 Exam You want to increase the execution speed of the SQL statement below:

SELECT id, name FROM t1 WHERE id < 123 AND upper(name) = 'MAMMOTH'; Select the most suitable SQL statement to create an index.

Question

The table "t1" is defined by the following SQL statement:

CREATE TABLE t1 (id integer, name varchar(20)); PostgreSQL CE PGCES-02 Exam You want to increase the execution speed of the SQL statement below:

SELECT id, name FROM t1 WHERE id < 123 AND upper(name) = 'MAMMOTH'; Select the most suitable SQL statement to create an index.

Accepted Answer

A. CREATE INDEX t1_idx ON t1 (id,upper(name));

Answer

B. CREATE INDEX t1_idx ON t1 USING HASH (id);

Answer

C. CREATE INDEX t1_idx ON t1 (name);

Answer

D. ALTER TABLE ADD INDEX ON t1 (id,upper(name));

Answer

E. ALTER TABLE ADD INDEX ON t1 (id, name);

The table "t1" is defined by the following SQL statement: CREATE TABLE t1 (id integer, name varchar(20)); PostgreSQL CE PGCES-02 Exam You want to increase the execution speed of the SQL statement…