Advanced SQL Multiple Choice Questions Test 1 Tests pdf Download

Practice advanced sql multiple choice questions (MCQs), db test 1 online to learn. Practice functions and procedures MCQs questions and answers on functions and procedures, jdbc and java, java database connectivity (jdbc), database triggers with answers. Free advanced sql quiz, online study guide has answer key with choices as persistent storage module, permanent storage module, prepared statement module and prepared storage module of multiple choice questions (MCQ) as in language constructs for procedures, psm stands for to test learning skills. Study to learn functions and procedures quiz questions to practice MCQ based online exam preparation test.

MCQ on Advanced SQL Quiz pdf Download Test 1

MCQ. In language constructs for procedures, PSM stands for

  1. Permanent Storage Module
  2. Persistent Storage Module
  3. Prepared Statement Module
  4. Prepared Storage Module

B

MCQ. A JAVA program that uses JDBC, should determine that information is directly from database system at runtime, to have

  1. Efficient system
  2. Robust system
  3. Active system
  4. Accurate system

B

MCQ. Database system compiles query when it is

  1. Executed
  2. Initialized
  3. Prepared
  4. Invoked

C

MCQ. A trigger can be dropped by using command

  1. drop trigger
  2. alter trigger drop
  3. define drop trigger
  4. declare drop trigger

A

MCQ. A Java application program does not include declarations for

  1. Data stored in database
  2. Data retrieved of database
  3. Data executed
  4. Data manipulated

A