MYSQL DATABASE QUESTIONS 1. \"Instead of using FK constraints on the database, y

Question

MYSQL DATABASE QUESTIONS

1. "Instead of using FK constraints on the database, you can use these ____________ pointers on columns to as pointers back to the PK."

2. A locking problem that can occur when users request data while locking other records that other users are selecting is called a ______________

3. "_________________________ are used to represent other Primative data TYPES like INTEGER, VARCHAR etc. in the definition of variables or columns (ex CREATE TYPE)"

4. What command to you use to mark a successful Point in Time during multiple Updates and Inserts?

a. LOGREAD

b. SAVEPOINT

c. CHECK_BLOCK

d. SETDATA

5. What must be specified for a User Defined Function in the definition line?

a. IF STATEMENT

b. RETURN DATA TYPE

c. OUT VARIABLE

d. BEGIN BLOCK

6. What DATA is being referenced in a UPDATE Trigger when you use NEW?

a. COMPILED DATA

b. UPDATE DATA

c. TABLE DATA

d. COMMIT DATA

Explanation / Answer

3. "_________________________ are used to represent other Primative data TYPES like INTEGER, VARCHAR etc. in the definition of variables or columns (ex CREATE TYPE)"

Answer :-

Datatypes

Explanation :-

Data type defines the type of data a column can contain.

4. What command to you use to mark a successful Point in Time during multiple Updates and Inserts?

Answer :-

B. SAVEPOINT

Explanation :-

The command SAVEPOINT can be used to mark a successful Point in Time during multiple Updates and Inserts.

5. What must be specified for a User Defined Function in the definition line?

Answer :-

D. BEGIN BLOCK

Explanation :-

BEGIN BLOCK is mandatory for a User Defined Function in the definition line.

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

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