Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1z0-908

Free Oracle 1z0-908 Exam Braindumps (page: 2)

Page 2 of 36
PDF with 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/






Post your Comments and Discuss Oracle 1z0-908 exam prep with other Community members:

1z0-908 Exam Discussions & Posts