Oracle 1z1-908 Certification All-in-One Exam Guide Jul-2023
Get Real 1z1-908 Exam Dumps [Jul-2023] Practice Tests
The Oracle 1z1-908 exam covers a wide range of topics, including installation, configuration, security, backup, recovery, and performance tuning. 1z1-908 exam is designed to be challenging and requires candidates to have a deep understanding of MySQL database administration. 1z1-908 exam is 150 minutes long and consists of 80 multiple-choice questions. The passing score for 1z1-908 exam is 64%.
NEW QUESTION # 42
Which two statements are true about using backups of the binary log? (Choose two.)
- A. Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.
- B. Binary logs can always be used to unapply unwanted schema changes.
- C. Multiple binary logs can be applied in parallel for faster data restoration.
- D. They allow for point-in-time recovery of the data.
- E. Multiple binary logs can be used to restore data.
Answer: B,D
NEW QUESTION # 43
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?
- A. It allows scanning of other locations to discover more innodb tablespaces.
- B. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
- C. It adds more temporary workspace in addition to the innodb_tmpdir location.
- D. It defines all innodb tablespace options relative to a starting parent directory.
- E. It is not necessary because innodb_data_home_dir is already defined.
Answer: A
Explanation:
Explanation
https://dev.mysql.com/doc/refman/8.0/en/innodb-moving-data-files-offline.html
NEW QUESTION # 44
Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)
- A. Mark can grant the privileges assigned to the r_read@localhost role to another user.
- B. Mark can grant the r_read@localhost role to another user.
- C. Mark can revoke the r_read@localhost role from another role.
- D. ADMIN OPTION causes the role to be activated by default.
- E. ADMIN OPTION allows Mark to drop the role.
- F. Mark must connect from localhost to activate the r_read@localhost role.
Answer: B,C
Explanation:
Explanation
https://dev.mysql.com/doc/refman/8.0/en/grant.html
NEW QUESTION # 45
Which two are true about binary logs used in asynchronous replication? (Choose two.)
- A. They contain events that describe only administrative commands run on the master.
- B. They contain events that describe database changes on the master.
- C. They are pushed from the master to the slave.
- D. They are pulled from the master to the slave.
- E. They contain events that describe all queries run on the master.
Answer: B,C
NEW QUESTION # 46
Which three are characteristics of a newly created role? (Choose three.)
- A. It can be granted to user accounts.
- B. It can be dropped using the DROP ROLE statement.
- C. It can be renamed using the RENAME ROLE statement.
- D. It is stored in the mysql.role table.
- E. It can be protected with a password.
- F. It is created as a locked account.
Answer: A,B,E
Explanation:
Explanation
https://dev.mysql.com/doc/refman/8.0/en/roles.html
https://www.mysqltutorial.org/mysql-roles/
NEW QUESTION # 47
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 redo logs are not backed up at all.
- B. The redo logs are backed up only if there are changes showing for the transactions tables.
- C. The archive tables are backed up first, then the transaction tables and redo logs.
- D. The transaction tables are backed up first, then the archive tables and redo logs.
- E. The redo logs are backed up first, then the transaction and archive tables.
Answer: B
NEW QUESTION # 48
Which three requirements must be enabled for group replication? (Choose three.)
- A. binary log MIXED format
- B. replication filters
- C. slave updates logging
- D. binary log checksum
- E. binary log ROW format
- F. semi-sync replication plugin
- G. primary key or primary key equivalent on every table
Answer: A,F,G
NEW QUESTION # 49
Examine the modified output:
Seconds_Behind_ Mastervalue is steadily growing.
What are two possible causes? (Choose two.)
- A. This value shows only I/O latency and is not indicative of the size of the transaction queue.
- B. One or more large tables do not have primary keys.
- C. The parallel slave threads are experiencing lock contention.
- D. The master is producing a large volume of events in parallel but the slave is processing them serially.
- E. The master is most probably too busy to transmit data and the slave needs to wait for more data.
Answer: A,D
Explanation:
Explanation
NEW QUESTION # 50
Examine this statement and output:
Which two SQL statements can jsmith execute? (Choose two.)
- A. UPDATE world.country SET Name='new' WHERE Name='old';
- B. UPDATE world.country SET Name=CONCAT('New ',Name);
- C. UPDATE world.country SET Name='one' LIMIT 1;
- D. UPDATE world.country SET Name='all';
- E. UPDATE world.country SET Name='first' ORDER BY Name LIMIT
Answer: A,D
NEW QUESTION # 51
Which three are types of InnoDB tablespaces? (Choose three.)
- A. redo tablespaces
- B. schema tablespaces
- C. undo tablespaces
- D. encryption tablespaces
- E. data tablespaces
- F. temporary table tablespaces
Answer: D,E,F
NEW QUESTION # 52
Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)
- A. doublewrite buffer
- B. InnoDB Data Dictionary
- C. user privileges
- D. table data
- E. primary indexes
- F. change buffer
Answer: A,B
NEW QUESTION # 53
Examine this command and output:
Which statement is true?
- A. Firewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.
- B. Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.
- C. Firewall_access_granted is the number of connections granted from whitelisted hosts.
- D. Firewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.
Answer: A
NEW QUESTION # 54
You want to dump all databases with names that start with "db".
Which command will achieve this?
- A. mysqlpump --include-databases=db% --result-file=all_db_backup.sql
- B. mysqlpump --include-tables=db.% --result-file=all_db_backup.sql
- C. mysqlpump --include-databases=db --result-file=all_db_backup.sql
- D. mysqlpump > all_db_backup.sql
Answer: C
NEW QUESTION # 55
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. SSL group communication must be enabled at cluster creation time by specifying createCluster ({memberSslMode: 'REQUIRED'}).
- B. SSL group communication requires the use of an additional set of parameters group_replication_recovery_*.
- C. An existing InnoDB Cluster must be dissolved and created from scratch to enable SSL for group communication.
- D. SSL group communication can be enabled for an existing cluster, one instance at time, by setting group_replication_ssl_mode.
- E. Configuring SSL group communication also configures SSL distributed recovery.
- F. If only some InnoDB Cluster members are enabled for SSL group communication, and
--ssl-mode=PREFERRED, communication will fall back to unencrypted connection.
Answer: A,B
NEW QUESTION # 56
Examine these statements and output:
Which statement is true?
- A. The user is authorized as the accounting@localhost user.
- B. The user failed to define a username and the connecting username defaulted to ''@'%'.
- C. The user is authenticated as the anonymous proxy user ''@'%'.
- D. The user is authorized as the rsmith@localhost user.
- E. The user is logged in with --user=accounting as an option.
Answer: D
NEW QUESTION # 57
Which two statements are true about MySQL Installer? (Choose two.)
- A. Manual download of separate product packages is required before installing them through MySQL Installer.
- B. It provides only GUI-driven, interactive installations.
- C. It provides a uniform installation wizard across multiple platforms.
- D. It performs product upgrades.
- E. It installs most Oracle MySQL products.
Answer: B,D
NEW QUESTION # 58
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)
- A. It enforces encryption from disk to memory and over network transmission.
- B. It decrypts data for use in memory.
- C. It supports all indexes transparently.
- D. It supports only non-blob datatypes.
- E. It does not support the transportable tablespaces feature.
Answer: B,C
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/faqs-tablespace-encryption.html
NEW QUESTION # 59
Your MySQL server was upgraded from an earlier major version.
The sales database contains three tables, one of which is the transactions table, which has 4 million rows.
You are running low on disk space on the datadir partition and begin to investigate.
Examine these commands and output:
Which two statements are true? (Choose two.)
- A. Executing ALTER TABLE transactions will enable you to free up disk space.
- B. The transactions table was created with innodb_file_per_table=OFF.
- C. Truncating the sales and leads table will free up disk space.
- D. Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions will free up disk space.
- E. Truncating the transactions table will free up the most disk space.
Answer: B,D
NEW QUESTION # 60
You are backing up raw InnoDB files by using mysqlbackup.
Which two groups of files will be backed up during a full backup? (Choose two.)
- A. *.CSM files
- B. *.ibd files
- C. *.sdi files
- D. ib_logfile* files
- E. ibbackup files
Answer: B,D
NEW QUESTION # 61
......
Last 1z1-908 practice test reviews: Practice Test Oracle dumps: https://www.dumpstillvalid.com/1z1-908-prep4sure-review.html
