[Dec-2021] Use Real 1Z0-908 Dumps - 100% Free 1Z0-908 Exam Dumps
1Z0-908 PDF Dumps Exam Questions – Valid 1Z0-908 Dumps
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 16
Which two are use cases of MySQL asynchronous replication? (Choose two.)
- A. It guarantees near real-time replication between a master and a slave.
- B. You can scale writes by creating a replicated mesh.
- C. It allows backup to be done on the slave without impacting the master.
- D. You can scale reads by adding multiple slaves.
- E. MySQL Enterprise Backup will automatically back up from an available slave.
Answer: C,D
NEW QUESTION 17
An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)
- A. On the slave, alter the MySQL master connection setting with:
CHANGE MASTER TO MASTER_AUTO_POSITION = 1; - B. Enable GTID by executing this on the master and the slave:
SET GLOBAL GTID_ENABLED=on; - C. Restart MySQL (master and slave) with these options enabled:
--gtid_mode=ON
--log-bin
--log-slave-updates
--enforce-gtid-consistency - D. Execute this on the slave to enable GTID:
START SLAVE IO_THREAD WITH GTID; - E. On the slave, alter the MySQL master connection setting with:
ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1; - F. Execute this on the slave to enable GTID:
RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC;
Answer: A,C
NEW QUESTION 18
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 SPATIAL INDEX (Name);
- B. ALTER TABLE world.city ADD INDEX (Name);
- C. ALTER TABLE world.city ADD INDEX (Population);
- D. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
- E. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);
- F. ALTER TABLE world.city ADD SPATIAL INDEX (Population);
Answer: F
NEW QUESTION 19
Examine this command, which executes successfully:
mysqlpump --user=root --password > full_backup.sql
Which two databases will be excluded from this dump? (Choose two.)
- A. employee
- B. world
- C. sys
- D. mysql
- E. information_schema
Answer: C,E
NEW QUESTION 20
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 21
Which two MySQL Server accounts are locked by default? (Choose two.)
- A. any user created without a password
- B. any new ROLE accounts
- C. any internal system accounts
- D. any user created with a username, but missing the host name
- E. any user set as DEFINER for stored programs
Answer: C,E
NEW QUESTION 22
Which two commands will display indexes on the parts table in the manufacturing schema? (Choose two.)
- A. DESCRIBE manufacturing.parts;
- B. SELECT * FROM information_schema.COLUMN_STATISTICS;
- C. SHOW INDEXES FROM manufacturing.parts;
- D. EXPLAIN SELECT INDEXES FROM manufacturing.parts;
- E. SELECT * FROM information_schema.statistics WHERE table_schema='manufacturing' AND TABLE_NAME='parts';
Answer: B,E
NEW QUESTION 23
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 24
Which statement is true about InnoDB persistent index statistics?
- A. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
- B. Updating index statistics is an I/O expensive operation.
- C. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
- D. Tables are scanned and index statistics recalculated when an instance is restarted.
- E. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
- F. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
Answer: C
NEW QUESTION 25
Which four connection methods can MySQL clients specify with the --protocol option when connecting to a MySQL server? (Choose four.)
- A. DIRECT
- B. IPv6
- C. TCP
- D. MEMORY
- E. FILE
- F. IPv4
- G. PIPE
- H. SOCKET
Answer: C,D,G,H
NEW QUESTION 26
Examine the modified output:
Seconds_Behind_ Mastervalue is steadily growing.
What are two possible causes? (Choose two.)
- A. This value shows only I/O latency and is not indicative of the size of the transaction queue.
- B. The master is producing a large volume of events in parallel but the slave is processing them serially.
- C. One or more large tables do not have primary keys.
- D. The parallel slave threads are experiencing lock contention.
- E. The master is most probably too busy to transmit data and the slave needs to wait for more data.
Answer: A,B
Explanation:
Explanation
NEW QUESTION 27
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 28
You are backing up raw InnoDB files by using mysqlbackup.
Which two groups of files will be backed up during a full backup? (Choose two.)
- A. ibbackup files
- B. *.ibd files
- C. *.sdi files
- D. *.CSM files
- E. ib_logfile* files
Answer: B,E
NEW QUESTION 29
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 30
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 31
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 32
An attempt to recover an InnoDB Cluster fails.
Examine this set of messages and responses:
host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage()
Reconfiguring the default cluster from complete outage…
The instance ‘host1:3377'’ was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y/N]: y
The instance ‘host2:3377’ was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y/N]: y
Dba.rebootClusterFromCompleteOutage: The active session instance isn’t the most updated in comparison with the ONLINE instances of the Cluster’s metadata. Please use the most up to date instance: ‘host1:3377’. (RuntimeError) Which statement is true?
- A. The active session instance is invalid and must be re-created by using the command shell.connect (‘host3:3377’).
- B. The instance deployed on host3must be synchronized from a donor deployed on host1by using the command cluster.addInstance(‘host1:3377’).
- C. The cluster is running and there is at least one ONLINEinstance.
- D. It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).
- E. The instance deployed on host3must be rebuilt with a backup from the primary instance.
Answer: B
NEW QUESTION 33
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 SPATIAL INDEX (Name);
- B. ALTER TABLE world.city ADD INDEX (Name);
- C. ALTER TABLE world.city ADD INDEX (Population);
- D. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
- E. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);
- F. ALTER TABLE world.city ADD SPATIAL INDEX (Population);
Answer: F
Explanation:
Explanation/Reference: https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html
NEW QUESTION 34
Examine this command, which executes successfully:
cluster.addInstance('<user>@<host>:<port>', {recoveryMethod: 'clone'})
Which three statements are true? (Choose three.)
- A. The account used to perform this recovery needs the BACKUP_ADMIN privilege.
- B. InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.
- C. It is always slower than {recoveryMethod: 'incremental'}.
- D. InnoDB tablespaces outside the datadir are able to be cloned.
- E. A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.
- F. A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.
Answer: A,B,C
NEW QUESTION 35
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 creates a logical backup of all MySQL user accounts.
- C. It returns an error because the mysqldumpcommand should have been used.
- D. It creates a logical backup of only the usersdatabase.
Answer: A
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/mysqlpump.html
NEW QUESTION 36
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
NEW QUESTION 37
Examine this query:
What information does this query provide?
- A. total memory used across all connections associated with the user on connection number 10
- B. total memory used by the first 10 threads
- C. total memory used by connection number 10
- D. total memory used by the first 10 connections
- E. total memory used by thread number 10
- F. total memory used across all connections associated with the user on thread number 10
Answer: C
NEW QUESTION 38
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 39
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 40
......
Ultimate 1Z0-908 Guide to Prepare Free Latest Oracle Practice Tests Dumps: https://www.trainingdump.com/Oracle/1Z0-908-practice-exam-dumps.html
Get Top-Rated Oracle 1Z0-908 Exam Dumps Now: https://drive.google.com/open?id=1wws3lVQPN47kFxzpepv2CZZXy6xH_IJ9