Which one is NOT a duty of MySQL Administration? (Points : 2) Server startup and

Question

Which one is NOT a duty of MySQL Administration? (Points : 2)        Server startup and shutdown
       User account maintenance
       Log maintenance
       Running SQL statements Question 2.2. (TCO A) How do you display the current system variable values? (Points : 2)        SHOW SYSTEM;
       SHOW VARIABLES;
       SHOW VALUES;
       SHOW SYSTEM VARIABLES; Question 3.3. (TCO A) How do you display the global variable values? (Points : 2)        SHOW SYSTEM;
       SHOW VARIABLES;
       SHOW VALUES;
       SHOW GLOBAL VARIABLES; Question 4.4. (TCO A) Which statement enables you to rename tables or modify their structure? (Points : 2)        MODIFY TABLE
       ALTER TABLE
       CHANGE TABLE
       CREATE TABLE Question 5.5. (TCO A) Which is the statement that will rename the instructor table to a new name? (Points : 2)        ALTER TABLE instructor RENAME TO instr;
       RENAME instructor instr;
       This task is not available in MySQL.
       ALTER TABLE instructor TO instr; Question 6.6. (TCO A) Review the following SQL statement:

CHECKSUM TABLE instructor;

What is going to be the result if there is no table named instructor? (Points : 2)        CHECKSUM value is zero.
       CHECKSUM value is negative.
       CHECKSUM value is NULL.
       An error occurs. Which one is NOT a duty of MySQL Administration? (Points : 2)        Server startup and shutdown
       User account maintenance
       Log maintenance
       Running SQL statements

Explanation / Answer

1.1 Which one is NOT a duty of MySQL Administration?

a) log maintainance

2.2 How do you display the current system variable values?

show variables

3.3 How do you display the global variable values?

       SHOW GLOBAL VARIABLES;

4.4 Which statement enables you to rename tables or modify their structure?

       ALTER TABLE

5.5 Which is the statement that will rename the instructor table to a new name?

       This task is not available in MySQL.

6.6. CHECKSUM TABLE instructor;

       CHECKSUM value is NULL.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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