wk1 database

Question 1

Generally speaking, where can the MySQL error log be found, within a modern cPanel & WHM installation?

Select one:

a. /var/log/mysqld.log
b. /var/lib/mysql/$hostname.err
c. I don’t know.
d. /var/log/mysql.log
e. /var/log/mysql/$hostname.err

Answer 1

/var/log/mysqld.log

Question 2

Which of the following options most accurately indicates the method used to provide access to SQLite databases?

Select one:

a. Using a daemon process.
b. Using the mysql client.
c. Using a database file.
d. Using a persistent socket.

Answer 2

Using a database file.

Question 3

When entering only “mysql” at the command line, from which file will credentials (and host if using a remote database server) be read?

Select one:

a. /etc/.my.cnf
b. /etc/my.cnf
c. /root/.my.cnf
d. /root/my.cnf
e. I don’t know.

Answer 3

/root/.my.cnf

Question 4

Which command would you run to view any MySQL or MariaDB queries that are currently running?

Select one:

a. mysqladmin stat
b. mysqlcheck proc
c. mysqlcheck stat
d. mysqladmin proc
e. I don’t know.

Answer 4

mysqladmin proc

Question 5

What year was MySQL created?

Select one:

a. 1989
b. 1998
c. 1995
d. 1993
e. I don’t know.

Answer 5

1995

Question 6

Which of the following is NOT a syntax constraint enforced by a default MySQL/MariaDB installation?
Select one:
a. Query line termination
b. Case-sensitive queries
c. Quote-enclosed string values
d. Special character escaping 
e. I don't know.

Answer 6

Case-sensitive queries

Question 7

Which of the following MySQL configuration paths is loaded first?
Select one:
a. /etc/my.cnf
b. /usr/my.cnf 
c. I don't know.
d. /usr/etc/.my.cnf
e. /root/.my.cnf

Answer 7

/etc/my.cnf

Question 8

With which storage engine does MariaDB intend to a crash-safe replacement for MyISAM?
Select one:
a. InnoDB 
b. Cassandra
c. XtraDB
d. I don't know.
e. Aria

Answer 8

Aria

Question 9

Which of the following is a legitimate, drop-in replacement for MySQL?
Select one:
a. MariaDB 
b. XtraDB
c. I don't know.
d. MaxDB
e. Oracle

Answer 9

MariaDB

Question 10

The table that contains privilege and access information is named

???

and exists within the database named {=mysql|system|config|options}.

Answer 10

user|priv|grants|secure

Question 11

In what scenarios would the InnoDB engine prove more beneficial than MyISAM?

Select one:

a. When transactions are required
b. When you want table locking
c. When Insert, Update, and Delete queries are frequent
d. When Select queries are frequent
e. I don’t know.

Answer 11

When transactions are required, When Insert, Update, and Delete queries are frequent