Free 1Z0-908 braindumps download (1Z0-908 exam dumps Free Updated Jan 24, 2022)
1Z0-908 Dumps for Pass Guaranteed - Pass 1Z0-908 Exam 2022
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 buffers and caches
- Understand how MySQL stores data
- Understand how InnoDB stores data and logs
- Configure client connections to the server
Server Installation and Configuration
- Configure MySQL variables
- Upgrade MySQL
- Configure MySQL by using options and option files
- Start and stop MySQL
Security
- Create user accounts and roles
- Secure the MySQL host environment
- Configure MySQL Enterprise Firewall
- Provide the password and login security
- Secure MySQL server connections
- Use authentication plug-ins
- Control user and role permissions
Monitoring and Maintenance
- Configure MySQL Enterprise Audit
- Monitor database growth and explain capacity planning
- Configure and view MySQL log files
- Monitor MySQL processes and status
Query Optimization
- Examine how MySQL optimizes queries
- Analyze queries with MySQL Enterprise Monitor
- Monitor and understand index statistics
- Create indexes to improve server performance
Backups and Recovery
- Use mysqldump and mysqlpump to perform logical backups
- Back up the binary log
- Explain when and how to use raw file backups
- Implement a backup strategy
High Availability Techniques
- Configure replication
- Explain how replication provides high availability and scalability
- Configure a MySQL InnoDB cluster
- Explain the role of replication threads
- Perform an InnoDB cluster recovery
- Monitor and troubleshoot replication
NEW QUESTION 29
Examine these statements and output:
Which statement is true?
- A. The user is authorized as the rsmith@localhostuser.
- B. The user is authenticated as the anonymous proxy user ‘’@’%’.
- C. The user is authorized as the accounting@localhostuser.
- D. The user is logged in with --user=accountingas an option.
- E. The user failed to define a username and the connecting username defaulted to ‘’@’%’.
Answer: A
NEW QUESTION 30
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. Use systemd with different settings for each instance.
- C. Start mysqld or mysqld_safe using different option files for each instance.
- D. Run MySQL Server docker containers.
- E. Run mysqld with --datadir defined for each instance.
- F. Use system tools to lock each instance to its own CPU.
Answer: B,C,E
NEW QUESTION 31
Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)
- A. cluster.forceQuorumUsingPartitionOf()
- B. dba.configureInstance()
- C. dba.createCluster()
- D. cluster.addInstance()
- E. dba.configureLocalInstance()
- F. dba.checkInstanceConfiguration()
- G. cluster.setPrimaryInstance()
Answer: A,G
NEW QUESTION 32
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 details regarding deleted logs and master metadata are captured in the output file.
- C. All binary logs are backed up and then deleted.
- D. All databases, excluding master metadata, are backed up to the output file.
- E. All binary logs are deleted from the master.
- F. All non-active binary logs are removed from the master.
Answer: D,E
NEW QUESTION 33
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 34
You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTERcommand are correct.
Examine the GTID information from both master and slave:
Which statement is true?
- A. Replication will work.
- B. Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbbGTIDs in its binary logs.
- C. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
- D. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
- E. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-ccccccccccccGTIDs.
Answer: C
Explanation:
Explanation/Reference: https://bugs.mysql.com/bug.php?id=86643
NEW QUESTION 35
Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?
- A. MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.
- B. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.
- C. Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.
- D. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.
Answer: B
NEW QUESTION 36
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. PREFERRED
- B. VERIFY_CA
- C. VERIFY_IDENTITY
- D. REQUIRED
- E. DISABLED
Answer: D
NEW QUESTION 37
Which two statements are true about using backups of the binary log? (Choose two.)
- A. Binary logs can always be used to unapply unwanted schema changes.
- B. Multiple binary logs can be applied in parallel for faster data restoration.
- C. Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.
- D. They allow for point-in-time recovery of the data.
- E. Multiple binary logs can be used to restore data.
Answer: A,D
NEW QUESTION 38
You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)
- A. The mysqlcheck --optimize --all-databases command reclaims free space from table files.
- B. The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.
- C. The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.
Section: (none)
Explanation - D. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.
- E. The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.
Answer: B,C
NEW QUESTION 39
Examine this command, which executes successfull
mysqlbackup --defaults-file=/backups/server-my.cnf --backup-dir=/backups/full copy-back Which statement is true about the copy-back process?
- A. The copy-back process is used to overwrite a new backup over an existing backup.
- B. The copy-back process makes inconsistent backups.
- C. It restores files from the backup directory to their original MySQL server locations.
- D. It restores files from the data directory to their original MySQL server locations.
Answer: A,C
NEW QUESTION 40
Examine this SQL statement:
Which set of privileges will allow Tom to execute this SQL statement?
- A. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.'country' TO 'tom'@'%';
- B. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.* TO 'tom'@'%';
- C. GRANT UPDATE ON 'world'.* TO 'tom'@'%';
GRANT ALL PRIVILEGES ON 'world'.'country' TO 'tom'@'%'; - D. GRANT ALL PRIVILEGES ON 'world'.'city' TO 'tom'@'%';
GRANT SELECT ('code') ON 'world'.'country' TO 'tom'@'%';
Answer: A
NEW QUESTION 41
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 returns an error because the mysqldump command should have been used.
- C. It creates a logical backup of all MySQL user accounts.
- D. It creates a logical backup of only the users database.
Answer: A
NEW QUESTION 42
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 43
Examine this statement, which executes successfully:
You want to improve the performance of this query:
Which change enables the query to succeed while accessing fewer rows?
- A. ALTER TABLE world.city ADD INDEX (Population);
- B. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
- C. ALTER TABLE world.city ADD SPATIAL INDEX (Name);
- D. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);
- E. ALTER TABLE world.city ADD SPATIAL INDEX (Population);
- F. ALTER TABLE world.city ADD INDEX (Name);
Answer: E
NEW QUESTION 44
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 45
Which two commands will display indexes on the parts table in the manufacturing schema? (Choose two.)
- A. SHOW INDEXES FROM manufacturing.parts;
- B. DESCRIBE manufacturing.parts;
- C. SELECT * FROM information_schema.COLUMN_STATISTICS;
- D. EXPLAIN SELECT INDEXES FROM manufacturing.parts;
- E. SELECT * FROM information_schema.statistics WHERE table_schema='manufacturing' AND TABLE_NAME='parts';
Answer: C,E
NEW QUESTION 46
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. BLACKHOLE
- B. MEMORY
- C. NDB
- D. InnopB
- E. ARCHIVE
- F. MyISAM
Answer: A,C,F
NEW QUESTION 47
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: B
NEW QUESTION 48
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_doublewrite=0
- B. innodb_undo_directory=/dev/shm
- C. innodb_flush_log_at_trx_commit=1
- D. sync_binlog=0
- E. max_connections=10000
- F. buffer_pool_size=24G
- G. innodb_log_file_size=1G
Answer: C,E,G
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 49
Which four are types of information stored in the MySQL data dictionary? (Choose four.)
- A. access control lists
- B. server runtime configuration
- C. view definitions
- D. InnoDB buffer pool LRU management data
- E. performance metrics
- F. stored procedure definitions
- G. server configuration rollback
- H. table definitions
Answer: C,F,G,H
NEW QUESTION 50
Which three actions are effective in capacity planning? (Choose three.)
- A. consulting the application team about any future projects and use
- B. buying more disk
- C. adding circular replication nodes for increased DML capability
- D. basing expected growth on an average of the last 3 years
- E. buying more CPU
- F. upgrading to the latest application version
- G. buying more RAM
- H. monitoring OS resources for patterns
Answer: A,D,H
NEW QUESTION 51
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 52
......
Verified 1Z0-908 dumps Q&As - Pass Guarantee Exam Dumps Test Engine: https://www.test4cram.com/1Z0-908_real-exam-dumps.html
Verified 1Z0-908 dumps and 86 unique questions: https://drive.google.com/open?id=1Hmr4Og1r1OAWbTICPmcZfpz1xg4WuZjJ