MYSQL DATABASE QUESTIONS 1. The first SQL statement processed in an Embedded SQL

Question

MYSQL DATABASE QUESTIONS

1. The first SQL statement processed in an Embedded SQL program so that the SQL specific information can be identified should be ________________ .

2. ________________ is when a SELECT is performed twice on a connection and it doesn't present the same picture of the database (Isolation Level)

3. "When you store multiple values in a format like this {746584753,3806348096,09846904} in a cell of a column (ie Social Insurance Numers) this is called a _________________"

4. ______________ must be included in an Embedded SQL program to use the native SQLCODE error functionality (INCLUDE statement)

5. The amount of data that is locked on a ROW or TABLE is called the _______________

6. A lock of this type ____________ ensures that the application can read the table; other applications can read the table but not update it

Explanation / Answer

Answers

2. ________________ is when a SELECT is performed twice on a connection and it doesn't present the same picture of the database (Isolation Level)

Read Isolation Level

3. "When you store multiple values in a format like this {746584753,3806348096, 09846904} in a cell of a column (ie Social Insurance Numbers) this is called a _________________"

Enum

4. ______________ must be included in an Embedded SQL program to use the native SQLCODE error functionality (INCLUDE statement)

Embedded SQL Tool kit

5. The amount of data that is locked on a ROW or TABLE is called the

Data concurrency

6. A lock of this type ____________ ensures that the application can read the table; other applications can read the table but not update it

LOCK TABLE

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.