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


2. Data items that have internal components that can be accessed individually known as?

A. Scalar
B. LOB
C. Composite
D. Reference

View Answer


3. NUMBER has a subtype called INTEGER.

A. TRUE
B. FALSE
C. Can be true or false
D. Can not say

View Answer


4. Signed integer represented in?

A. 8 bits
B. 16 bits
C. 24 bits
D. 32 bits

View Answer


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


6. Floating-point type with maximum precision of 63 binary digits known as?

A. INTEGER
B. SMALLINT
C. INT
D. REAL

View Answer


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


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


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


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





Discussion


* You must be logged in to add comment.