Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?

• A./usr/bin
• B./var/lib/mysql
• C./usr
• D./usr/mysql
• E./etc/my.cnf

Comment: *

Name: *

Email: *

Verification: *

Examine this statement, which executes successfully:

You want to improve the performance of this query:

Which change enables the query to succeed while accessing fewer rows?

• A.ALTER TABLE world.city ADD SPATIAL INDEX (Name);
• B.ALTER TABLE world.city ADD SPATIAL INDEX (Population);
• C.ALTER TABLE world.city ADD INDEX (Population);
• D.ALTER TABLE world.city ADD INDEX (Name);
• E.ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
• F.ALTER TABLE world.city ADD FULLTEXT INDEX (Population);

Comment: *

Name: *

Email: *

Verification: *

Examine this query and output:

Which two statements are true? (Choose two.)

• A.The countrytable is accessed as the first table, and then joined to the city table.
• B.The optimizer estimates that 51 rows in the countrytable have Continent = ‘Asia’.
• C.35 rows from the city table are included in the result.
• D.It takes more than 8 milliseconds to sort the rows.
• E.The query returns exactly 125 rows.

Comment: *

Name: *

Email: *

Verification: *

Examine this list of MySQL data directory binary logs:
binlog.000001
binlog.000002
.....
binlog.000289
binlog.000300
binlog.000301
binlog.index
Now examine this command, which executes successfully:
mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql
Which two are true? (Choose two.)

• A.All binary logs are backed up and then deleted.
• B.All databases, excluding master metadata, are backed up to the output file.
• C.All details regarding deleted logs and master metadata are captured in the output file.
• D.All databases are backed up to the output file.
• E.All binary logs are deleted from the master.
• F.All non-active binary logs are removed from the master.

Comment: *

Name: *

Email: *

Verification: *

A valid raw backup of the shop.customers MyISAM table was taken.
You must restore the table. You begin with these steps:
1. Confirm that secure_file_priv='/var/tmp'
2. mysql> DROP TABLE shop.customers;
3. shell> cp /backup/customers.MY* /var/lib/mysql/shop/
Which two actions are required to complete the restore? (Choose two.)

• A.mysql> IMPORT TABLE FROM /var/tmp/customers.sdi
• B.mysql> ALTER TABLE shop.customers DISCARD TABLESPACE
• C.shell> cp /backup/customers.frm /var/lib/mysql/shop/
• D.shell> cp /backup/customers.sdi /var/lib/mysql/shop/
• E.mysql> SOURCE '/var/tmp/customers.sdi'
• F.mysql> ALTER TABLE shop.customers IMPORT TABLESPACE
• G.shell> cp /backup/customers.sdi /var/tmp
• H.mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi

Comment: *

Name: *

Email: *

Verification: *