Home / Programming MCQs / MySQL MCQs / Question

A

Akshay Kulkarni • 3.46K Points
Extraordinary

Q. Which datatypes are PL/SQL-only datatypes that are more efficient than the SQL datatypes NUMBER or INTEGER for integer arithmetic?

(A) PLS_INTEGER
(B) BINARY_INTEGER
(C) Both A & B
(D) None of the above
Explanation by: Akshay Kulkarni
The BINARY_INTEGER is used to store signed integers. They require less storage than the number values. Arithmetic operations work faster.
PLS_INTEGER have the same advantages as the BINARY_INTEGER.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.