2021 Valid 1Z0-908 test answers & Oracle Exam PDF
Free Oracle 1Z0-908 Exam Questions & Answer from Training Expert TestKingFree
How to Study the Oracle 1Z0-908: MySQL 8.0 Database Exam
There are many ways to prepare for the Oracle 1Z0-908 exam. Various strategies can be developed if you are planning to take this exam. Candidates can refer to various PDFs available online and even refer to online videos to prepare for the exam. Various websites are offering practice exams to help you prepare for the exam. Certificate questions provide the most up to date 1Z0-908 exam dumps and we recommend taking the 1Z0-908 practice tests after studying. The candidates must have to take a certification course or training before giving Oracle 1Z0-908 exam, which will also help them prepare for the exam. Candidates can also take the following recommended courses to prepare for the exam:
- Oracle Database 12c: ASM Administration and
- Oracle Database Learning Subscription
- Oracle Database 12c: RAC Administration
- Oracle Database 12c: Clusterware Administration and
Introduction to Oracle 1Z0-908: MySQL 8.0 Database Administrator Exam
Oracle 1Z0-908: MySQL 8.0 Database Administrator Administration Exam assesses the abilities of the Database Administrators and System Administrators who have at least 1 year of experience in RAC and Grid Infrastructure. The candidates should have the ability to install, manage, tracking, tuning, and restoring RAC databases, cluster, and Oracle Automatic Storage Management (ASM). They should have a good understanding of the architectures of the ASM, Clusterware, and Oracle RAC databases. They should also know how to install, setup, backup, and recovery monitoring and tuning of these components.
Oracle Real Application Clusters (RAC) in database computing is a choice for Oracle Database software developed by Oracle Corporation, it provides clustering software and high availability in Oracle database environments. With the Enterprise Version, Oracle Corporation includes RAC, provided the nodes are clustered using Oracle Clusterware. Oracle RAC allows several machines when accessing a single database, to run Oracle RDBMS software simultaneously, offering to cluster.
The Oracle Grid Infrastructure for an independent server is the Oracle software that offers system support for a database including the file system, volume management, and automation of the restart process. If you want to utilize the Oracle restart or Oracle Automatic Storage Management (ASM) services, you have to install Oracle grid infrastructure before installing Oracle Database.
NEW QUESTION 32
You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:
Which statement is true?
- A. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
- B. Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbb GTIDs in its binary logs.
- C. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
- D. Replication will work.
- E. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-cccccccccccc GTIDs.
Answer: A
NEW QUESTION 33
Which command enables rule-based MySQL Auditing capabilities?
- A. shell> mysqld --initialize --log-raw=audit.log
- B. shell> mysql < audit_log_filter_linux_install.sql
- C. mysql> INSTALL COMPONENT audit_log;
- D. mysql> INSTALL PLUGIN audit_log;
Answer: B
Explanation:
Explanation/Reference: https://dev.mysql.com/doc/mysql-security-excerpt/5.7/en/audit-log-filtering.html
NEW QUESTION 34
You wish to store the username and password for a client connection to MySQL server in a file on a local file system.
Which is the best way to encrypt the file?
- A. Use a text editor to create a new defaults file and encrypt it from Linux prompt.
- B. Use mysql_secure_installation to encrypt stored login credentials.
- C. Use mysql_config_editor to create an encrypted file.
- D. Use the AES_ENCRYPT() MySQL function on the option file.
Answer: C
NEW QUESTION 35
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. automatic locking of user accounts who break your firewall
- D. modifying SQL statement dynamically with substitutions
- E. provides stateless firewall access to TCP/3306
Answer: A,D
NEW QUESTION 36
You plan to install MySQL Server by using the RPM download.
Which two statements are true? (Choose two.)
- A. You can provide the root password interactively.
- B. The functionality is split among several RPM package files.
- C. MySQL uses the RPM relocatable installation target feature.
- D. You must manually initialize the data directory.
- E. You can find the root password in the error log after the first start.
- F. The MySQL RPM package installation supports deploying multiple MySQL versions on the same host.
Answer: E,F
NEW QUESTION 37
Examine this command, which executes successfully:
shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb Which two statements are true? (Choose two.)
- A. It enforces consistent backups for all storage engines.
- B. This option uses the READ COMMITTED transaction isolation mode.
- C. It is a cold backup.
- D. The backup created is a consistent data dump.
- E. It executes flush tables with read lock.
Answer: B,E
NEW QUESTION 38
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 39
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. mysql> IMPORT TABLE FROM /var/tmp/customers.sdi
- B. shell> cp /backup/customers.sdi /var/lib/mysql/shop/
- C. mysql> ALTER TABLE shop.customers IMPORT TABLESPACE
- D. shell> cp /backup/customers.sdi /var/tmp
- E. mysql> SOURCE '/var/tmp/customers.sdi'
- F. mysql> ALTER TABLE shop.customers DISCARD TABLESPACE
- G. shell> cp /backup/customers.frm /var/lib/mysql/shop/
- H. mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi
Answer: A,C
NEW QUESTION 40
Which step or set of steps can be used to rotate the error log?
- A. Execute SET GLOBAL log_error = ‘<new error log file>’.
- B. Execute SET GLOBAL expire_logs_days=0to enforce a log rotation.
- 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
Explanation:
Explanation/Reference: https://blog.pythian.com/mysql-log-rotation/
NEW QUESTION 41
You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes.
Examine the current GTID information:
You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover.
Which set of actions would allow the slave to continue replicating without erroneous transactions?
RESET MASTER;
- A. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
- B. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa—aaaaaaaaaaaa:1-10300;
RESET MASTER; - C. bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
RESET SLAVE; - D. SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
RESET SLAVE; - E. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb-
Answer: D
NEW QUESTION 42
A user wants to connect without entering his or her username and password on the Linux command prompt.
Which three locations can be used to store the user's mysql credentials to satisfy this requirement? (Choose three.)
- A. /etc/my.cnf file
- B. $HOME/.mysql/auth/login file
- C. $HOME/.my.cnf file
- D. $HOME/.mysqlrc file
- E. DATADIR/mysqld-auto.cnf file
- F. $HOME/.mylogin.cnf file
- G. $MYSQL_HOME/my.cnf file
Answer: A,E,G
NEW QUESTION 43
Which two statements are true about using backups of the binary log? (Choose two.)
- A. Multiple binary logs can be used to restore data.
- B. They allow for point-in-time recovery of the data.
- C. Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.
- D. Multiple binary logs can be applied in parallel for faster data restoration.
- E. Binary logs can always be used to unapply unwanted schema changes.
Answer: B,E
NEW QUESTION 44
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 needs to reconnect to the database.
- B. The DBA needs to execute FLUSH PRIVILEGES.
- C. The statement was blocked by MySQL Firewall.
- D. John has not activated the role.
Answer: D
NEW QUESTION 45
Examine this MySQL Shell command:
dba.rebootClusterFromCompleteOutage()
Which two statements are true? (Choose two.)
- A. It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.
- B. It performs InnoDB Cluster instances rolling restart.
- C. It reconfigures InnoDB Cluster if the cluster was stopped.
- D. It only stops and restarts all InnoDB Cluster instances.
- E. It is not mandatory that all instances are running and reachable before running the command.
- F. It only starts all InnoDB Cluster instances.
- G. It stops and restarts all InnoDB Cluster instances and initializes the metadata.
Answer: B,E
NEW QUESTION 46
Examine this command and output:
Which two statements are true? (Choose two.)
- A. The lock is at the table object level.
- B. The lock is a row-level lock.
- C. The lock is a shared lock.
- D. The lock is at the metadata object level.
- E. The lock is an exclusive lock.
- F. The lock is an intentional lock.
Answer: A,E
NEW QUESTION 47
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 48
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 49
Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)
- A. TCP/IP
- B. named pipes
- C. X Protocol
- D. SOCKET
- E. shared memory
- F. UDP
Answer: A,B,E
NEW QUESTION 50
......
Top Oracle 1Z0-908 Courses Online: https://www.testkingfree.com/Oracle/1Z0-908-practice-exam-dumps.html
1Z0-908 Practice Dumps - Verified By TestKingFree Updated 86 Questions: https://drive.google.com/open?id=1tP1lgjH2xm4Im2gv8L1_UcRCsxvla5R8