(2024) 1Z0-908 Dumps and Practice Test (142 Questions) [Q20-Q44]

(2024) 1Z0-908 Dumps and Practice Test (142 Questions)

Guide (New 2024) Actual Oracle 1Z0-908 Exam Questions

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

• A. Execute SET GLOBAL max_error_count = <number of messages at point to rotate>.
• B. Execute SET GLOBAL expire_logs_days=0 to enforce a log rotation.
• C. Execute SET GLOBAL log_error = '<new error log file>'.
• D. Rename the error log file on disk, and then execute FLUSH ERROR LOGS.

Answer: D

NEW QUESTION # 21
Examine this statement and output:

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

• A. QN = 2
• B. QN = 1
• C. QN = 5
• D. QN = 4
• E. QN = 3

Answer: A,B

NEW QUESTION # 22
Examine this command and output:

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

• A. Change the parent directory owner and group to mysql.
• B. Remove the world read/execute privilege from the accounting directory.
• C. Remove group read/write privileges from the private_key.pem file.
• D. Remove world read privileges from the server-cert.pem certificate file.
• E. Change the group ownership of the mysql directory to the mysql user group.
• F. Remove world read privileges from the public_key.pem file.

Answer: A,E

NEW QUESTION # 23
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 dat
a. 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?

• A. Take a logical backup of the MySQL system.
• B. Take a physical backup of the MySQL system.
• C. Take your backup from a slave of the MySQL system.
• D. Use the Clone Plugin to copy the data to another MySQL system.

Answer: A

NEW QUESTION # 24
Examine this command, which executes successfully:

Which statement is true?

• A. Only files for MySQL or Its built-in storage engines are backed
• B. The backup includes only data files and their metadata.
• C. Only tables stored in their own tablespaces are backed up.
• D. Only non-encrypted files are backed up.
• E. Only InnoDB data and log files are backed up.

Answer: E

NEW QUESTION # 25
All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled.
You must configure InnoDB Cluster to use SSL for group communication.
Which two statements are true? (Choose two.)

• A. Configuring SSL group communication also configures SSL distributed recovery.
• B. SSL group communication must be enabled at cluster creation time by specifying createCluster ({memberSslMode: 'REQUIRED'}).
• C. SSL group communication can be enabled for an existing cluster, one instance at time, by setting group_replication_ssl_mode.
• D. SSL group communication requires the use of an additional set of parameters group_replication_recovery_*.
• E. If only some InnoDB Cluster members are enabled for SSL group communication, and
  --ssl-mode=PREFERRED, communication will fall back to unencrypted connection.
• F. An existing InnoDB Cluster must be dissolved and created from scratch to enable SSL for group communication.

Answer: B,D

NEW QUESTION # 26
Examine this query and its output:

Which two statements are true? (Choose two.)

• A. The app user had the highest total number of rows read from storage engines.
• B. The root user had the largest single wait time.
• C. User bob had a significantly higher ratio of SELECT + INSERT statements to QUIT than both app and root users.
• D. The root user had the largest number of modified rows for a SELECT statement.
• E. User bob had the largest total time waiting for locks.

Answer: A,C

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

• A. Execute SET GLOBAL max_error_count = <number of messages at point to rotate>.
• B. Execute SET GLOBAL expire_logs_days=0to enforce a log rotation.
• C. Execute SET GLOBAL log_error = ‘<new error log file>’.
• D. Rename the error log file on disk, and then execute FLUSH ERROR LOGS.

Answer: D

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

NEW QUESTION # 28
You recently upgraded your MySQL installation to MySQL 8.0.
Examine this client error:

Which option will allow this client to connect to MySQL Server?

• A. ALTER USER user -
  IDENTIFIED WITH mysql_native_password
  BY 'password';
• B. ALTER USER user -
  IDENTIFIED WITH sha256_password -
  BY 'password';
• C. [mysqld]
  default_authentication_plugin=caching_sha2_password
• D. [mysqld]
  default_authentication_plugin=mysql_native_password
• E. [mysqld]
  default_authentication_plugin=sha256_password
• F. ALTER USER user -
  IDENTIFIED WITH caching_sha2_password
  BY 'password';

Answer: B

NEW QUESTION # 29
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 INDEX (Population);
• C. ALTER TABLE world.city ADD SPATIAL INDEX (Population);
• D. ALTER TABLE world.city ADD INDEX (Name);
• E. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);
• F. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);

Answer: C

Explanation:
Explanation/Reference: https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html

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

• A. mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql
• B. mysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql
• C. mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql
• D. mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql

Answer: A

NEW QUESTION # 31
Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)

