1. Home
  2. Oracle
  3. MySQL Database Administration
  4. 1z0-908
  5. MySQL 8.0 Database Administrator Questions and Answers

Pass the Oracle MySQL Database Administration 1z0-908 Questions and answers with CertsForce

 Oracle Exams      Go to Exam Detail      Get Premium Access
Viewing page 4 out of 5 pages
Viewing questions 31-40 out of questions
Questions # 31:

Examine this MySQL client command to connect to a remote database:

mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=

Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the

SSL/TLS connection to MySQL?

Options:
A.

REQUIRED

B.

VERIFY_CA

C.

VERIFY_IDENTITY

D.

PREFERRED

E.

DISABLED

Questions # 32:

You have a MySQL system with 500 GB of data that needs frequent backups.

You use a mix of MyISAM and InnoDB storage engines for your data. Examine your backup requirement:

    The MySQL system being backed up can never be unavailable or locked to the client applications.

    The recovery from the backup must work on any system.

    Only 1 hour of data can be lost on recovery of the backup.

Which option fulfills all backup requirements?

Options:
A.

Take a physical backup of the MySQL system.

B.

Use the Clone Plugin to copy the data to another MySQL system.

C.

Take a logical backup of the MySQL system.

D.

Take your backup from a slave of the MySQL system.

Questions # 33:

Examine this statement, which executes successfully:

Question # 33

You want to improve the performance of this query:

Question # 33

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

Options:
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);

Questions # 34:

You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.

Examine the output:

Question # 34

What statement is true about the start attempt?

Options:
A.

MySQL server was not started due to a problem while executing process 2732.

B.

MySQL server continued to start up even though another process existed.

C.

systemd found the mysqld service disabled and failed to start it.

D.

systemd waited for 30 seconds before timing out and start up failed.

E.

systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.

Questions # 35:

Examine this statement:

mysql> DROP ROLE r_role1, r_role2;

Which two are true? (Choose two.)

Options:
A.

It fails if any of the roles is specified in the mandatory_roles variable.

B.

You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.

C.

Existing connections can continue to use the roles’ privileges until they reconnect.

D.

You must revoke all privileges from r_role1 and r_role2 before dropping the roles.

E.

It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.

F.

It fails if at least one of the roles does not exist.

Questions # 36:

Your my.cnf file contains these settings:

Question # 36

You want to log queries that looked at a minimum of 5000 records and either took longer than 5 seconds to run or did not use indexes.

Which contains all the settings that you need to add to or modify the slow log configuration?

Options:
A.

min_examined_row_limit=5000

B.

long_query_time=5

log_throttle_queries_not_using_indexes=5

C.

log_throttle_queries_not_using_indexes=5

min_examined_ row_limit=5000

D.

long_query_time=5

E.

long_query_time=5

min_examined_row_limit=5000

F.

log_throttle_queries_not_using_indexes=5

G.

long_query_time=5

log_throttle_queries_not_using_indexes=5

min_examined_row_limit=5000

Questions # 37:

Which three are types of information stored in the MySQL data dictionary? (Choose three.)

Options:
A.

performance metrics

B.

InnoDB buffer pool LRU management data

C.

access control lists

D.

view definitions

E.

server runtime configuration

F.

server configuration rollback

G.

stored procedure definitions

Questions # 38:

Examine these statements and output:

Question # 38

Which statement is true?

Options:
A.

The user is logged in with --user=accounting as an option.

B.

The user is authenticated as the anonymous proxy user ‘’@’%’.

C.

The user is authorized as the accounting@localhost user.

D.

The user is authorized as the rsmith@localhost user.

E.

The user failed to define a username and the connecting username defaulted to ‘’@’%’.

Questions # 39:

You want to dump all databases with names that start with "db".

Which command will achieve this?

Options:
A.

mysqlpump --include-tables=db.% --result-file=all_db_backup.sql

B.

mysqlpump > all_db_backup.sql

C.

mysqlpump --include-databases=db --result-file=all_db_backup.sql

D.

mysqlpump --include-databases=db% --result-file=all_db_backup.sql

Questions # 40:

Which two queries are examples of successful SQL injection attacks? (Choose two.)

Options:
A.

SELECT user,passwd FROM members

WHERE user = ‘?’;INSERT INTO members(‘user’,’passwd’) VALUES

(‘bob@example.com’,‘secret’);--‘;

B.

SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);

C.

SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;

D.

SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;

E.

SELECT email,passwd FROM members

WHERE email = ‘INSERT INTO members(‘email’,’passwd’) VALUES (‘bob@example.com’,

‘secret’);--‘;

F.

SELECT user, phone FROM customers WHERE name = ‘\; DROP TABLE users; --‘;

Viewing page 4 out of 5 pages
Viewing questions 31-40 out of questions