nerdexam
PostgreSQL_CE

PGCES-02 · Question #3

Select two correct statements about the command shown below. Note: $ is the command prompt. $ dropdb -U foo foodb

The correct answer is C. This command removes databasefoodb. E. The same process can be performed using the SQL command "DROP DATABASE". See the full explanation below for the reasoning.

Question

Select two correct statements about the command shown below. Note: $ is the command prompt. $ dropdb -U foo foodb

Options

  • AIffoo doesn't have the OS superuser privilege, an error will occur.
  • BIf any table definition remains in databasefoodb, an error will occur.
  • CThis command removes databasefoodb.
  • DThis command removes all of the objects inside the databasefoodb.
  • EThe same process can be performed using the SQL command "DROP DATABASE".

How the community answered

(24 responses)
  • A
    8% (2)
  • B
    4% (1)
  • C
    71% (17)
  • D
    17% (4)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice