1z1-908 Practice Test Questions Updated 142 Questions
Oracle 1z1-908 Dumps - Secret To Pass in First Attempt
NEW QUESTION # 57
You must configure the MySQL command-line client to provide the highest level of trust and security when connecting to a remote MySQL Server.
Which value of --ssl-mode will do this?
- A. VERIFY_IDENTITY
- B. REQUIRED
- C. PREFERRED
- D. VERIFY_CA
Answer: B
NEW QUESTION # 58
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. REQUIRED
- B. PREFERRED
- C. VERIFY_CA
- D. DISABLED
- E. VERIFY_IDENTITY
Answer: C,E
Explanation:
Explanation
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html
NEW QUESTION # 59
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 all queries run on the master.
- C. They are pushed from the master to the slave.
- D. They contain events that describe database changes on the master.
- E. They are pulled from the master to the slave.
Answer: C,D
NEW QUESTION # 60
Examine the modified output:
Seconds_Behind_ Mastervalue is steadily growing.
What are two possible causes? (Choose two.)
- A. The master is producing a large volume of events in parallel but the slave is processing them serially.
- B. The master is most probably too busy to transmit data and the slave needs to wait for more data.
- C. This value shows only I/O latency and is not indicative of the size of the transaction queue.
- D. The parallel slave threads are experiencing lock contention.
- E. One or more large tables do not have primary keys.
Answer: A,C
Explanation:
Explanation
NEW QUESTION # 61
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. REQUIRED
- C. PREFERRED
- D. VERIFY_CA
- E. DISABLED
Answer: B
NEW QUESTION # 62
Which two are features of MySQL Enterprise Firewall? (Choose two.)
- A. modifying SQL statement dynamically with substitutions
- B. automatic locking of user accounts who break your firewall
- C. blocking of potential threats by configuring pre-approved whitelists
- D. provides stateless firewall access to TCP/3306
- E. recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands
Answer: C,E
NEW QUESTION # 63
Which two storage engines provide a view of the data consistent with the storage system at any moment?
(Choose two.)
- A. MyISAM
- B. InnoDB
- C. NDB
- D. MEMORY
- E. ARCHIVE
Answer: A,D
NEW QUESTION # 64
Examine these entries from the general query log:
All UPDATE statements reference existing rows.
Which describes the outcome of the sequence of statements?
- A. Connection 25 experiences a lock wait timeout.
- B. A deadlock occurs immediately.
- C. A deadlock occurs after innodb_lock_wait_timeout seconds.
- D. All statements execute without error.
- E. Connection 24 experiences a lock wait timeout.
Answer: C
NEW QUESTION # 65
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 # 66
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 email = ‘INSERT INTO members(‘email’,’passwd’) VALUES
(‘[email protected]’, ‘secret’);--‘;
SELECT user, phone FROM customers WHERE name = ‘\; DROP TABLE users; --‘; - C. WHERE user = ‘?’;INSERT INTO members(‘user’,’passwd’) VALUES
(‘[email protected]’,‘secret’);--‘; - D. SELECT email,passwd FROM members
- E. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;
- F. SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);
Answer: D,E
NEW QUESTION # 67
You encountered an insufficient privilege error in the middle of a long transaction.
The database administrator is informed and immediately grants the required privilege:
GRANT UPDATE ON world.city TO 'user1';
How can you proceed with your transaction with the least interruption?
- A. Roll back the transaction and start the transaction again in the same session.
- B. Change the default database and re-execute the failed statement in your transaction.
- C. Close the connection, reconnect, and start the transaction again.
- D. Re-execute the failed statement in your transaction.
Answer: D
NEW QUESTION # 68
Examine this query:
What information does this query provide?
- A. total memory used across all connections associated with the user on connection number 10
- B. total memory used by the first 10 threads
- C. total memory used by thread number 10
- D. total memory used by connection number 10
- E. total memory used by the first 10 connections
- F. total memory used across all connections associated with the user on thread number 10
Answer: D
NEW QUESTION # 69
Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)
- A. cluster.addInstance()
- B. dba.configureLocalInstance()
- C. cluster.setPrimaryInstance()
- D. cluster.forceQuorumUsingPartitionOf()
- E. dba.createCluster()
- F. dba.configureInstance()
- G. dba.checkInstanceConfiguration()
Answer: C,D
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-shell-8.0-relnotes-en/news-8-0-16.html
NEW QUESTION # 70
You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:
Which statement is true?
- A. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
- B. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
- C. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-cccccccccccc GTIDs.
- D. Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbb GTIDs in its binary logs.
- E. Replication will work.
Answer: B
NEW QUESTION # 71
Examine these statements, which execute successfully:
CREATE ROLE r_world_rd;
GRANT SELECT ON world.* TO r_world_rd;
CREATE USER john IDENTIFIED BY 'P@ssw0rd';
GRANT r_world_rd TO john;
Examine these statements issued by user John:
What is the reason for the error?
- A. The DBA needs to execute FLUSH PRIVILEGES.
- B. John has not activated the role.
- C. The statement was blocked by MySQL Firewall.
- D. John needs to reconnect to the database.
Answer: B
NEW QUESTION # 72
You want to check the values of the sort_buffer_size session variables of all existing connections.
Which performance_schema table can you query?
- A. global_variables
- B. session_variables
- C. user_variables_by_thread
- D. variables_by_thread
Answer: B
NEW QUESTION # 73
Examine this command and output:
Which two statements are true? (Choose two.)
- A. The lock is at the table object level.
- B. The lock is an exclusive lock.
- C. The lock is a row-level lock.
- D. The lock is an intentional lock.
- E. The lock is a shared lock.
- F. The lock is at the metadata object level.
Answer: B,C
NEW QUESTION # 74
Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)
- A. TCP/IP
- B. named pipes
- C. X Protocol
- D. shared memory
- E. SOCKET
- F. UDP
Answer: A,B,D
NEW QUESTION # 75
Which statement is true about InnoDB persistent index statistics?
- A. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
- B. Tables are scanned and index statistics recalculated when an instance is restarted.
- C. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
- D. Updating index statistics is an I/O expensive operation.
- E. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
- F. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
Answer: A
NEW QUESTION # 76
Which two are use cases of MySQL asynchronous replication? (Choose two.)
- A. It allows backup to be done on the slave without impacting the master.
- B. You can scale reads by adding multiple slaves.
- C. It guarantees near real-time replication between a master and a slave.
- D. You can scale writes by creating a replicated mesh.
- E. MySQL Enterprise Backup will automatically back up from an available slave.
Answer: A,B
NEW QUESTION # 77
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. Use the Clone Plugin to copy the data to another MySQL system.
- B. Take a physical backup of the MySQL system.
- C. Take a logical backup of the MySQL system.
- D. Take your backup from a slave of the MySQL system.
Answer: C
NEW QUESTION # 78
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. Use the Clone Plugin to copy the data to another MySQL system.
- B. Take a physical backup of the MySQL system.
- C. Take a logical backup of the MySQL system.
- D. Take your backup from a slave of the MySQL system.
Answer: C
NEW QUESTION # 79
Examine this command, which executes successfully:
Which two statements are true? (Choose two.)
- A. A raw backup is created.
- B. The backup operation will finish only when backup-and-apply-log is executed.
- C. A single-file backup is created.
- D. The --backup-dir option holds temporary output, status, and metadata files.
- E. The backup operation will finish only when apply-log is executed.
Answer: D,E
NEW QUESTION # 80
Which two statements are true about raw binary backups? (Choose two.)
- A. The resulting files are easily human readable.
- B. They are required to obtain FIPS security compliance.
- C. They are faster than logical backups because the process is a simple file or file system copy.
- D. The data format is identical to how MySQL stores the data on disk.
- E. They are converted to a highly compressible binary format.
Answer: A,D
NEW QUESTION # 81
......
Oracle 1z1-908 Exam Dumps [2024] Practice Valid Exam Dumps Question: https://www.updatedumps.com/Oracle/1z1-908-updated-exam-dumps.html
1z1-908 Dumps - Grab Out For [NEW-2024] Oracle Exam: https://drive.google.com/open?id=1lXVTIx2wXxVU7xdx0GieyYCUf4Ylklrr