Amazon
Avaya
Checkpoint
Cisco®
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL®
Juniper
Microsoft
MuleSoft
Okta
Oracle
Palo Alto Networks
Salesforce
All Vendors
  1. Home
  2. Oracle
  3. 1z0-908

Oracle 1z0-908 Exam (page: 1)
Oracle MySQL 8.0 Database Administrator
Updated on: 12-Aug-2025

Viewing Page 1 of 29
1z0-908 PDF 228 Questions

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?

  1. ALTER TABLE world.city ADD SPATIAL INDEX (Name);
  2. ALTER TABLE world.city ADD SPATIAL INDEX (Population);
  3. ALTER TABLE world.city ADD INDEX (Population);
  4. ALTER TABLE world.city ADD INDEX (Name);
  5. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
  6. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);

Answer(s): C


Reference:

https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html



Which three are characteristics of a newly created role? (Choose three.)

  1. It can be dropped using the DROP ROLE statement.
  2. It is stored in the mysql.role table.
  3. It is created as a locked account.
  4. It can be renamed using the RENAME ROLE statement.
  5. It can be granted to user accounts.
  6. It can be protected with a password.

Answer(s): A,E,F

Explanation:

https://dev.mysql.com/doc/refman/8.0/en/roles.html https://www.mysqltutorial.org/mysql-roles/



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?

  1. RESET MASTER;
    SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
  2. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb- bbbb-bbbb- bbbb-bbbbbbbbbbbb:1-9;
    SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
  3. RESET SLAVE;
    SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820; SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa--aaaaaaaaaaaa:1-10300;
  4. RESET MASTER;
    SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312; SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
  5. RESET SLAVE;
    SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

Answer(s): D



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.)

  1. innodb_flush_log_at_trx_commit=1
  2. buffer_pool_size=24G
  3. innodb_log_file_size=1G
  4. sync_binlog=0
  5. innodb_doublewrite=0
  6. max_connections=10000
  7. innodb_undo_directory=/dev/shm

Answer(s): A,C,F


Reference:

https://aws.amazon.com/blogs/database/best-practices-for-configuring-parameters-for- amazon- rds-for-mysql-part-1-parameters-related-to-performance/



Which statement is true about InnoDB persistent index statistics?

  1. Updating index statistics is an I/O expensive operation.
  2. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
  3. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
  4. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
  5. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
  6. Tables are scanned and index statistics recalculated when an instance is restarted.

Answer(s): D


Reference:

https://mariadb.com/kb/en/innodb-persistent-statistics/



Viewing Page 1 of 29



Share your comments for Oracle 1z0-908 exam with other users:

hanaa 10/3/2023 6:57:00 PM

is this dump still valid???
Anonymous


Georgio 1/19/2024 8:15:00 AM

question 205 answer is b
Anonymous


Matthew Dievendorf 5/30/2023 9:37:00 PM

question 39, should be answer b, directions stated is being sudneted from /21 to a /23. a /23 has 512 ips so 510 hosts. and can make 4 subnets out of the /21
Anonymous


Adhithya 8/11/2022 12:27:00 AM

beautiful test engine software and very helpful. questions are same as in the real exam. i passed my paper.
UNITED ARAB EMIRATES


SuckerPumch88 4/25/2022 10:24:00 AM

the questions are exactly the same in real exam. just make sure not to answer all them correct or else they suspect you are cheating.
UNITED STATES


soheib 7/24/2023 7:05:00 PM

question: 78 the right answer i think is d not a
Anonymous


srija 8/14/2023 8:53:00 AM

very helpful
EUROPEAN UNION


Thembelani 5/30/2023 2:17:00 AM

i am writing this exam tomorrow and have dumps
Anonymous


Anita 10/1/2023 4:11:00 PM

can i have the icdl excel exam
Anonymous


Ben 9/9/2023 7:35:00 AM

please upload it
Anonymous


anonymous 9/20/2023 11:27:00 PM

hye when will post again the past year question for this h13-311_v3 part since i have to for my test tommorow…thank you very much
Anonymous


Randall 9/28/2023 8:25:00 PM

on question 22, option b-once per session is also valid.
Anonymous


Tshegofatso 8/28/2023 11:51:00 AM

this website is very helpful
SOUTH AFRICA


philly 9/18/2023 2:40:00 PM

its my first time exam
SOUTH AFRICA


Beexam 9/4/2023 9:06:00 PM

correct answers are device configuration-enable the automatic installation of webview2 runtime. & policy management- prevent users from submitting feedback.
NEW ZEALAND


RAWI 7/9/2023 4:54:00 AM

is this dump still valid? today is 9-july-2023
SWEDEN


Annie 6/7/2023 3:46:00 AM

i need this exam.. please upload these are really helpful
PAKISTAN


Shubhra Rathi 8/26/2023 1:08:00 PM

please upload the oracle 1z0-1059-22 dumps
Anonymous


Shiji 10/15/2023 1:34:00 PM

very good questions
INDIA


Rita Rony 11/27/2023 1:36:00 PM

nice, first step to exams
Anonymous


Aloke Paul 9/11/2023 6:53:00 AM

is this valid for chfiv9 as well... as i am reker 3rd time...
CHINA


Calbert Francis 1/15/2024 8:19:00 PM

great exam for people taking 220-1101
UNITED STATES


Ayushi Baria 11/7/2023 7:44:00 AM

this is very helpfull for me
Anonymous


alma 8/25/2023 1:20:00 PM

just started preparing for the exam
UNITED KINGDOM


CW 7/10/2023 6:46:00 PM

these are the type of questions i need.
UNITED STATES


Nobody 8/30/2023 9:54:00 PM

does this actually work? are they the exam questions and answers word for word?
Anonymous


Salah 7/23/2023 9:46:00 AM

thanks for providing these questions
Anonymous


Ritu 9/15/2023 5:55:00 AM

interesting
CANADA


Ron 5/30/2023 8:33:00 AM

these dumps are pretty good.
Anonymous


Sowl 8/10/2023 6:22:00 PM

good questions
UNITED STATES


Blessious Phiri 8/15/2023 2:02:00 PM

dbua is used for upgrading oracle database
Anonymous


Richard 10/24/2023 6:12:00 AM

i am thrilled to say that i passed my amazon web services mls-c01 exam, thanks to study materials. they were comprehensive and well-structured, making my preparation efficient.
Anonymous


Janjua 5/22/2023 3:31:00 PM

please upload latest ibm ace c1000-056 dumps
GERMANY


Matt 12/30/2023 11:18:00 AM

if only explanations were provided...
FRANCE