KPPSC - MCQs

Q A PL /SQL block can return data to SQL* plus through:

  • A Local variables
  • B Bind variables
  • C substitution variables
  • D none of these
Click for more details
KPPSC Lecturer Computer Science 17-11-21 Uploaded By: Amir Iqbal

Q Which of the following SQL* Plus commands can be used to see the compilation errors in a PUSQL code?

  • A TRACE
  • B TRACE
  • C DEBUG
  • D SHOW ERRORS
Click for more details
KPPSC Lecturer Computer Science 17-11-21 Uploaded By: Amir Iqbal

Q In SQL 10 null be evaluated to

  • A FALSE
  • B -1
  • C Null
  • D 10
Click for more details
KPPSC Lecturer Computer Science 17-11-21 Uploaded By: Amir Iqbal

Q Which of the following is illegal?

  • A SELECT SYSDATE ? SYSDATE FROM DUAL;
  • B SELECT SYSDATE ? (SYSDATE ? 2) FROM DUAL;
  • C SELECT SYSDATE ? (SYSDATE + 2) FROM DUAL;
  • D None of these
Click for more details
KPPSC Lecturer Computer Science 17-11-21 Uploaded By: Amir Iqbal

Q Which of the following SQL commands can be used to add data to a database table?

  • A INSERT
  • B ADD
  • C UPDATE
  • D APPEND
Click for more details
KPPSC Lecturer Computer Science 17-11-21 Uploaded By: Amir Iqbal

MCQs Mode

MCQs Categories

Top Contributors

author-thumb

Amir Iqbal

410 MCQ's
author-thumb

Safdar Ali

303 MCQ's
author-thumb

Jawad Bashir

46 MCQ's
author-thumb

Muhammad Asghar khan

0 MCQ's
author-thumb

Farhana

0 MCQ's