1Z0-908 Free Exam Study Guide! (Updated 86 Questions)
1Z0-908 Dumps for MySQL Database Administration Certified Exam Questions & Answer
Oracle 1Z0-908 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
| Topic 10 |
|
| Topic 11 |
|
| Topic 12 |
|
| Topic 13 |
|
| Topic 14 |
|
NEW QUESTION 43
Which four connection methods can MySQL clients specify with the --protocol option when connecting to a MySQL server? (Choose four.)
- A. IPv6
- B. SOCKET
- C. TCP
- D. MEMORY
- E. DIRECT
- F. PIPE
- G. IPv4
- H. FILE
Answer: B,C,D,F
NEW QUESTION 44
Which two statements are true about MySQL server multi-source replication? (Choose two.)
- A. It uses only time-based replication conflict resolution.
- B. It is not compatible with auto-positioning.
- C. It relies on relay_log_recovery for resilient operations.
- D. It does not attempt to detect or resolve replication conflicts.
- E. It must use GTID replication.
- F. It needs to be re-instanced after a crash to maintain consistency.
Answer: A,E
NEW QUESTION 45
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 r_read@localhost role to another user.
- B. Mark can revoke the r_read@localhost role from another role.
- C. Mark must connect from localhost to activate the r_read@localhost role.
- D. Mark can grant the privileges assigned to the r_read@localhost role to another user.
- E. ADMIN OPTION allows Mark to drop the role.
- F. ADMIN OPTION causes the role to be activated by default.
Answer: D,E
NEW QUESTION 46
Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)
- A. primary indexes
- B. user privileges
- C. InnoDB Data Dictionary
- D. table data
- E. change buffer
- F. doublewrite buffer
Answer: C,F
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/innodb-system-tablespace.html
NEW QUESTION 47
Examine these statements and output:
Which statement is true?
- A. The user is authenticated as the anonymous proxy user ‘’@’%’.
- B. The user failed to define a username and the connecting username defaulted to ‘’@’%’.
- C. The user is authorized as the accounting@localhostuser.
- D. The user is authorized as the rsmith@localhostuser.
- E. The user is logged in with --user=accountingas an option.
Answer: D
NEW QUESTION 48
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 MASTER;
SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=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 SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167; - E. RESET MASTER;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
Answer: A
NEW QUESTION 49
Which statement is true about InnoDB persistent index statistics?
- A. Tables are scanned and index statistics recalculated when an instance is restarted.
- B. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
- C. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
- D. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
- E. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
- F. Updating index statistics is an I/O expensive operation.
Answer: E
NEW QUESTION 50
An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)
- A. Restart MySQL (master and slave) with these options enabled:
--gtid_mode=ON
--log-bin
--log-slave-updates
--enforce-gtid-consistency - B. On the slave, alter the MySQL master connection setting with:
ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1; - C. Enable GTID by executing this on the master and the slave:
SET GLOBAL GTID_ENABLED=on; - D. On the slave, alter the MySQL master connection setting with:
CHANGE MASTER TO MASTER_AUTO_POSITION = 1; - E. Execute this on the slave to enable GTID:
RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC; - F. Execute this on the slave to enable GTID:
START SLAVE IO_THREAD WITH GTID;
Answer: A,D
NEW QUESTION 51
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)
- A. It supports only non-blob datatypes.
- B. It decrypts data for use in memory.
- C. It enforces encryption from disk to memory and over network transmission.
- D. It supports all indexes transparently.
- E. It does not support the transportable tablespaces feature.
Answer: B,D
NEW QUESTION 52
You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)
- A. Use systemdwith different settings for each instance.
- B. Start mysqldor mysqld_safeusing different option files for each instance.
- C. Run MySQL Server docker containers.
- D. Use resource groups to lock different instances on separate CPUs.
- E. Use system tools to lock each instance to its own CPU.
- F. Run mysqldwith --datadirdefined for each instance.
Answer: A,B,F
Explanation:
Explanation/Reference:
NEW QUESTION 53
You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)
- A. Start mysqld or mysqld_safe using different option files for each instance.
- B. Run MySQL Server docker containers.
- C. Use systemd with different settings for each instance.
- D. Use resource groups to lock different instances on separate CPUs.
- E. Run mysqld with --datadir defined for each instance.
- F. Use system tools to lock each instance to its own CPU.
Answer: A,C,E
NEW QUESTION 54
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.)
- A. $HOME/.mysql/auth/login file
- B. $HOME/.my.cnf file
- C. $HOME/.mylogin.cnf file
- D. DATADIR/mysqld-auto.cnf file
- E. $HOME/.mysqlrc file
- F. $MYSQL_HOME/my.cnf file
- G. /etc/my.cnf file
Answer: D,F,G
NEW QUESTION 55
Examine this MySQL client command to connect to a remote database:
mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=
Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the SSL/TLS connection to MySQL?
- A. VERIFY_CA
- B. PREFERRED
- C. VERIFY_IDENTITY
- D. DISABLED
- E. REQUIRED
Answer: E
NEW QUESTION 56
Examine this query and output:
Which two statements are true? (Choose two.)
- A. It takes more than 8 milliseconds to sort the rows.
- B. 35 rows from the city table are included in the result.
- C. The query returns exactly 125 rows.
- D. The country table is accessed as the first table, and then joined to the city table.
- E. The optimizer estimates that 51 rows in the country table have Continent = 'Asia'.
Answer: B,E
NEW QUESTION 57
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. information_schema
- B. mysql
- C. employee
- D. world
- E. sys
Answer: A,E
NEW QUESTION 58
Examine this command, which executes successfully:
shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb Which two statements are true? (Choose two.)
- A. This option uses the READ COMMITTED transaction isolation mode.
- B. It is a cold backup.
- C. The backup created is a consistent data dump.
- D. It enforces consistent backups for all storage engines.
- E. It executes flush tables with read lock.
Answer: A,E
NEW QUESTION 59
Which two queries are examples of successful SQL injection attacks? (Choose two.) SELECT user,passwd FROM members
- A. SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;
- B. WHERE user = ‘?’;INSERT INTO members(‘user’,’passwd’) VALUES
(‘[email protected]’,‘secret’);--‘; - C. SELECT email,passwd FROM members
- D. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;
- E. SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);
- F. WHERE email = ‘INSERT INTO members(‘email’,’passwd’) VALUES
(‘[email protected]’, ‘secret’);--‘;
SELECT user, phone FROM customers WHERE name = ‘\; DROP TABLE users; --‘;
Answer: C,D
NEW QUESTION 60
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?
- A. Use a text editor to create a new defaults file and encrypt it from Linux prompt.
- B. Use mysql_secure_installation to encrypt stored login credentials.
- C. Use mysql_config_editor to create an encrypted file.
- D. Use the AES_ENCRYPT() MySQL function on the option file.
Answer: C
NEW QUESTION 61
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 FULLTEXT INDEX (Population);
- B. ALTER TABLE world.city ADD INDEX (Name);
- C. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
- D. ALTER TABLE world.city ADD SPATIAL INDEX (Population);
- E. ALTER TABLE world.city ADD SPATIAL INDEX (Name);
- F. ALTER TABLE world.city ADD INDEX (Population);
Answer: D
NEW QUESTION 62
A MySQL server is monitored using MySQL Enterprise Monitor's agentless installation.
Which three features are available with this installation method? (Choose three.)
- A. disk usage and disk characteristics including disk advisors warnings
- B. operating system memory utilization
- C. security-related advisor warnings
- D. CPU utilization
- E. MySQL Replication monitoring
- F. network-related information and network characteristics
- G. MySQL Query Analysis data
Answer: A,C,G
NEW QUESTION 63
Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)
- A. UDP
- B. X Protocol
- C. shared memory
- D. SOCKET
- E. named pipes
- F. TCP/IP
Answer: C,E,F
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/mysql-installer-workflow.html
NEW QUESTION 64
Which two storage engines provide a view of the data consistent with the storage system at any moment?
(Choose two.)
- A. InnoDB
- B. MEMORY
- C. ARCHIVE
- D. NDB
- E. MyISAM
Answer: B,E
Explanation:
Explanation/Reference: https://zetcode.com/mysql/storageengines/
NEW QUESTION 65
Examine this command, which executes successfully:
$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path Which activity is performed?
- A. MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.
- B. MySQL Router is configured based on the information in files in directory_path.
- C. MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.
- D. MySQL Router is restarted.
Answer: A
NEW QUESTION 66
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. mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql
- B. mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql
- C. mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql
- D. mysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql
Answer: B
NEW QUESTION 67
Examine this list of MySQL data directory binary logs:
binlog.000001 binlog.000002
.....
binlog.000289
binlog.000300
binlog.000301
binlog.index
Now examine this command, which executes successfully:
mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql
Which two are true? (Choose two.)
- A. All databases are backed up to the output file.
- B. All non-active binary logs are removed from the master.
- C. All details regarding deleted logs and master metadata are captured in the output file.
- D. All binary logs are deleted from the master.
- E. All databases, excluding master metadata, are backed up to the output file.
- F. All binary logs are backed up and then deleted.
Answer: D,E
NEW QUESTION 68
......
Difficulty in Writing of Oracle 1Z0-908: MySQL 8.0 Database Exam
Oracle Certified Expert, Oracle 1Z0-908: MySQL 8.0 Database Administrator Certification is not the most difficult Oracle certification test but taking it without any preparation is likely to fail. Therefore, it is highly recommended that candidates should prepare well by taking 1Z0-908 practice exams. Any questions that are left unanswered will be treated as incorrect therefore you should answer all the questions after the examination of 1Z0-908 dumps.
Use Real 1Z0-908 Dumps - 100% Free 1Z0-908 Exam Dumps: https://www.newpassleader.com/Oracle/1Z0-908-exam-preparation-materials.html
Realistic Verified 1Z0-908 exam dumps Q&As - 1Z0-908 Free Update : https://drive.google.com/open?id=1FS32r2H8kFNlfrqQ6rg0PyK--sTKuzAo