embedded sql

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

In some languages such as Cobol, semicolon is replaced with

In some languages such as Cobol, semicolon is replaced with
  • A. EXEC
  • B. START-EXEC
  • C. END-EXEC
  • D. SQL-EXEC
  • Correct Answer: Option C

Iteration through all tuples can be performed in embedded statements by using the

Iteration through all tuples can be performed in embedded statements by using the
  • A. Select operation
  • B. Define operation
  • C. Fetch operation
  • D. Commit operation
  • Correct Answer: Option C

A query string can be constructed and prepared at runtime, using a statement of form

A query string can be constructed and prepared at runtime, using a statement of form
  • A. EXEC PREP
  • B. EXEC SQL PREPARE
  • C. SQL PREPARE
  • D. EXEC DEFINE PREPARE
  • Correct Answer: Option B

A relation is conceptually a set, tuples of result of a query are in some

A relation is conceptually a set, tuples of result of a query are in some
  • A. Physical order
  • B. Random order
  • C. Fixed physical order
  • D. NO order
  • Correct Answer: Option C

If SQL query results in an error, database system stores an error diagnostic in SQL

If SQL query results in an error, database system stores an error diagnostic in SQL
  • A. Communication area variables
  • B. Connection area variables
  • C. SQL area variables
  • D. Programming area variables
  • Correct Answer: Option A