Updated Oct 23, 2021 Verified 1z1-908 dumps Q&As - 100% Pass
New 2021 Latest Questions 1z1-908 Dumps - Use Updated Oracle Exam
Topics of Oracle 1Z0-908: MySQL 8.0 Database Exam
The Oracle 1Z0-908 exam tests the abilities and knowledge of the candidates by checking the following objectives:
Architecture
- Understand and use the Data Dictionary
- Configure client connections to the server
- Configure buffers and caches
- Understand how InnoDB stores data and logs
- Understand how MySQL stores data
Server Installation and Configuration
- Start and stop MySQL
- Configure MySQL by using options and option files
- Launch multiple MySQL servers on the same host
- Upgrade MySQL
- Install and use the MySQL server and client programs
- Configure MySQL variables
- Identify the files and folders created during the installation
Security
- Encrypt MySQL data
- Recognize common security risks
- Prevent SQL injection attacks
- Use authentication plug-ins
- Control user and role permissions
- Provide the password and login security
- Secure MySQL server connections
- Secure the MySQL host environment
- Configure MySQL Enterprise Firewall
- Create user accounts and roles
Monitoring and Maintenance
- Monitor MySQL processes and status
- Troubleshoot problems with locked resources
- Monitor database growth and explain capacity planning
- Configure MySQL Enterprise Audit
- Use MySQL Enterprise Monitor to view activity in MySQL
- Configure and view MySQL log files
Query Optimization
- Create indexes to improve server performance
- Monitor and understand index statistics
- Analyze queries with MySQL Enterprise Monitor
- Examine how MySQL optimizes queries
Backups and Recovery
- Backup and restore data with MySQL Enterprise Backup
- Distinguish between the different types of backup
- Back up the binary log
- Use mysqldump and mysqlpump to perform logical backups
- Implement a backup strategy
- Explain when and how to use raw file backups
High Availability Techniques
- Describe MySQL InnoDB Cluster and Group Replication
- Explain the role of the binary log in replication
- Configure replication
- Explain how replication provides high availability and scalability
- Explain the role of replication threads
- Perform an InnoDB cluster recovery
- Configure multisource replication
- Configure a MySQL InnoDB cluster
- Monitor and troubleshoot replication
What is the duration, language, and format of Oracle 1Z0-908: MySQL 8.0 Database Exam
- There is a time limit of 140 minutes for the exam.
- This exam is offered in only English.
- Certification Validity period: 3 years.
- This exam consists of 90 questions.
- Section 3: 33%
- The type of questions is Multiple Choice Questions.
- Section 2: 45%
- Section 1: 60%
- Passing score:
Oracle database certifications require periodic recertification. To hold your certification inactive condition, you must update to the new edition within 1 year of Oracle’s credential withdrawal.
NEW QUESTION 51
Which step or set of steps can be used to rotate the error log?
- A. Execute SET GLOBAL expire_logs_days=0 to enforce a log rotation.
- B. Execute SET GLOBAL log_error = '<new error log file>'.
- C. Execute SET GLOBAL max_error_count = <number of messages at point to rotate>.
- D. Rename the error log file on disk, and then execute FLUSH ERROR LOGS.
Answer: D
NEW QUESTION 52
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. VERIFY_IDENTITY
- C. PREFERRED
- D. DISABLED
- E. VERIFY_CA
Answer: A
NEW QUESTION 53
You execute this command:
shell> mysqlpump --exclude-databases=% --users
Which statement is true?
- A. It creates a logical backup of all metadata, but contains no table data.
- B. It creates a logical backup of all MySQL user accounts.
- C. It returns an error because the mysqldumpcommand should have been used.
- D. It creates a logical backup of only the usersdatabase.
Answer: A
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/mysqlpump.html
NEW QUESTION 54
Which two commands will display indexes on the partstable in the manufacturing schema? (Choose two.) \
- A. DESCRIBE manufacturing.parts;
- B. SELECT * FROM information_schema.COLUMN_STATISTICS;
- C. SELECT * FROM information_schema.statistics WHERE table_schema=’manufacturing’
AND TABLE_NAME=’parts’; - D. SHOW INDEXES FROM manufacturing.parts;
- E. EXPLAIN SELECT INDEXES FROM manufacturing.parts;
Answer: B,C
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E11882_01/server.112/e40540/indexiot.htm#CNCPT912
NEW QUESTION 55
Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.)
- A. innodb_buffer_pool_size
- B. key_buffer_size
- C. read_buffer_size
- D. tmp_table_size
- E. sort_buffer_size
- F. table_open_cache
Answer: B,D,E
NEW QUESTION 56
Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)
- A. table data
- B. primary indexes
- C. user privileges
- D. change buffer
- E. doublewrite buffer
- F. InnoDB Data Dictionary
Answer: E,F
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/innodb-system-tablespace.html
NEW QUESTION 57
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 group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
- B. A manual intervention to force group members to be only the working two instances is required.
- C. The cluster has built-in high availability and updates group_replication_ip_whitelistto remove the unreachable nodes.
- D. The cluster will shut down to preserve data consistency.
- E. 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.
Answer: C,D
NEW QUESTION 58
Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)
- A. ADMIN OPTION allows Mark to drop the role.
- B. Mark must connect from localhost to activate the r_read@localhost role.
- C. Mark can grant the privileges assigned to the r_read@localhost role to another user.
- D. Mark can revoke the r_read@localhost role from another role.
- E. ADMIN OPTION causes the role to be activated by default.
- F. Mark can grant the r_read@localhost role to another user.
Answer: A,C
NEW QUESTION 59
Which three statements are true about MySQL replication? (Choose three.)
- A. Any instance can have multiple slaves, but it can have only one master.
- B. Each slave must have its own MySQL user for replication.
- C. Binary logs contain only transactions originating from a single MySQL instance.
- D. Each instance in a replication topology must have a unique server ID.
- E. Replication can use only TCP/IP connections.
- F. A replication user must have the SELECT privilege for all tables that need to be replicated.
- G. Binary logging must be enabled on the master in order to replicate to other instances.
Answer: D,F,G
NEW QUESTION 60
The data in this instance is transient; no backup or replication will be required. It is currently under performing.
* The database size is static and including indexes is 19G.
* Total system memory is 32G.
After profiling the system, you highlight these MySQL status and global variables:
The OS metrics indicate that disk is a bottleneck.
Other variables retain their default values.
Which three changes will provide the most benefit to the instance? (Choose three.)
- A. innodb_undo_directory=/dev/shm
- B. sync_binlog=0
- C. buffer_pool_size=24G
- D. max_connections=10000
- E. innodb_flush_log_at_trx_commit=1
- F. innodb_log_file_size=1G
- G. innodb_doublewrite=0
Answer: D,E,F
Explanation:
Explanation/Reference: https://aws.amazon.com/blogs/database/best-practices-for-configuring-parameters-for-amazon- rds-for-mysql-part-1-parameters-related-to-performance/
NEW QUESTION 61
Which three are characteristics of a newly created role? (Choose three.)
- A. It can be protected with a password.
- B. It can be dropped using the DROP ROLEstatement.
- C. It can be granted to user accounts.
- D. It is created as a locked account.
- E. It can be renamed using the RENAME ROLEstatement.
- F. It is stored in the mysql.roletable.
Answer: A,B,C
Explanation:
Explanation/Reference:
NEW QUESTION 62
Examine these statements and output:
Which statement is true?
- A. The user is authorized as the rsmith@localhost user.
- B. The user failed to define a username and the connecting username defaulted to ''@'%'.
- C. The user is authenticated as the anonymous proxy user ''@'%'.
- D. The user is authorized as the accounting@localhost user.
- E. The user is logged in with --user=accounting as an option.
Answer: A
NEW QUESTION 63
Which two queries are examples of successful SQL injection attacks? (Choose two.)
- A. SELECT user,passwd FROM members
WHERE user = '?';INSERT INTO members('user','passwd') VALUES
('[email protected]','secret');--'; - B. SELECT email,passwd FROM members
WHERE email = 'INSERT INTO members('email','passwd') VALUES ('[email protected]',
'secret');--'; - C. SELECT user, phone FROM customers WHERE name = '\; DROP TABLE users; --';
- D. SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;
- 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: B,E
NEW QUESTION 64
You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)
- A. The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.
- B. The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.
Section: (none)
Explanation - C. The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.
- D. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.
- E. The mysqlcheck --optimize --all-databases command reclaims free space from table files.
Answer: A,B
NEW QUESTION 65
Which four are types of information stored in the MySQL data dictionary? (Choose four.)
- A. performance metrics
- B. table definitions
- C. server configuration rollback
- D. InnoDB buffer pool LRU management data
- E. stored procedure definitions
- F. access control lists
- G. view definitions
- H. server runtime configuration
Answer: B,C,E,G
NEW QUESTION 66
Binary log events for the ‘mydb1’ schema must be copied to a different schema name ‘mydb2’.
Which command will do this?
- A. mysqlbinlog --rewrite-db=’mydb1->mydb2’ | mysql
- B. mysqlbinlog --read-from-remote-server --raw | sed ‘s/mydb1/mydb2/g’ | mysql
- C. mysqlbinlog --rewrite-db=’mydb1’ --rewrite-db=’mydb2’ | mysql
- D. mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql
Answer: B
NEW QUESTION 67
......
Latest 1z1-908 Exam Dumps Oracle Exam from Training: https://www.real4dumps.com/1z1-908_examcollection.html
Pass Oracle 1z1-908 PDF Dumps Recently Updated 86 Questions: https://drive.google.com/open?id=1qAQyiNCR889eQBzIYHtKTHxvEv2zaS5z
