1Z0-908 Exam PDF [2024] Tests Free Updated Today with Correct 142 Questions [Q61-Q78] – IT Certification Exam Questions & Answers

Rate this post

1Z0-908 Exam PDF [2024] Tests Free Updated Today with Correct 142 Questions

Oracle 1Z0-908 Exam Preparation Guide and PDF Download

Oracle 1z1-908 exam is a comprehensive exam that covers all aspects of MySQL 8.0 database administration. 1Z0-908 exam evaluates the candidate’s ability to install, configure, and maintain MySQL 8.0 databases. It also tests their knowledge of backup and recovery techniques, performance tuning, and security management. 1Z0-908 exam is challenging and requires a thorough understanding of MySQL 8.0 database administration.

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

SELECT user,passwd FROM members
WHERE user = ‘?’;INSERT INTO members(‘user’,’passwd’) VALUES
(‘[email protected]’,’secret’);–‘;

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

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

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

SELECT email,passwd FROM members
WHERE email = ‘INSERT INTO members(’email’,’passwd’) VALUES (‘[email protected]’,
‘secret’);–‘;

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

QUESTION 62
You are upgrading a MySQL instance to the latest 8.0 version.
Examine this output:

You plan to add this parameter to the configuration: innodb_directories=’/innodb_extras’ Which statement is true?

It defines all innodb tablespace options relative to a starting parent directory.

It is not necessary because innodb_data_home_dir is already defined.

It allows scanning of other locations to discover more innodb tablespaces.

It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.

It adds more temporary workspace in addition to the innodb_tmpdir location.

Explanation
https://dev.mysql.com/doc/refman/8.0/en/innodb-moving-data-files-offline.html

QUESTION 63
Examine this command and output:

Which two options will improve the security of the MySQL instance? (Choose two.)

Remove group read/write privileges from the private_key.pem file.

Remove world read privileges from the server-cert.pem certificate file.

Change the group ownership of the mysql directory to the mysql user group.

Remove world read privileges from the public_key.pem file.

Change the parent directory owner and group to mysql.

Remove the world read/execute privilege from the accounting directory.

QUESTION 64
Which three requirements must be enabled for group replication? (Choose three.)

slave updates logging

semi-sync replication plugin

primary key or primary key equivalent on every table

binary log checksum

binary log ROW format

binary log MIXED format

replication filters

QUESTION 65
Which statement is true about InnoDB persistent index statistics?

Updating index statistics is an I/O expensive operation.

Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.

Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.

Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.

Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.

QUESTION 66
Examine this command and output:

Which two statements are true? (Choose two.)

The lock is at the metadata object level.

The lock is a shared lock.

The lock is an intentional lock.

The lock is at the table object level.

The lock is a row-level lock.

The lock is an exclusive lock.

QUESTION 67
Examine this statement and output:

You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)

QN = 3

QN = 5

QN = 1

QN = 4

QN = 2

QUESTION 68
An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)

Enable GTID by executing this on the master and the slave:
SET GLOBAL GTID_ENABLED=on;

Execute this on the slave to enable GTID:
START SLAVE IO_THREAD WITH GTID;

Restart MySQL (master and slave) with these options enabled:
–gtid_mode=ON
–log-bin
–log-slave-updates
–enforce-gtid-consistency

Execute this on the slave to enable GTID:
RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC;

On the slave, alter the MySQL master connection setting with:
ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;

On the slave, alter the MySQL master connection setting with:
CHANGE MASTER TO MASTER_AUTO_POSITION = 1;

QUESTION 69
Examine these statements, which execute successfully:
TRUNCATE test; BEGIN;
INSERT INTO test(id, name) VALUES(1, “Hello”); ROLLBACK;
SELECT id FROM test;
Which three storage engines would return a nonempty recordset for the test table when executing the statements? (Choose three.)

NDB

ARCHIVE

InnopB

BLACKHOLE

MEMORY

MyISAM

QUESTION 70
You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.
Examine the output:

What statement is true about the start attempt?

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

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

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

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

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

QUESTION 71
You execute this command:
shell> mysqlpump –exclude-databases=% –users
Which statement is true?

It creates a logical backup of all MySQL user accounts.

It creates a logical backup of all metadata, but contains no table data.

It returns an error because the mysqldumpcommand should have been used.

It creates a logical backup of only the usersdatabase.

Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/mysqlpump.html

QUESTION 72
Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.)

sort_buffer_size

key_buffer_size

table_open_cache

read_buffer_size

innodb_buffer_pool_size

tmp_table_size

QUESTION 73
Examine this MySQL Shell command:
dba.rebootClusterFromCompleteOutage()
Which two statements are true? (Choose two.)

It reconfigures InnoDB Cluster if the cluster was stopped.

It performs InnoDB Cluster instances rolling restart.

It only starts all InnoDB Cluster instances.

It is not mandatory that all instances are running and reachable before running the command.

It stops and restarts all InnoDB Cluster instances and initializes the metadata.

It only stops and restarts all InnoDB Cluster instances.

It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.

QUESTION 74
Which step or set of steps can be used to rotate the error log?

Execute SET GLOBAL log_error = ‘<new error log file>’.

Execute SET GLOBAL max_error_count = <number of messages at point to rotate>.

Execute SET GLOBAL expire_logs_days=0to enforce a log rotation.

Rename the error log file on disk, and then execute FLUSH ERROR LOGS.

Explanation/Reference: https://blog.pythian.com/mysql-log-rotation/

QUESTION 75
Which two commands will display indexes on the parts table in the manufacturing schema? (Choose two.)

DESCRIBE manufacturing.parts;

SELECT * FROM information_schema.statistics WHERE table_schema=’manufacturing’ AND TABLE_NAME=’parts’;

SHOW INDEXES FROM manufacturing.parts;

SELECT * FROM information_schema.COLUMN_STATISTICS;

EXPLAIN SELECT INDEXES FROM manufacturing.parts;

QUESTION 76
Which two are use cases of MySQL asynchronous replication? (Choose two.)

You can scale writes by creating a replicated mesh.

It guarantees near real-time replication between a master and a slave.

You can scale reads by adding multiple slaves.

MySQL Enterprise Backup will automatically back up from an available slave.

It allows backup to be done on the slave without impacting the master.

QUESTION 77
Examine this statement:
mysql> DROP ROLE r_role1, r_role2;
Which two are true? (Choose two.)

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

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

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

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

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

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

QUESTION 78
You have replication configured, which consists of one master and one slave on different hosts with an asynchronous replication channel between them.
Your goal is to decrease the amount of data that is transferred between these two hosts.
It is confirmed that the slave instance does not need to have data from the example database.
Which replication filter contributes to your goal?

on slave: –replicate-wild-ignore=example.%

on slave: –replicate-ignore-db=example

on master: –replicate-ignore-db=example

on master: –binlog-ignore-db=example

on slave: –binlog-ignore-db=example

Loading …

Oracle 1z1-908 exam is a vendor-neutral exam that is recognized globally. Passing 1Z0-908 exam will demonstrate to potential employers that the candidate has the skills and knowledge necessary to manage MySQL 8.0 databases. MySQL 8.0 Database Administrator certification will help candidates stand out in the crowded job market and increase their chances of getting hired.

Verified & Correct 1Z0-908 Practice Test Reliable Source Jan 03, 2024 Updated: https://www.it-tests.com/1Z0-908.html