Which one is NOT a duty of MySQL Administration Points 2 Se

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

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.

Which one is NOT a duty of MySQL Administration? (Points : 2) Server startup and shutdown User account maintenance Log maintenance Running SQL statements Quest

Which one is NOT a duty of MySQL Administration Points 2 Se

Solution

Get Help Now

Submit a Take Down Notice