Pass Your 1Z0-908 Exam Easily With 100% Exam Passing Guarantee [2021]
1Z0-908 Dumps are Available for Instant Access from ExamCost
What is the duration, language, and format of Oracle 1Z0-908: MySQL 8.0 Database Exam
- This exam consists of 90 questions.
- Passing score:
- Section 2: 45%
- Section 1: 60%
- This exam is offered in only English.
- There is a time limit of 140 minutes for the exam.
- Section 3: 33%
- The type of questions is Multiple Choice Questions.
- Certification Validity period: 3 years.
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.
For more info read reference:
Oracle 1Z0-908: MySQL 8.0 Database Administration
Who should take the Oracle 1Z0-908: MySQL 8.0 Database Exam
This course is designed for Database Administrators and Database production Systems Administrators.
NEW QUESTION 14
You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?
- A. using PREPARED STATEMENTS
- B. installing and configuring the Connection Control plugin
- C. using stored procedures for any database access
- D. avoiding concatenation of SQL statements and user-supplied values in an application
Answer: C
Explanation:
Explanation/Reference: https://www.ptsecurity.com/ww-en/analytics/knowledge-base/how-to-prevent-sql-injection-attacks/
NEW QUESTION 15
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)
- A. It decrypts data for use in memory.
- B. It supports only non-blob datatypes.
- C. It supports all indexes transparently.
- D. It enforces encryption from disk to memory and over network transmission.
- E. It does not support the transportable tablespaces feature.
Answer: A,C
NEW QUESTION 16
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 17
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 18
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 19
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 20
Which two are true about binary logs used in asynchronous replication? (Choose two.)
- A. They contain events that describe database changes on the master.
- B. They are pushed from the master to the slave.
- C. They contain events that describe all queries run on the master.
- D. They are pulled from the master to the slave.
- E. They contain events that describe only administrative commands run on the master.
Answer: A,B
Explanation:
Explanation/Reference: https://www.oracle.com/technetwork/community/developer-day/mysql-replication-presentation-
485890.pdf (14)
NEW QUESTION 21
Your MySQL server was upgraded from an earlier major version.
The sales database contains three tables, one of which is the transactions table, which has 4 million rows.
You are running low on disk space on the datadir partition and begin to investigate.
Examine these commands and output:
Which two statements are true? (Choose two.)
- A. Executing ALTER TABLE transactions will enable you to free up disk space.
- B. Truncating the sales and leads table will free up disk space.
- C. The transactions table was created with innodb_file_per_table=OFF.
- D. Truncating the transactions table will free up the most disk space.
- E. Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions will free up disk space.
Answer: C,E
NEW QUESTION 22
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 23
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 24
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 25
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 26
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 = 2
- C. QN = 5
- D. QN = 1
- E. QN = 3
Answer: B,D
NEW QUESTION 27
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 28
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: D
NEW QUESTION 29
Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)
- A. dba.configureInstance()
- B. dba.createCluster()
- C. dba.checkInstanceConfiguration()
- D. cluster.addInstance()
- E. dba.configureLocalInstance()
- F. cluster.setPrimaryInstance()
- G. cluster.forceQuorumUsingPartitionOf()
Answer: F,G
NEW QUESTION 30
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 31
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 defines all innodb tablespace options relative to a starting parent directory.
- B. It moves all innodb tablespaces to the /innodb_extrasdirectory to enable a new innodb_data_home_dirto be defined.
- C. It adds more temporary workspace in addition to the innodb_tmpdirlocation.
- D. It is not necessary because innodb_data_home_diris already defined.
- E. It allows scanning of other locations to discover more innodb tablespaces.
Answer: D
NEW QUESTION 32
Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?
- A. /usr
- B. /var/lib/mysql
- C. /usr/mysql
- D. /etc/my.cnf
- E. /usr/bin
Answer: E
NEW QUESTION 33
Which two queries are examples of successful SQL injection attacks? (Choose two.) SELECT user,passwd FROM members
- A. WHERE email = ‘INSERT INTO members(‘email’,’passwd’) VALUES
(‘[email protected]’, ‘secret’);--‘;
SELECT user, phone FROM customers WHERE name = ‘\; DROP TABLE users; --‘; - B. SELECT email,passwd FROM members
- C. WHERE user = ‘?’;INSERT INTO members(‘user’,’passwd’) VALUES
(‘[email protected]’,‘secret’);--‘; - 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 34
You made some table definition changes to a schema in your MySQL Server.
Which two statements reflect how MySQL Server handles the table definition changes? (Choose two.)
- A. MySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.
- B. MySQL writes SDI to the binary log for distributed backups.
- C. The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).
- D. MySQL keeps InnoDB metadata changes in .sdi files in datadir.
- E. MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.
Answer: C,E
NEW QUESTION 35
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 36
......
Study resources for the Valid 1Z0-908 Braindumps: https://www.examcost.com/1Z0-908-practice-exam.html
Latest MySQL Database Administration 1Z0-908 Actual Free Exam Questions: https://drive.google.com/open?id=1uLxNOua84ZjBerk-Qkt7sljs2XgB3BA1
