Exam Prep Questions

1:Where would you look for your database's national character set?
  • A. V$NLS_PARAMETERS

  • B. V$NLS_VALID_VALUES

  • C. V$PARAMETERS

  • D. V$VALID_VALUES

A1: Answer A is correct; V$NLS_PARAMETERS will give you your national character set. Answer B is incorrect; V$NLS_VALID_VALUES will give you all the valid values that you can have for your national character set but not the current value. Answer C is incorrect; V$PARAMETERS will not provide you with information on your NLS parameters. Answer D is incorrect because V$VALID_VALUES is not an Oracle 9i data dictionary view.
2:Where would you look for the list of all valid values for the database's NLS parameters?
  • A. V$NLS_PARAMETERS

  • B. V$NLS_VALID_VALUES

  • C. V$PARAMETERS

  • D. V$VALID_VALUES

A2: ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.