Monday, February 28, 2011

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





3 comments:

  1. • Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing your valuable information and time. Please keep updating. Power Bi Online course HYDERABAD

    ReplyDelete
  2. • Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing your valuable information and time. Please keep updatingMSBI Online Training

    ReplyDelete
  3. Casino - Bracket betting guide for your chance to win
    The Casino is a poormansguidetocasinogambling unique casino that has been around for over a decade. It has https://vannienailor4166blog.blogspot.com/ managed to offer great https://septcasino.com/review/merit-casino/ games such as Blackjack, Roulette and Video Poker,

    ReplyDelete