nerdexam
Oracle

1Z0-882 · Question #97

You have a database dev' that contains 15 tables, all of which use the CHARACTER SET utfs' and the COLLATION utfs_general_ci'. You perform the command: ALTER DATABASE dev' CHARACTER SET ='latin'…

The correct answer is E. The statement succeeds and new tables created in this database use the new settings as their. See the full explanation below for the reasoning.

Question

You have a database dev' that contains 15 tables, all of which use the CHARACTER SET utfs' and the COLLATION `utfs_general_ci'. You perform the command:

ALTER DATABASE `dev' CHARACTER SET ='latin' COLLATION='latin1'_swedish_ci' What is the result?

Options

  • AYou get an error because database are not allowed to have CHARACTER SET or COLLATION
  • BYou get an error because the settings for CHARACTER SET and COLLATION attributes do not
  • CYou get an error while trying to change from a more inclusive CHARACTER SET like `utfs to a
  • DYou get an error because changes to the CHARACTER SET or COLLATION attribute can
  • EThe statement succeeds and new tables created in this database use the new settings as their
  • FThe statement succeeds and all of the tables inside the database are converted to user the new

How the community answered

(33 responses)
  • A
    6% (2)
  • C
    6% (2)
  • D
    3% (1)
  • E
    85% (28)

Community Discussion

No community discussion yet for this question.

Full 1Z0-882 Practice