Which of these modes is a composite server mode?
(a) COMPOSITE
(b) COMPOSITE_MODE
(c) COMPOSITE_SERVER
(d) ANSI
(a) COMPOSITE
(b) COMPOSITE_MODE
(c) COMPOSITE_SERVER
(d) ANSI
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Correct option is (d) ANSI
Easiest explanation: The ‘ANSI’ mode value is a composite mode. It turns on several other mode values like ANSI_QUOTES, PIPES_AS_CONCAT. This makes the server behave much like standard SQL than the default mode.