[Full-Version] 2023 New Preparation Guide of Oracle 1Z0-908 Exam [Q74-Q96]

Rate this post

[Full-Version] 2023 New Preparation Guide of Oracle 1Z0-908 Exam

1Z0-908 Practice Exam – 142 Unique Questions

Oracle 1Z0-908 exam tests candidates on various aspects of database administration, such as installation, configuration, security, backup, and recovery. 1Z0-908 exam also covers topics like database performance tuning, troubleshooting, and monitoring. Passing 1Z0-908 exam demonstrates your expertise in managing MySQL 8.0 databases and positions you as a valuable asset to any organization that uses MySQL.

Oracle 1z1-908 exam is intended for candidates who have experience in database administration and are familiar with MySQL 8.0 features and functionalities. 1Z0-908 exam consists of 80 multiple-choice questions that need to be answered within 150 minutes. The passing score for the exam is 64%, which means you need to answer at least 51 questions correctly to pass the exam.

NEW QUESTION 74
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.

NEW QUESTION 75
You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes.
Examine the current GTID information:

You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover.
Which set of actions would allow the slave to continue replicating without erroneous transactions?
RESET MASTER;

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb-

bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
RESET SLAVE;

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa—aaaaaaaaaaaa:1-10300;
RESET MASTER;

SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
RESET SLAVE;

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

NEW QUESTION 76
Which two are features of MySQL Enterprise Firewall? (Choose two.)

recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands

blocking of potential threats by configuring pre-approved whitelists

modifying SQL statement dynamically with substitutions

automatic locking of user accounts who break your firewall

provides stateless firewall access to TCP/3306

NEW QUESTION 77
Which statement is true about displaying and retrieving data with MySQL Enterprise Monitor Query Analyzer?

The Query Analyzer graph view range selector can extend to cover the same hour over multiple days.

It is possible to filter a Query Analyzer view graph by database and by table.

The Query Analyzer can plot a CPU utilization graph for remote hosts with a MySQL Enterprise Service Manager’s built-in Agent installation.

It is possible to export statements included in a graph selection in CSV format.

NEW QUESTION 78
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.

NEW QUESTION 79
You made some table definition changes to a schema in your MySQL Server.
Which two statements reflect how MySQL Server handles the table definition changes? (Choose two.)

MySQL writes SDI to the binary log for distributed backups.

MySQL keeps InnoDB metadata changes in .sdi files in datadir.

The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).

MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.

MySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.

NEW QUESTION 80
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?

ALTER TABLE world.city ADD SPATIAL INDEX (Name);

ALTER TABLE world.city ADD SPATIAL INDEX (Population);

ALTER TABLE world.city ADD INDEX (Population);

ALTER TABLE world.city ADD INDEX (Name);

ALTER TABLE world.city ADD FULLTEXT INDEX (Name);

ALTER TABLE world.city ADD FULLTEXT INDEX (Population);

NEW QUESTION 81
Binary log events for the ‘mydb1’ schema must be copied to a different schema name ‘mydb2’.
Which command will do this?

mysqlbinlog –rewrite-db=’mydb1->mydb2’ | mysql

mysqlbinlog –datebase=mydb1 –database=mydb2 | mysql

mysqlbinlog –rewrite-db=’mydb1’ –rewrite-db=’mydb2’ | mysql

mysqlbinlog –read-from-remote-server –raw | sed ‘s/mydb1/mydb2/g’ | mysql

NEW QUESTION 82
The data in this instance is transient; no backup or replication will be required. It is currently under performing.
* The database size is static and including indexes is 19G.
* Total system memory is 32G.
After profiling the system, you highlight these MySQL status and global variables:

The OS metrics indicate that disk is a bottleneck. Other variables retain their default values.
Which three changes will provide the most benefit to the instance? (Choose three.)

innodb_flush_log_at_trx_commit=1

buffer_pool_size=24G

innodb_log_file_size=1G

sync_binlog=0

innodb_doublewrite=0

max_connections=10000

innodb_undo_directory=/dev/shm

NEW QUESTION 83
Examine these commands and output:

Which connection ID is holding the metadata lock?

NEW QUESTION 84
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.pemfile.

Remove world read privileges from the server-cert.pemcertificate file.

Change the group ownership of the mysqldirectory to the mysqluser group.

Remove world read privileges from the public_key.pemfile.

Change the parent directory owner and group to mysql.

Remove the world read/execute privilege from the accountingdirectory.

NEW QUESTION 85
You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor.
Using Query Analyzer, where do you begin to look for problem queries?

Sort the “Exec” column and check for SQL queries with low Query Response Time index (QRTi) values.

