[2022] Pass Oracle 1z1-908 Test Practice Test Questions Exam Dumps
Verified 1z1-908 dumps Q&As - 1z1-908 dumps with Correct Answers
NEW QUESTION 15
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. SELECT email,passwd FROM members
- C. WHERE email = ‘INSERT INTO members(‘email’,’passwd’) VALUES
(‘[email protected]’, ‘secret’);--‘;
SELECT user, phone FROM customers WHERE name = ‘\; DROP TABLE users; --‘; - D. SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);
- E. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;
- F. WHERE user = ‘?’;INSERT INTO members(‘user’,’passwd’) VALUES
(‘[email protected]’,‘secret’);--‘;
Answer: B,E
NEW QUESTION 16
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 only administrative commands run on the master.
- C. They are pulled from the master to the slave.
- D. They contain events that describe database changes on the master.
- E. They contain events that describe all queries run on the master.
Answer: A,D
NEW QUESTION 17
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. world
- B. sys
- C. mysql
- D. information_schema
- E. employee
Answer: B,D
Explanation:
Explanation/Reference: https://mysqlserverteam.com/introducing-mysqlpump/
NEW QUESTION 18
A valid raw backup of the shop.customers MyISAM table was taken.
You must restore the table. You begin with these steps:
1. Confirm that secure_file_priv='/var/tmp'
2. mysql> DROP TABLE shop.customers;
3. shell> cp /backup/customers.MY* /var/lib/mysql/shop/
Which two actions are required to complete the restore? (Choose two.)
- A. shell> cp /backup/customers.sdi /var/tmp
- B. mysql> SOURCE '/var/tmp/customers.sdi'
- C. shell> cp /backup/customers.sdi /var/lib/mysql/shop/
- D. mysql> IMPORT TABLE FROM /var/tmp/customers.sdi
- E. mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi
- F. mysql> ALTER TABLE shop.customers IMPORT TABLESPACE
- G. mysql> ALTER TABLE shop.customers DISCARD TABLESPACE
- H. shell> cp /backup/customers.frm /var/lib/mysql/shop/
Answer: D,F
NEW QUESTION 19
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. It guarantees near real-time replication between a master and a slave.
- C. MySQL Enterprise Backup will automatically back up from an available slave.
- D. You can scale reads by adding multiple slaves.
- E. You can scale writes by creating a replicated mesh.
Answer: A,D
NEW QUESTION 20
You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)
- A. Use resource groups to lock different instances on separate CPUs.
- B. Run MySQL Server docker containers.
- C. Use systemdwith different settings for each instance.
- D. Start mysqldor mysqld_safeusing different option files for each instance.
- E. Run mysqldwith --datadirdefined for each instance.
- F. Use system tools to lock each instance to its own CPU.
Answer: C,D,E
Explanation:
Explanation/Reference:
NEW QUESTION 21
On examination, your MySQL installation datadir has become recursively world read/write/executable.
What are two major concerns of running an installation with incorrect file privileges? (Choose two.)
- A. SQL injections could be used to insert bad data into the database.
- B. Data files could be deleted.
- C. MySQL binaries could be damaged, deleted, or altered.
- D. Users could overwrite configuration files.
- E. Extra startup time would be required for the MySQL server to reset the privileges.
Answer: B,E
NEW QUESTION 22
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 your backup from a slave of the MySQL system.
- C. Take a physical backup of the MySQL system.
- D. Take a logical backup of the MySQL system.
Answer: D
NEW QUESTION 23
Which two statements are true about the mysql_config_editor program? (Choose two.)
- A. It manages the configuration of client programs.
- B. It will use [client] options by default unless you provide --login-path.
- C. It can be used to create and edit SSL certificates and log locations.
- D. It manages the configuration of the MySQL Firewall feature.
- E. It manages the configuration of user privileges for accessing the server.
- F. It can move datadir to a new location.
- G. It provides an interface to change my.cnf files.
Answer: A,B
NEW QUESTION 24
You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?
- A. installing and configuring the Connection Control plugin
- B. using PREPARED STATEMENTS
- C. avoiding concatenation of SQL statements and user-supplied values in an application
- D. using stored procedures for any database access
Answer: D
Explanation:
Explanation/Reference: https://www.ptsecurity.com/ww-en/analytics/knowledge-base/how-to-prevent-sql-injection-attacks/
NEW QUESTION 25
Examine the modified output:
Seconds_Behind_ Mastervalue is steadily growing.
What are two possible causes? (Choose two.)
- A. The parallel slave threads are experiencing lock contention.
- B. The master is most probably too busy to transmit data and the slave needs to wait for more data.
- C. One or more large tables do not have primary keys.
- D. This value shows only I/O latency and is not indicative of the size of the transaction queue.
- E. The master is producing a large volume of events in parallel but the slave is processing them serially.
Answer: D,E
Explanation:
Explanation
NEW QUESTION 26
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. John has not activated the role.
- B. John needs to reconnect to the database.
- C. The DBA needs to execute FLUSH PRIVILEGES.
- D. The statement was blocked by MySQL Firewall.
Answer: A
NEW QUESTION 27
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. world
- B. sys
- C. mysql
- D. information_schema
- E. employee
Answer: B,D
NEW QUESTION 28
A MySQL server is monitored using MySQL Enterprise Monitor's agentless installation.
Which three features are available with this installation method? (Choose three.)
- A. operating system memory utilization
- B. network-related information and network characteristics
- C. security-related advisor warnings
- D. MySQL Replication monitoring
- E. MySQL Query Analysis data
- F. CPU utilization
- G. disk usage and disk characteristics including disk advisors warnings
Answer: C,E,G
NEW QUESTION 29
Which two are features of MySQL Enterprise Firewall? (Choose two.)
- A. blocking of potential threats by configuring pre-approved whitelists
- B. recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands
- C. modifying SQL statement dynamically with substitutions
- D. automatic locking of user accounts who break your firewall
- E. provides stateless firewall access to TCP/3306
Answer: A,C
NEW QUESTION 30
Examine this query and output:
Which two statements are true? (Choose two.)
- A. The query returns exactly 125 rows.
- B. It takes more than 8 milliseconds to sort the rows.
- C. 35 rows from the city table are included in the result.
- 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: C,E
NEW QUESTION 31
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. ADMIN OPTION causes the role to be activated by default.
- C. Mark can grant the privileges assigned to the r_read@localhost role to another user.
- D. Mark must connect from localhost to activate the r_read@localhost role.
- E. ADMIN OPTION allows Mark to drop the role.
- F. Mark can revoke the r_read@localhost role from another role.
Answer: C,E
NEW QUESTION 32
......
1z1-908 certification guide Q&A from Training Expert Pass4SureQuiz: https://www.pass4surequiz.com/1z1-908-exam-quiz.html
The Best MySQL Database Administration Study Guide for the 1z1-908 Exam: https://drive.google.com/open?id=1yVJWjpxqIb-Ke2Um5ZFFyCwYu5wrUkcj