[2022] 1Z0-908 Actual Exam Dumps, 1Z0-908 Practice Test
Dumpexams 1Z0-908 dumps & MySQL Database Administration sure practice dumps
Oracle 1Z0-908: MySQL 8.0 Database Administrator Certification Path
The Oracle Certified Expert, Oracle 1Z0-908: MySQL 8.0 Database Administrator certification is for Database Development Systems Managers and Database Administrators with at least 1 year of RAC and Grid Infrastructure experience. It is also recommended to understand high availability concepts and clustering. To earn this certificate, you should have the ability to install, manage, monitor, and recover RAC databases, Clusterware, and ASM environments. You will get a complete understanding of the architecture of the Clusterware, ASM, and RAC databases while preparing for the exam with the help of 1Z0-908 practice test. After earning this certification, you will gain the skills of installing, setup, backup and recovery, tuning, and monitoring of these components.
The candidates should have to complete one of the following Certification or Training:
Oracle Database 12c Certified Professional
Oracle Database 10g Real Applications Clusters Certified Expert
Oracle Database 11g Certified Professional
Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid Infrastructure Administrator
Oracle Database Administration 2019 Certified Professional
Certifications:
1Z0-908 practice exams are great sources for the preparation of the exam but they do not meet the requirement of the training. To meet the requirement of the training course must be offered by Oracle University Training Center, Oracle Authorized Education Center, Oracle Authorized Partner, or Oracle Workforce Development Program. Courses can be a live virtual class, training on demand, learning subscription, or instructor-led in-class.
NEW QUESTION 25
Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)
- A. ADMIN OPTION allows Mark to drop the role.
- B. Mark must connect from localhost to activate the r_read@localhost role.
- C. Mark can grant the privileges assigned to the r_read@localhost role to another user.
- D. Mark can revoke the r_read@localhost role from another role.
- E. ADMIN OPTION causes the role to be activated by default.
- F. Mark can grant the r_read@localhost role to another user.
Answer: A,C
NEW QUESTION 26
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 27
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. ibbackupfiles
- B. *.ibdfiles
- C. *.sdifiles
- D. *.CSMfiles
- E. ib_logfile*files
Answer: B,E
Explanation:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/innodb-backup.html
NEW QUESTION 28
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 29
Examine this query and output:
Which two statements are true? (Choose two.)
- A. It takes more than 8 milliseconds to sort the rows.
- B. The query returns exactly 125 rows.
- C. The countrytable is accessed as the first table, and then joined to the city table.
- D. The optimizer estimates that 51 rows in the countrytable have Continent = ‘Asia’.
- E. 35 rows from the city table are included in the result.
Answer: D,E
NEW QUESTION 30
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 31
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 32
Examine this command and output:
Which two options will improve the security of the MySQL instance? (Choose two.)
- A. Change the parent directory owner and group to mysql.
- B. Remove world read privileges from the server-cert.pem certificate file.
- C. Change the group ownership of the mysql directory to the mysql user group.
- D. Remove world read privileges from the public_key.pem file.
- E. Remove group read/write privileges from the private_key.pem file.
- F. Remove the world read/execute privilege from the accounting directory.
Answer: A,C
NEW QUESTION 33
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 34
There are five MySQL instances configured with a working group replication.
Examine the output of the group members:
Which two statements are true about network partitioning in the cluster? (Choose two.)
- A. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
- B. The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.
- C. A manual intervention to force group members to be only the working two instances is required.
- D. The cluster will shut down to preserve data consistency.
- E. There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.
Answer: B,D
NEW QUESTION 35
A MySQL server is monitored using MySQL Enterprise Monitor's agentless installation.
Which three features are available with this installation method? (Choose three.)
- A. security-related advisor warnings
- B. disk usage and disk characteristics including disk advisors warnings
- C. operating system memory utilization
- D. MySQL Query Analysis data
- E. network-related information and network characteristics
- F. CPU utilization
- G. MySQL Replication monitoring
Answer: A,B,D
NEW QUESTION 36
Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)
- A. It is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.
- B. It is possible to retrieve a normalized statement, but never the exact statement that was executed.
- C. It is possible to import data into the Query Analyzer from heterogeneous sources, such as CSV.
- D. The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.
- E. It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.
Answer: A,E
NEW QUESTION 37
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.)
- A. innodb_undo_directory=/dev/shm
- B. sync_binlog=0
- C. buffer_pool_size=24G
- D. max_connections=10000
- E. innodb_flush_log_at_trx_commit=1
- F. innodb_log_file_size=1G
- G. innodb_doublewrite=0
Answer: D,E,F
NEW QUESTION 38
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 39
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 40
Your MySQL installation is running low on space due to binary logs. You need to reduce your log space usage urgently.
Which two sets of actions when completed will accomplish this? (Choose two.)
- A. Set binlog_expire_logs_seconds in my.cnf.
- B. Use SET GLOBAL binlog_expire_logs_seconds=<value> and run the FLUSH BINARY LOGS command.
- C. Use SET GLOBAL binlog_expire_logs_seconds=<value> and restart the server.
- D. Use PURGE BINARY LOGS to <binlog_name>.
- E. Set binlog_expire_logs_seconds = 0 in my.cnf and restart the server.
- F. Use SET PERSIST binlog_expire_logs_seconds=<value>.
Answer: C,F
NEW QUESTION 41
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 42
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 43
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 44
What does the binlog dump thread do?
- A. It connects to the master and asks it to send updates recorded in its binary logs.
- B. It monitors and schedules the rotation/deletion of the binary logs.
- C. It reads the relay log and executes the events contained in them.
- D. It acquires a lock on the binary log for reading each event to be sent to the slave.
Answer: A
NEW QUESTION 45
Which two queries are examples of successful SQL injection attacks? (Choose two.)
- A. SELECT user,passwd FROM members
WHERE user = '?';INSERT INTO members('user','passwd') VALUES
('[email protected]','secret');--'; - B. SELECT email,passwd FROM members
WHERE email = 'INSERT INTO members('email','passwd') VALUES ('[email protected]',
'secret');--'; - C. SELECT user, phone FROM customers WHERE name = '\; DROP TABLE users; --';
- 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 46
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 47
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 48
......
1Z0-908 Actual Questions and Braindumps: https://www.dumpexams.com/1Z0-908-real-answers.html
Pass 1Z0-908 Exam with Updated 1Z0-908 Exam Dumps PDF 2022: https://drive.google.com/open?id=1OmiaSelJzBFfoJs7EQi_Xs-hatVj3tnM