[Oct-2021] Dumps Brief Outline Of The 1Z0-908 Exam - ITCertMagic
1Z0-908 Training & Certification Get Latest MySQL Database Administration
NEW QUESTION 32
You execute this command:
shell> mysqlpump --exclude-databases=% --users
Which statement is true?
- A. It creates a logical backup of all MySQL user accounts.
- B. It creates a logical backup of all metadata, but contains no table data.
- C. It returns an error because the mysqldumpcommand should have been used.
- D. It creates a logical backup of only the usersdatabase.
Answer: B
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/mysqlpump.html
NEW QUESTION 33
Which two are features of MySQL Enterprise Firewall? (Choose two.)
- A. automatic locking of user accounts who break your firewall
- B. modifying SQL statement dynamically with substitutions
- C. provides stateless firewall access to TCP/3306
- D. blocking of potential threats by configuring pre-approved whitelists
- E. recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands
Answer: B,D
NEW QUESTION 34
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 35
Examine this statement and output:
You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)
- A. QN = 4
- B. QN = 1
- C. QN = 3
- D. QN = 5
- E. QN = 2
Answer: B,E
NEW QUESTION 36
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 37
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
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/mysql-installer-workflow.html
NEW QUESTION 38
Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)
- A. dba.checkInstanceConfiguration()
- B. cluster.setPrimaryInstance()
- C. dba.configureInstance()
- D. dba.createCluster()
- E. dba.configureLocalInstance()
- F. cluster.addInstance()
- G. cluster.forceQuorumUsingPartitionOf()
Answer: B,G
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-shell-8.0-relnotes-en/news-8-0-16.html
NEW QUESTION 39
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. Re-execute the failed statement in your transaction.
- B. Change the default database and re-execute the failed statement in your transaction.
- C. Roll back the transaction and start the transaction again in the same session.
- D. Close the connection, reconnect, and start the transaction again.
Answer: A
NEW QUESTION 40
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 adds more temporary workspace in addition to the innodb_tmpdir location.
- C. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
- D. It is not necessary because innodb_data_home_dir is already defined.
- E. It defines all innodb tablespace options relative to a starting parent directory.
Answer: D
NEW QUESTION 41
You want to log only the changes made to the database objects and data on the MySQL system.
Which log will do this by default?
- A. audit log
- B. binary log
- C. slow query log
- D. general query log
- E. error log
Answer: B
NEW QUESTION 42
Examine this command, which executes successfully:
cluster.addInstance('<user>@<host>:<port>', {recoveryMethod: 'clone'})
Which three statements are true? (Choose three.)
- A. InnoDB tablespaces outside the datadir are able to be cloned.
- B. InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.
- C. It is always slower than {recoveryMethod: 'incremental'}.
- D. A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.
- E. A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.
- F. The account used to perform this recovery needs the BACKUP_ADMIN privilege.
Answer: B,C,F
NEW QUESTION 43
There are five MySQL instances configured with a working group replication.
Examine the output of the group members:
Which two statements are true about network partitioning in the cluster? (Choose two.)
- A. The cluster will shut down to preserve data consistency.
- B. The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.
- C. There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.
- D. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
- E. A manual intervention to force group members to be only the working two instances is required.
Answer: A,B
NEW QUESTION 44
Which two statements are true about using backups of the binary log? (Choose two.)
- A. They allow for point-in-time recovery of the data.
- B. Binary logs can always be used to unapply unwanted schema changes.
- C. Multiple binary logs can be used to restore data.
- D. Multiple binary logs can be applied in parallel for faster data restoration.
- E. Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.
Answer: A,B
NEW QUESTION 45
Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)
- A. The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.
- B. It is possible to retrieve a normalized statement, but never the exact statement that was executed.
- C. It is possible to import data into the Query Analyzer from heterogeneous sources, such as CSV.
- D. It is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.
- E. It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.
Answer: D,E
NEW QUESTION 46
t is a non-empty InnoDB table.
Examine these statements, which are executed in one session:
BEGIN;
SELECT * FROM t FOR UPDATE;
Which is true?
- A. If OPTIMIZE LOCAL TABLE t; is invoked from another session, it executes normally and returns the status.
- B. mysqlcheck --analyze --all-databases will execute normally on all tables and return a report.
- C. If OPTIMIZE TABLE; is invoked, it will create a table lock on t and force a transaction rollback.
- D. If ANALYZE TABLE; is invoked from the same session, it hangs until the transaction is committed or rolled back.
Answer: A
NEW QUESTION 47
......
Certification Training for 1Z0-908 Exam Dumps Test Engine: https://www.itcertmagic.com/Oracle/real-1Z0-908-exam-prep-dumps.html
MySQL Database Administration 1Z0-908 Real Exam Questions and Answers FREE Updated: https://drive.google.com/open?id=10hguRjJIgSpdJx4I7hjlDwiwFx8Oh8Z5