Oracle 1Z0-908 Test Engine Practice Test Questions, Exam Dumps
100% Free 1Z0-908 Daily Practice Exam With 142 Questions
NEW QUESTION # 36
Examine these commands and output:
Which connection ID is holding the metadata lock?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
- F. 5
Answer: E
NEW QUESTION # 37
Which two statements are true about MySQL Enterprise Backup? (Choose two.)
- A. It supports restoring to a remote MySQL system.
- B. It supports backing up only table structures.
- C. It creates logical backups.
- D. It supports the creation of incremental backups.
- E. It can perform hot or warm backups.
- F. It supports backup of a remote MySQL system.
Answer: D,E
NEW QUESTION # 38
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. [mysqld]
default_authentication_plugin=mysql_native_password - B. [mysqld]
default_authentication_plugin=caching_sha2_password - C. ALTER USER user -
IDENTIFIED WITH sha256_password -
BY 'password'; - D. [mysqld]
default_authentication_plugin=sha256_password - E. ALTER USER user -
IDENTIFIED WITH caching_sha2_password
BY 'password'; - F. ALTER USER user -
IDENTIFIED WITH mysql_native_password
BY 'password';
Answer: C
NEW QUESTION # 39
Examine this command, which executes successfully on InnoDB Cluster: dba.dropMetadataSchema() Which two statements are true? (Choose two.)
- A. The command drops the mysql_innodb_cluster_metadata schema and re-creates it.
- B. Connections driven by MySQL Router are not affected by the command.
- C. The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.
- D. Group Replication will be dissolved and all metadata purged.
- E. Group Replication is still operational, but InnoDB Cluster must be reimported under MySQL Shell.
- F. The mysql_innodb_cluster_metadata schema is dropped from all reachable members of the cluster.
Answer: B,C
NEW QUESTION # 40
Which two commands will display indexes on the parts table in the manufacturing schema? (Choose two.)
- A. SELECT * FROM information_schema.COLUMN_STATISTICS;
- B. DESCRIBE manufacturing.parts;
- C. SHOW INDEXES FROM manufacturing.parts;
- D. SELECT * FROM information_schema.statistics WHERE table_schema='manufacturing' AND TABLE_NAME='parts';
- E. EXPLAIN SELECT INDEXES FROM manufacturing.parts;
Answer: A,D
NEW QUESTION # 41
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)
- A. It does not support the transportable tablespaces feature.
- B. It decrypts data for use in memory.
- C. It supports all indexes transparently.
- D. It enforces encryption from disk to memory and over network transmission.
- E. It supports only non-blob datatypes.
Answer: B,C
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/faqs-tablespace-encryption.html
NEW QUESTION # 42
Which statement is true about InnoDB persistent index statistics?
- A. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
- B. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
- C. Updating index statistics is an I/O expensive operation.
- D. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
- E. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
- F. Tables are scanned and index statistics recalculated when an instance is restarted.
Answer: E
NEW QUESTION # 43
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;
- A. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
- B. SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
RESET SLAVE; - C. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa—aaaaaaaaaaaa:1-10300;
RESET MASTER; - D. bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
RESET SLAVE; - E. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb-
Answer: B
NEW QUESTION # 44
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. MEMORY
- B. ARCHIVE
- C. NDB
- D. BLACKHOLE
- E. InnopB
- F. MyISAM
Answer: C,D,F
NEW QUESTION # 45
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. employee
- C. world
- D. information_schema
- E. mysql
Answer: A,D
Explanation:
Explanation/Reference: https://mysqlserverteam.com/introducing-mysqlpump/
NEW QUESTION # 46
Which two are true about binary logs used in asynchronous replication? (Choose two.)
- A. They are pushed from the master to the slave.
- B. They contain events that describe database changes on the master.
- C. They contain events that describe only administrative commands run on the master.
- D. They contain events that describe all queries run on the master.
- E. They are pulled from the master to the slave.
Answer: A,B
Explanation:
Explanation/Reference: https://www.oracle.com/technetwork/community/developer-day/mysql-replication-presentation-
485890.pdf (14)
NEW QUESTION # 47
Examine this command and output:
Which two options will improve the security of the MySQL instance? (Choose two.)
- A. Remove the world read/execute privilege from the accounting directory.
- B. Change the parent directory owner and group to mysql.
- C. Change the group ownership of the mysql directory to the mysql user group.
- D. Remove world read privileges from the server-cert.pem certificate file.
- E. Remove world read privileges from the public_key.pem file.
- F. Remove group read/write privileges from the private_key.pem file.
Answer: B,C
NEW QUESTION # 48
Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)
- A. cluster.forceQuorumUsingPartitionOf()
- B. dba.configureInstance()
- C. cluster.setPrimaryInstance()
- D. dba.createCluster()
- E. cluster.addInstance()
- F. dba.checkInstanceConfiguration()
- G. dba.configureLocalInstance()
Answer: A,C
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-shell-8.0-relnotes-en/news-8-0-16.html
NEW QUESTION # 49
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_IDENTITY
- B. VERIFY_CA
- C. DISABLED
- D. PREFERRED
- E. REQUIRED
Answer: A,B
Explanation:
Explanation
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html
NEW QUESTION # 50
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)
- A. It does not support the transportable tablespaces feature.
- B. It decrypts data for use in memory.
- C. It supports all indexes transparently.
- D. It enforces encryption from disk to memory and over network transmission.
- E. It supports only non-blob datatypes.
Answer: B,C
NEW QUESTION # 51
......
Use Valid New 1Z0-908 Test Notes & 1Z0-908 Valid Exam Guide: https://www.exams4collection.com/1Z0-908-latest-braindumps.html
1Z0-908 exam torrent Oracle study guide: https://drive.google.com/open?id=1XtgHL7kuFo_J9Rv2vPkWFNdMbrVlCseR
