OCP-1Z0-053-V12.02-466题

466.What can you determine about the following linguistic sorts based only on their names?

1. GERMAN

2. FRENCH_M

A. 1 is a monolingual sort.

B. 2 is a monolingual sort.

C. 1 is case insensitive.

D. Both 1 and 2 are case insensitive.

E. Case sensitivity is unknown.

Answer: A

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/server.112/e41084/functions113.htm#SQLRF51562

1是monolingual collations。

2应该是multilingual collations。

For monolingual collations, for example FRENCH, the prefix length is typically 1000 characters. For multilingual collations, for example GENERIC_M, the prefix is typically 500 characters. The exact length may be lower or higher depending on the collation and the characters contained in char.