• A. Mark must connect from localhost to activate the r_read@localhost role.
• B. Mark can revoke the r_read@localhost role from another role.
• C. Mark can grant the r_read@localhost role to another user.
• D. ADMIN OPTION causes the role to be activated by default.
• E. Mark can grant the privileges assigned to the r_read@localhost role to another user.
• F. ADMIN OPTION allows Mark to drop the role.

Answer: E,F

NEW QUESTION # 32
You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)

• A. The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.
  Section: (none)
  Explanation
• B. The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.
• C. The mysqlcheck --optimize --all-databases command reclaims free space from table files.
• D. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.
• E. The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.

Answer: A,B

NEW QUESTION # 33
Your MySQL instance is capturing a huge amount of financial transactions every day in the finance database.
Company policy is to create a backup every day.
The main tables being updated are prefixed with transactions-.
These tables are archived into tables that are prefixed with archives- each month. mysqlbackup
--optimistic-busy-tables="^finance\.transactions-.*" backup
Which optimization process best describes what happens with the redo logs?

• A. The archive tables are backed up first, then the transaction tables and redo logs.
• B. The redo logs are backed up only if there are changes showing for the transactions tables.
• C. The redo logs are not backed up at all.
• D. The redo logs are backed up first, then the transaction and archive tables.
• E. The transaction tables are backed up first, then the archive tables and redo logs.

Answer: B

NEW QUESTION # 34
A clean shutdown was performed with innodb_fast_shutdown=0.
While you were manipulating files, all files were accidentally deleted from the top-level data directory.
Which two files must be restored from backup to allow the DB to restart cleanly? (Choose two.)

• A. ib_logfile0
• B. ib_buffer_pool
• C. ibtmp1
• D. mysql.ibd
• E. ibdata1
• F. undo_001

Answer: B,D

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

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

Answer: C

NEW QUESTION # 36
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?

• A. Take a logical backup of the MySQL system.
• B. Take a physical backup of the MySQL system.
• C. Take your backup from a slave of the MySQL system.
• D. Use the Clone Plugin to copy the data to another MySQL system.

Answer: A

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

• A. mysqlbinlog --read-from-remote-server --raw | sed 's/mydb1/mydb2/g' | mysql
• B. mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql
• C. mysqlbinlog --rewrite-db='mydb1->mydb2' | mysql
• D. mysqlbinlog --rewrite-db='mydb1' --rewrite-db='mydb2' | mysql

Answer: A

NEW QUESTION # 38
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. shell> cp /backup/customers.sdi /var/lib/mysql/shop/
• B. shell> cp /backup/customers.frm /var/lib/mysql/shop/
• C. mysql> ALTER TABLE shop.customers DISCARD TABLESPACE
• D. mysql> ALTER TABLE shop.customers IMPORT TABLESPACE
• E. mysql> IMPORT TABLE FROM /var/tmp/customers.sdi
• F. mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi
• G. shell> cp /backup/customers.sdi /var/tmp
• H. mysql> SOURCE '/var/tmp/customers.sdi'

Answer: D,E

NEW QUESTION # 39
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?

• A. RESET SLAVE;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• B. 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;
• C. RESET SLAVE;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
  SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10300;
• D. RESET MASTER;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• E. RESET MASTER;
  SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
  SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

Answer: E

NEW QUESTION # 40
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.)

• A. MyISAM
• B. ARCHIVE
• C. BLACKHOLE
• D. MEMORY
• E. InnopB
• F. NDB

Answer: A,C,F

NEW QUESTION # 41
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?

• A. Take a logical backup of the MySQL system.
• B. Take a physical backup of the MySQL system.
• C. Take your backup from a slave of the MySQL system.
• D. Use the Clone Plugin to copy the data to another MySQL system.

Answer: A

NEW QUESTION # 42
Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)

• A. The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.
• B. It is possible to retrieve a normalized statement, but never the exact statement that was executed.
• C. It is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.
• D. It is possible to import data into the Query Analyzer from heterogeneous sources, such as CSV.
• E. It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.

Answer: C,E

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

• A. sys
• B. information_schema
• C. employee
• D. world
• E. mysql

Answer: A,B

Explanation:
Explanation/Reference: https://mysqlserverteam.com/introducing-mysqlpump/

NEW QUESTION # 44
......

1Z0-908 Exam Dumps Pass with Updated 2024 Certified Exam Questions: https://www.trainingdump.com/Oracle/1Z0-908-practice-exam-dumps.html

1Z0-908 Exam Questions - Real & Updated Questions PDF: https://drive.google.com/open?id=1FgHzKMm9ur1hqOE5Jlw5FhWubeUk7tMm