Cpuqa

I have no idea what these are.

cPanel & WHM Administrator - Core Curriculum

Databases Administration in WHM

Introduction quiz:

Which of the following statements are true about MyISAM? (Select all that apply)

It implements indexes and locking.
It is the default storage engine on older versions of MySQL.

The second question was to match terms, on the screen.

True/False: By default, you can connect to a MySQL/MariaDB database from anywhere with the correct username and password and see all your databases.

False

Managing Users and Databases Quiz:

The first question is to arrange the mysql terms.

True/False: If you have prefixing turned on in Tweak Settings, the database management tools in WHM will enforce it.

False

True/False: The customer should always be aware of their MySQL root password, and will make use of it frequently.

False

Networking Quiz

The Additional Access Hosts feature in WHM creates grants (select all that apply)

when you create new cPanel accounts (after setting up an additional access host)
when you click on the link at the bottom of the page

Remote MySQL server environment connections can be set up via a cPanel & WHM environment by using what WHM feature?

Manage MySQL Profiles

Remote MySQL Profiles can be used to set up what kind of relationships?

1-to-1 (1:1) only

Repairs, Restores, Backups and Upgrades Quiz

True/False: WHM contains a feature to allow you to import a SQL dump from MySQL into Postgresql. False

True/False: EasyApache needs to be run after upgrading MySQL/MariaDB. True

What types of tables can you repair through WHM? MyISAM

Unit test

These may be out of order, or different questions might be present"

When using the database mapping tool, you select the user from the drop down list, but must type the name of the database into a text field.

(Unknown if correct) Which of the following do you need to know to set up a Remote MySQL Server? (Select all that apply.)

-remote SSH port
-authentication details necessary to obtain root SSH on the server
-remote server address

Match each advanced database term with its definition.

storage engine - the software used by a database to manage the underlying data
myisam   -   the basic storage engine for mysql.
SQL   -   how users get data into and out of a database.
innodb -   the advanced storage engine for mysql.
index   -   a special data structure that makes lookups on large tables faster.

The Additional Access Hosts feature in WHM creates grants (select all that apply)

-when you create new cPanel accounts (after setting up an additional access host)
-when you click on the link at the bottom of the page

True/False: If you have databases included in quotas (via Tweak Settings), cPanel & WHM will prevent data from being entered into a database whose associated user is over quota.

False

True/False: You can export all your MySQL databases in one go with phpMyAdmin.

-True

True/False: The “Manage Databases” page in WHM allows you to rename your databases, but still keep the existing users and their grants/permissions.

-True

Match each database related term with its definition.

table   -   the relation in relational databases; it represents a group of similar objects
database -   a structured set of data
entries   -   a "row" in the table; it represents an instance of the object defined by the table.
locking   -   marking a table or row so that only one process accesses it at a time
querying   -   asking the database to find some information for you.
grants   -   how permissions are handled
field   -   a “column” in the table; it represents a trait of the object defined by the table.

Select the true statement about Remote MySQL Servers.

Remote MySQL Servers can reduce load on the WHM Server.

Which of the following statements are true about MyISAM? (Select all that apply)

-It is the default storage engine on older versions of MySQL.
-It implements indexes and locking.

What types of tables can you repair through WHM?

MyISAM

Match each database with its description.

information schema   -   a database that contains information about all the other databases, but exists only in memory.
whmxfer   -   a database that stores information on transfers done with the Transfer Tool in WHM
leechprotect   -   a database that stores hit counters for a feature that limits excessive activity on password protected directories
cphulkd   -   a database that contains information for brute force attack detection
modsec   -   a database that stores the hits list for the WHM Mod Security Tools interface
eximstats   -   a database that contains data for the Mail Statistics Summary page in WHM
roundcube   -   a database that stores contacts for round cube email accounts

Match each database basics term with its definition.

query   -   When you ask a Database Management System to find some information for you.
entry   -   Represents a single instance of an object in a database. A "row".
field   -   Represents a trait of the object defined by the table. A "column".
database   -   A structured set of data.
grants   -   How permissions are handled inside a database.
locking   -   Marking a table or row so that only one process can access it at a time.
table   -   Represents a group of similar objects in a database. The relation in "relational databases".

What is an InnoDB data dictionary?

-a part of the InnoDB storage engine that maps data to it the file it’s located in

cPanel Simplifies the default MySQL grants by applying grants per Database Grants for the same user from different hosts are Applied uniformly

The Additional Access Hosts feature in WHM creates grants that are similar to the grants in which cPanel Interface?

-Remote MySQL >> Add Access Hosts