1Z0-908 Training & Certification Get Latest MySQL Database Administration Updated on Sep 11, 2021
Certification Training for 1Z0-908 Exam Dumps Test Engine
NEW QUESTION 39
You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?
- A. using stored procedures for any database access
- B. installing and configuring the Connection Control plugin
- C. using PREPARED STATEMENTS
- D. avoiding concatenation of SQL statements and user-supplied values in an application
Answer: A
NEW QUESTION 40
You want to check the values of the sort_buffer_sizesession variables of all existing connections.
Which performance_schematable can you query?
- A. user_variables_by_thread
- B. global_variables
- C. variables_by_thread
- D. session_variables
Answer: D
Explanation:
Explanation/Reference: https://dev.mysql.com/worklog/task/?id=6629
NEW QUESTION 41
Which two are use cases of MySQL asynchronous replication? (Choose two.)
- A. MySQL Enterprise Backup will automatically back up from an available slave.
- B. It guarantees near real-time replication between a master and a slave.
- C. You can scale writes by creating a replicated mesh.
- D. It allows backup to be done on the slave without impacting the master.
- E. You can scale reads by adding multiple slaves.
Answer: D,E
NEW QUESTION 42
Which two statements are true about MySQL server multi-source replication? (Choose two.)
- A. It is not compatible with auto-positioning.
- B. It relies on relay_log_recovery for resilient operations.
- C. It does not attempt to detect or resolve replication conflicts.
- D. It must use GTID replication.
- E. It uses only time-based replication conflict resolution.
- F. It needs to be re-instanced after a crash to maintain consistency.
Answer: D,E
NEW QUESTION 43
Examine this MySQL Shell command:
dba.rebootClusterFromCompleteOutage()
Which two statements are true? (Choose two.)
- A. It performs InnoDB Cluster instances rolling restart.
- B. It reconfigures InnoDB Cluster if the cluster was stopped.
- C. It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.
- D. It is not mandatory that all instances are running and reachable before running the command.
- E. It only stops and restarts all InnoDB Cluster instances.
- F. It stops and restarts all InnoDB Cluster instances and initializes the metadata.
- G. It only starts all InnoDB Cluster instances.
Answer: A,D
NEW QUESTION 44
Examine this query and output:
Which two statements are true? (Choose two.)
- A. The country table is accessed as the first table, and then joined to the city table.
- B. The optimizer estimates that 51 rows in the country table have Continent = 'Asia'.
- C. 35 rows from the city table are included in the result.
- D. It takes more than 8 milliseconds to sort the rows.
- E. The query returns exactly 125 rows.
Answer: B,C
NEW QUESTION 45
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 databases, excluding master metadata, are backed up to the output file.
- D. All binary logs are deleted from the master.
- E. All binary logs are backed up and then deleted.
- F. All details regarding deleted logs and master metadata are captured in the output file.
Answer: C,D
NEW QUESTION 46
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 databases, excluding master metadata, are backed up to the output file.
- D. All binary logs are deleted from the master.
- E. All binary logs are backed up and then deleted.
- F. All details regarding deleted logs and master metadata are captured in the output file.
Answer: C,D
NEW QUESTION 47
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. InnopB
- B. MEMORY
- C. BLACKHOLE
- D. ARCHIVE
- E. MyISAM
- F. NDB
Answer: C,E,F
NEW QUESTION 48
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. employee
- C. mysql
- D. world
- E. sys
Answer: A,E
NEW QUESTION 49
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 SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions will free up disk space.
- B. Executing ALTER TABLE transactions will enable you to free up disk space.
- C. The transactions table was created with innodb_file_per_table=OFF.
- D. Truncating the transactions table will free up the most disk space.
- E. Truncating the sales and leads table will free up disk space.
Answer: A,C
NEW QUESTION 50
Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.)
- A. sort_buffer_size
- B. innodb_buffer_pool_size
- C. key_buffer_size
- D. tmp_table_size
- E. table_open_cache
- F. read_buffer_size
Answer: A,C,D
NEW QUESTION 51
A colleague complains about slow response time on your website.
Examine this query and output:
What is the most likely cause for the high number of lock waits?
- A. You use the InnoDB storage engine and statements wait while data is inserted.
- B. You use the MyISAM storage engine for most common tables.
- C. Your table accesses wait for the operating system level flush.
- D. The Innodb Buffer pool is full.
Answer: A
NEW QUESTION 52
Examine the modified output:
Seconds_Behind_ Master value 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. The master is most probably too busy to transmit data and the slave needs to wait for more data.
- C. The parallel slave threads are experiencing lock contention.
- D. One or more large tables do not have primary keys.
- E. The master is producing a large volume of events in parallel but the slave is processing them serially.
Answer: A,E
NEW QUESTION 53
Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)
- A. named pipes
- B. TCP/IP
- C. X Protocol
- D. SOCKET
- E. shared memory
- F. UDP
Answer: A,B,E
NEW QUESTION 54
Which command enables rule-based MySQL Auditing capabilities?
- A. shell> mysql < audit_log_filter_linux_install.sql
- B. shell> mysqld --initialize --log-raw=audit.log
- C. mysql> INSTALL COMPONENT audit_log;
- D. mysql> INSTALL PLUGIN audit_log;
Answer: A
NEW QUESTION 55
......
Step by Step Guide to Prepare for 1Z0-908 Exam: https://www.trainingdump.com/Oracle/1Z0-908-practice-exam-dumps.html
MySQL Database Administration 1Z0-908 Real Exam Questions and Answers FREE Updated: https://drive.google.com/open?id=1aTnUhT8F5Cy_kDF0aCudPiaUqymbSVTN