PL/SQL - Data Types MCQ Questions & Answers
Data Types MCQs : This section focuses on "Data Types" in Pl/Sql. These Multiple Choice Questions (MCQ) should be practiced to improve the Pl/Sql skills required for various interviews (campus interview, walk-in interview, company interview), placements, entrance exams and other competitive examinations.
1. Text, graphic images, video clips, and sound waveforms are?
A. Scalar
B. Large Object
C. Composite
D. None of the above
View Answer
Ans : B
Explanation: Pointers to large objects that are stored separately from other data items, such as text, graphic images, video clips, and sound waveforms.
2. Data items that have internal components that can be accessed individually known as?
A. Scalar
B. LOB
C. Composite
D. Reference
View Answer
Ans : C
Explanation: Composite : Data items that have internal components that can be accessed individually. For example, collections and records.
3. NUMBER has a subtype called INTEGER.
A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
View Answer
Ans : A
Explanation: True, NUMBER has a subtype called INTEGER.
4. Signed integer represented in?
A. 8 bits
B. 16 bits
C. 24 bits
D. 32 bits
View Answer
Ans : D
Explanation: Signed integer in range -2,147,483,648 through 2,147,483,647, represented in 32 bits
5. Floating type with maximum precision of 38 decimal digits known as?
A. DECIMAL(prec, scale)
B. DOUBLE PRECISION
C. NUMERIC(pre, scale)
D. BINARY_DOUBLE
View Answer
Ans : C
Explanation: NUMERIC(pre, secale) : Floating type with maximum precision of 38 decimal digits
6. Floating-point type with maximum precision of 63 binary digits known as?
A. INTEGER
B. SMALLINT
C. INT
D. REAL
View Answer
Ans : D
Explanation: REAL : Floating-point type with maximum precision of 63 binary digits
7. CHAR has fixed-length character string with maximum size of?
A. 32,768 bytes
B. 32,767 bytes
C. 65,534 bytes
D. 65,532 bytes
View Answer
Ans : B
Explanation: Fixed-length character string with maximum size of 32,767 bytes
8. What is the advantage of using the %ROWTYPE datatype?
A. It is useful to retrieve an entire row from a table. If you do not use the %ROWTYPE datatype, then you have to declare variables for each column separately
B. It can be used even if data type of the table columns is not known
C. It ensures that data type of the variable changes dynamically if the underlying table is altered
D. All of the above
View Answer
Ans : D
Explanation: All of the above are advantage of using the %ROWTYPE datatype
9. PL/SQL is a transaction processing procedural language that has which of the following advantages?
A. Integration with database
B. Better Performance
C. Higher Productivity
D. All of the above
View Answer
Ans : D
Explanation: All of the above are advantages.
10. The BOOLEAN data type stores logical values that are used in logical operations.
A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
View Answer
Ans : A
Explanation: True, The BOOLEAN data type stores logical values that are used in logical operations.
Discussion