PostgreSQL_CE
PGCES-02 · Question #20
PGCES-02 Question #20: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #20. The question stem and answer options stay visible for context.
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.
Options
- ACREATE INDEX t1_idx ON t1 (id,upper(name));
- BCREATE INDEX t1_idx ON t1 USING HASH (id);
- CCREATE INDEX t1_idx ON t1 (name);
- DALTER TABLE ADD INDEX ON t1 (id,upper(name));
- EALTER TABLE ADD INDEX ON t1 (id, name);
Unlock PGCES-02 to see the answer
You've previewed enough free PGCES-02 questions. Unlock PGCES-02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.