PostgreSQL_CE
PGCES-02 · Question #16
PGCES-02 Question #16: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #16. The question stem and answer options stay visible for context.
Question
Select the correct result generated by execution of the following SQL statements: CREATE TABLE log (id int, message TEXT, logtime TIMESTAMP); CREATE TABLE log_01 () INHERITS (log); INSERT INTO log_01 VALUES (1, 'error', CURRENT_TIMESTAMP); SELECT * FROM log;
Options
- AFirst 'CREATE TABLE' generates a syntax error.
- BSecond 'CREATE TABLE' generates a syntax error.
- C'INSERT' statement generates an error stating that the number of columns and values do not
- D'SELECT' statement returns 0 rows, and exits successfully.
- E'SELECT' statement returns 1 row, and exits successfully.
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.