Accessing SQL From a Programming Language MCQ

Test your knowledge with important Accessing SQL From a Programming Language MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Accessing SQL From a Programming Language MCQs at Bissoy

• Which package comprises of the core JDBC API?
  ক

  java.sql

  খ

  java.database

  গ

  sql.java

  ঘ

  java.relation
• How many different types of drivers are present in JDBC?
  ক

  1

  খ

  2

  গ

  3

  ঘ

  4
• State true or false: Recursive queries are permitted in SQL
  ক

  True

  খ

  False
• A _________ is a statement that the system executes whenever a database is modified
  ক

  Trigger

  খ

  Function

  গ

  Package

  ঘ

  Protocol
• The part of SQL that deals with the SQL supports constructs is called as _______
  ক

  Persistent construct dealer

  খ

  Persistent storage module

  গ

  Persistent supports center

  ঘ

  Primary storage medium
• Which of the following are not a part of PL/SQL
  ক

  Triggers

  খ

  Packages

  গ

  Functions

  ঘ

  None of the mentioned
• State true or false: Developers cannot write their own functions into SQL
  ক

  True

  খ

  False
• What is the full form of JDBC?
  ক

  Java Database Connectivity

  খ

  Java Database Co-Operation

  গ

  JSP Database Committee

  ঘ

  Java Database Creation
• Which of the following is/are a function of dynamic SQL?
  ক

  Allowing a program to construct an SQL query in a character string

  খ

  Submitting the query

  গ

  Retrieving the result into the program variables a tuple at a time

  ঘ

  All of the mentioned