MCQ: SQL data types

Which of the following is NOT VALID is PL/SQL
A. Bool boolean;
B. NUM1, NUM2 number;
C. deptname dept.dname%type;
D. date1 date := sysdate
Answer: B

PL/SQL supports datatype(s)
A. Scalar datatype
B. Composite datatype
C. All of the above
D. None of the above
Answer:  C

Find the ODD datatype out
A. VARCHAR2
B. RECORD
C. BOOLEAN
D. RAW
Answer: B

Which of the following is not correct about the |TABLE| datatype ?
A. Can contain any no of columns
B. Simulates a One-dimensional array of unlimited size
C. Column datatype of any Scalar type
D. None of the above
Answer: A

SYSTEM.EFFECTIVE.DATE varaible is
A. Read only
B. Read & Write
C. Write only
D. None of the above
Answer: C

The CHAR and NCHAR data types
(a) have no difference
(b) belong to two different character sets
(c) have different storage requirements
(d) have different storage requirements and retrieval time
ANSWER: B

The wild card character % used in strings meAnswer:
(a) any number of characters
(b) one or more characters
(c) at least one character
(d) at least one alphabet
ANSWER: A

The maximum length of varchar2 when used in PL/SQL block is
A. 16k
B. 32k
C. 4k
D. Either b or c
ANSWER: B

Any value added to NULL gives
A. the value itself.
B. 0
C. NULL
D. Unpredictable
ANSWER: C