Look for queries with low total latency times in the Latency section in the times series graph.

Look for queries with big prolonged spikes in row activity/access graph in the times series graph.

Sort the “Exec” column and check for SQL queries with high Query Response Time index (QRTi) values.

NEW QUESTION 86
Examine this command, which executes successfully:
mysqlpump –user=root –password > full_backup.sql
Which two databases will be excluded from this dump? (Choose two.)

information_schema

world

employee

sys

mysql

NEW QUESTION 87
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; –‘;

NEW QUESTION 88
A user wants to connect without entering his or her username and password on the Linux command prompt.
Which three locations can be used to store the user’s mysql credentials to satisfy this requirement? (Choose three.)

$HOME/.my.cnf file

$MYSQL_HOME/my.cnf file

DATADIR/mysqld-auto.cnf file

$HOME/.mylogin.cnf file

$HOME/.mysql/auth/login file

/etc/my.cnf file

$HOME/.mysqlrc file

NEW QUESTION 89
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.

NEW QUESTION 90
Which two are true about binary logs used in asynchronous replication? (Choose two.)

They are pushed from the master to the slave.

They contain events that describe database changes on the master.

They contain events that describe all queries run on the master.

They contain events that describe only administrative commands run on the master.

They are pulled from the master to the slave.

NEW QUESTION 91
You wish to store the username and password for a client connection to MySQL server in a file on a local file system.
Which is the best way to encrypt the file?

Use the AES_ENCRYPT() MySQL function on the option file.

Use mysql_secure_installation to encrypt stored login credentials.

Use a text editor to create a new defaults file and encrypt it from Linux prompt.

Use mysql_config_editor to create an encrypted file.

NEW QUESTION 92
Examine this SQL statement:

Which set of privileges will allow Tom to execute this SQL statement?

GRANT ALL PRIVILEGES ON ‘world’.’city’ TO ‘tom’@’%’;
GRANT SELECT (‘code’) ON ‘world’.’country’ TO ‘tom’@’%’;

GRANT UPDATE ON ‘world’.* TO ‘tom’@’%’;
GRANT ALL PRIVILEGES ON ‘world’.’country’ TO ‘tom’@’%’;

GRANT UPDATE ON ‘world’.’city’ TO ‘tom’@’%’; GRANT SELECT ON ‘world’.* TO ‘tom’@’%’;

GRANT UPDATE ON ‘world’.’city’ TO ‘tom’@’%’; GRANT SELECT ON ‘world’.’country’ TO ‘tom’@’%’;

NEW QUESTION 93
Which command enables rule-based MySQL Auditing capabilities?

shell> mysql < audit_log_filter_linux_install.sql

shell> mysqld –initialize –log-raw=audit.log

mysql> INSTALL PLUGIN audit_log;

mysql> INSTALL COMPONENT audit_log;

NEW QUESTION 94
You plan to take daily full backups, which include the ndbinfo and sys (internal) databases.
Which command will back up the databases in parallel?

mysqldump –single-transaction > full-backup-$(date +%Y%m%d).sql

mysqlpump –include-databases=% > full-backup-$(date +%Y%m$d).sql

mysqlpump –all-databases > full-backup-$(date +%Y%m%d).sql

mysqldump –all-databases > full_backup-$(date +%Y%m%d).sql

NEW QUESTION 95
Examine these statements and output:

Which statement is true?

The user is logged in with –user=accountingas an option.

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

The user is authorized as the accounting@localhostuser.

The user is authorized as the rsmith@localhostuser.

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

NEW QUESTION 96
Examine these entries from the general query log:

All UPDATE statements reference existing rows.
Which describes the outcome of the sequence of statements?

Connection 24 experiences a lock wait timeout.

Connection 25 experiences a lock wait timeout.

A deadlock occurs immediately.

All statements execute without error.

A deadlock occurs after innodb_lock_wait_timeout seconds.

Latest Questions 1Z0-908 Guide to Prepare Free Practice Tests: https://www.real4dumps.com/1Z0-908_examcollection.html

[Full-Version] 2023 New Preparation Guide of Oracle 1Z0-908 Exam [Q74-Q96]

Leave a Reply Cancel reply

Related Posts

2022 Updated Verified Pass 1Z0-1096-21 Study Guides & Best Courses [Q18-Q36]

100% Pass Top-selling 1Z0-1042-21 Exams – New 2022 Oracle Pratice Exam [Q66-Q80]

[Nov-2023] Updated and Accurate 1z0-1072-23 Questions & Answers for passing the exam Quickly [Q22-Q38]