embedded and dynamic sql

mcqspedia.com has 5 Question/Answers about Topic embedded and dynamic sql

General purpose programming languages such as COBOL and ADA is classified as

General purpose programming languages such as COBOL and ADA is classified as
  • A. server language
  • B. client language
  • C. host language
  • D. referential language
  • Correct Answer: Option C

In database management system, if cursor is to be moved to next rows in queries result then command is classified as

In database management system, if cursor is to be moved to next rows in queries result then command is classified as
  • A. OPEN CURSOR command
  • B. FETCH command
  • C. UPDATE command
  • D. CLOSE CURSOR command
  • Correct Answer: Option B

Variable in DBMS used to communicate error conditions between database management system and program are

Variable in DBMS used to communicate error conditions between database management system and program are
  • A. SQLCODE
  • B. SQLSECTION
  • C. SQLSTATE
  • D. both b and c
  • Correct Answer: Option D

Type of iterator which is used to list types of attributes that are included in query result is called

Type of iterator which is used to list types of attributes that are included in query result is called
  • A. positional iterator
  • B. named iterator
  • C. unnamed iterator
  • D. non-positioned iterator
  • Correct Answer: Option A

In database management systems, record which contains all data regarding tuples of database is called

In database management systems, record which contains all data regarding tuples of database is called
  • A. statement record
  • B. environment record
  • C. description record
  • D. connection record
  • Correct Answer: Option C