1Z0-908 Questions – Truly Beneficial For Your Oracle Exam (Updated 142 Questions) [Q72-Q95]

4.5/5 - (2 votes)

1Z0-908 Questions – Truly Beneficial For Your Oracle Exam (Updated 142 Questions)

View All 1Z0-908 Actual Exam Questions, Answers and Explanations for Free

Q72. 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.

Q73. 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);

Q74. Examine the modified output:

Seconds_Behind_ Mastervalue is steadily growing.
What are two possible causes? (Choose two.)

The master is most probably too busy to transmit data and the slave needs to wait for more data.

One or more large tables do not have primary keys.

This value shows only I/O latency and is not indicative of the size of the transaction queue.

The master is producing a large volume of events in parallel but the slave is processing them serially.

The parallel slave threads are experiencing lock contention.

Q75. 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;

Q76. Which condition is true about the use of the hash join algorithm?

No index can be used for the join.

The query must access no more than two tables.

The smallest of the tables in the join must fit in memory as set by join_buffer_size.

At least one of the tables in the join must have a hash index.

Q77. 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’@’%’;

Q78. Examine this command and output:

Which statement is true?

Firewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.

Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.

Firewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.

Firewall_access_granted is the number of connections granted from whitelisted hosts.

Q79. The mysqld instance has the connection control plugin enabled with these settings:
connection_control_min_connection_delay=1000 connection_control_max_connection_delay=2000 The minimum and maximum delays need to be increased to 3000 and 5000, respectively.
A command is executed:
mysql> SET GLOBAL connection_control_min_connection_delay=3000;
What is the result?

The minimum value increases to 3000 and the maximum value increases to 4000.

Only the minimum connection value is increased to 3000.

The minimum connection value is changed to 2000.

An error is returned.

Q80. You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)

Run MySQL Server docker containers.

Use systemd with different settings for each instance.

Use system tools to lock each instance to its own CPU.

Start mysqld or mysqld_safe using different option files for each instance.

Run mysqld with –datadir defined for each instance.

Use resource groups to lock different instances on separate CPUs.

Q81. Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.

Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.

Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.

TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.

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

/usr/mysql

/usr/bin

/etc/my.cnf

/var/lib/mysql

/usr

Q83. Which two statements are true about MySQL Enterprise Backup? (Choose two.)

It supports backing up only table structures.

It can perform hot or warm backups.

It creates logical backups.

It supports the creation of incremental backups.

It supports backup of a remote MySQL system.

It supports restoring to a remote MySQL system.

Q84. Which two are characteristics of snapshot-based backups? (Choose two.)

Snapshot-based backups greatly reduce time during which the database and applications are unavailable.

There is no need for InnoDB tables to perform its own recovery when restoring from the snapshot backup.

The frozen file system can be cloned to another virtual machine immediately into active service.

A separate physical copy must be made before releasing the snapshot backup.

Snapshot backups can be used only in virtual machines.

Q85. A colleague complains about slow response time on your website.
Examine this query and output:

What is the most likely cause for the high number of lock waits?

You use the MyISAM storage engine for most common tables.

You use the InnoDB storage engine and statements wait while data is inserted.

The Innodb Buffer pool is full.

Your table accesses wait for the operating system level flush.

Q86. Examine this query and output:

Which two statements are true? (Choose two.)

The country table is accessed as the first table, and then joined to the city table.

It takes more than 8 milliseconds to sort the rows.

The optimizer estimates that 51 rows in the country table have Continent = ‘Asia’.

35 rows from the city table are included in the result.

The query returns exactly 125 rows.

Q87. Examine this command, which executes successfully:

Which statement is true?

Only files for MySQL or Its built-in storage engines are backed

Only non-encrypted files are backed up.

The backup includes only data files and their metadata.

Only InnoDB data and log files are backed up.

Only tables stored in their own tablespaces are backed up.

Q88. Your my.cnf file contains these settings:

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?

min_examined_row_limit=5000

long_query_time=5
log_throttle_queries_not_using_indexes=5

log_throttle_queries_not_using_indexes=5
min_examined_ row_limit=5000

long_query_time=5

long_query_time=5
min_examined_row_limit=5000

log_throttle_queries_not_using_indexes=5

long_query_time=5
log_throttle_queries_not_using_indexes=5
min_examined_row_limit=5000

Q89. 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;

Q90. 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.

Q91. You want to dump all databases with names that start with “db”.
Which command will achieve this?

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

mysqlpump > all_db_backup.sql

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

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

Q92. 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=0 to enforce a log rotation.

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

Q93. 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;

Q94. 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

Q95. What is the correct syntax for using transparent data encryption with an existing InnoDB table?

ALTER TABLE t1 ADD ENCRYPTED_TABLESPACE = ‘Y’;

ALTER TABLE t1 ENCRYPTION=’Y’;

ALTER TABLE t1 WITH ENCRYPTION USING MASTER KEY;

ALTER TABLE t1 SET TDE = ‘ON’;

1Z0-908 dumps Free Test Engine Verified By It Certified Experts: https://www.troytecdumps.com/1Z0-908-troytec-exam-dumps.html

High-quality Troytec review files

1Z0-908 Questions – Truly Beneficial For Your Oracle Exam (Updated 142 Questions) [Q72-Q95]

troytecdumps

Leave a Reply Cancel reply

Related Posts

[Aug 22, 2026] 1Z0-171 Test Engine files, 1Z0-171 Dumps PDF [Q63-Q81]

Use 1Z0-1064-26 Exam Dumps (2026 PDF Dumps) To Have Reliable 1Z0-1064-26 Test Engine [Q41-Q57]

Updated Free Oracle 1Z0-931-26 Test Engine Questions with 151 Q&As [Q84-Q105]

troytecdumps

Leave a Reply Cancel reply