Easy To Download Oracle 1Z0-908 Exam Dumps Updated 86 Questions
New Updated 1Z0-908 Exam Questions 2021
NEW QUESTION 18
Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)
- A. X Protocol
- B. SOCKET
- C. TCP/IP
- D. UDP
- E. named pipes
- F. shared memory
Answer: C,E,F
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/mysql-installer-workflow.html
NEW QUESTION 19
Which two commands will display indexes on the partstable in the manufacturing schema? (Choose two.) \
- A. SHOW INDEXES FROM manufacturing.parts;
- B. DESCRIBE manufacturing.parts;
- C. SELECT * FROM information_schema.COLUMN_STATISTICS;
- D. EXPLAIN SELECT INDEXES FROM manufacturing.parts;
- E. SELECT * FROM information_schema.statistics WHERE table_schema=’manufacturing’
AND TABLE_NAME=’parts’;
Answer: C,E
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E11882_01/server.112/e40540/indexiot.htm#CNCPT912
NEW QUESTION 20
Which three are characteristics of a newly created role? (Choose three.)
- A. It can be renamed using the RENAME ROLEstatement.
- B. It is stored in the mysql.roletable.
- C. It can be protected with a password.
- D. It can be granted to user accounts.
- E. It is created as a locked account.
- F. It can be dropped using the DROP ROLEstatement.
Answer: C,D,F
Explanation:
Explanation/Reference:
NEW QUESTION 21
Examine this SQL statement:
Which set of privileges will allow Tom to execute this SQL statement?
- A. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.'country' TO 'tom'@'%';
- B. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.* TO 'tom'@'%';
- C. GRANT UPDATE ON 'world'.* TO 'tom'@'%';
GRANT ALL PRIVILEGES ON 'world'.'country' TO 'tom'@'%'; - D. GRANT ALL PRIVILEGES ON 'world'.'city' TO 'tom'@'%';
GRANT SELECT ('code') ON 'world'.'country' TO 'tom'@'%';
Answer: A
NEW QUESTION 22
Which three statements are true about MySQL replication? (Choose three.)
- A. Each slave must have its own MySQL user for replication.
- B. Replication can use only TCP/IP connections.
- C. Binary logging must be enabled on the master in order to replicate to other instances.
- D. A replication user must have the SELECT privilege for all tables that need to be replicated.
- E. Each instance in a replication topology must have a unique server ID.
- F. Any instance can have multiple slaves, but it can have only one master.
- G. Binary logs contain only transactions originating from a single MySQL instance.
Answer: C,D,E
NEW QUESTION 23
Which statement is true about InnoDB persistent index statistics?
- A. Tables are scanned and index statistics recalculated when an instance is restarted.
- B. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
- C. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
- D. Updating index statistics is an I/O expensive operation.
- E. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
- F. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
Answer: B
NEW QUESTION 24
Examine this command, which executes successfull
mysqlbackup --defaults-file=/backups/server-my.cnf --backup-dir=/backups/full copy-back Which statement is true about the copy-back process?
- A. The copy-back process is used to overwrite a new backup over an existing backup.
- B. The copy-back process makes inconsistent backups.
- C. It restores files from the backup directory to their original MySQL server locations.
- D. It restores files from the data directory to their original MySQL server locations.
Answer: A,C
NEW QUESTION 25
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_doublewrite=0
- B. innodb_undo_directory=/dev/shm
- C. innodb_flush_log_at_trx_commit=1
- D. sync_binlog=0
- E. max_connections=10000
- F. buffer_pool_size=24G
- G. innodb_log_file_size=1G
Answer: C,E,G
NEW QUESTION 26
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)
- A. It decrypts data for use in memory.
- B. It supports all indexes transparently.
- C. It does not support the transportable tablespaces feature.
- D. It supports only non-blob datatypes.
- E. It enforces encryption from disk to memory and over network transmission.
Answer: A,B
NEW QUESTION 27
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. PREFERRED
- B. VERIFY_CA
- C. VERIFY_IDENTITY
- D. REQUIRED
- E. DISABLED
Answer: D
NEW QUESTION 28
Examine this command, which executes successfully:
$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path Which activity is performed?
- A. MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.
- B. MySQL Router is restarted.
- C. MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.
- D. MySQL Router is configured based on the information in files in directory_path.
Answer: C
Explanation:
Explanation/Reference: https://dev.mysql.com/doc/mysql-router/8.0/en/mysqlrouter.html
NEW QUESTION 29
Examine this statement:
mysql> DROP ROLE r_role1, r_role2;
Which two are true? (Choose two.)
- A. It fails if any of the roles is specified in the mandatory_roles variable.
- B. Existing connections can continue to use the roles' privileges until they reconnect.
- C. It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.
- D. You must revoke all privileges from r_role1 and r_role2 before dropping the roles.
- E. It fails if at least one of the roles does not exist.
- F. You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.
Answer: B,C
NEW QUESTION 30
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. ib_logfile* files
- B. *.sdi files
- C. ibbackup files
- D. *.CSM files
- E. *.ibd files
Answer: A,E
NEW QUESTION 31
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 returns an error because the mysqldump command should have been used.
- C. It creates a logical backup of all MySQL user accounts.
- D. It creates a logical backup of only the users database.
Answer: A
NEW QUESTION 32
Examine this statement and output:
You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)
- A. QN = 1
- B. QN = 5
- C. QN = 3
- D. QN = 2
- E. QN = 4
Answer: A,D
NEW QUESTION 33
Which two storage engines provide a view of the data consistent with the storage system at any moment? (Choose two.)
- A. NDB
- B. MEMORY
- C. ARCHIVE
- D. MyISAM
- E. InnoDB
Answer: B,D
NEW QUESTION 34
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. Restart MySQL (master and slave) with these options enabled:
--gtid_mode=ON
--log-bin
--log-slave-updates
--enforce-gtid-consistency - C. Enable GTID by executing this on the master and the slave:
SET GLOBAL GTID_ENABLED=on; - D. Execute this on the slave to enable GTID:
START SLAVE IO_THREAD WITH GTID; - E. Execute this on the slave to enable GTID:
RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC; - F. On the slave, alter the MySQL master connection setting with:
ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;
Answer: A,B
NEW QUESTION 35
Examine this command and output:
Which two options will improve the security of the MySQL instance? (Choose two.)
- A. Remove world read privileges from the server-cert.pemcertificate file.
- B. Change the group ownership of the mysqldirectory to the mysqluser group.
- C. Remove the world read/execute privilege from the accountingdirectory.
- D. Remove world read privileges from the public_key.pemfile.
- E. Remove group read/write privileges from the private_key.pemfile.
- F. Change the parent directory owner and group to mysql.
Answer: B,F
NEW QUESTION 36
Examine this command and output:
Which two statements are true? (Choose two.)
- A. The lock is a shared lock.
- B. The lock is at the metadata object level.
- C. The lock is a row-level lock.
- D. The lock is at the table object level.
- E. The lock is an exclusive lock.
- F. The lock is an intentional lock.
Answer: D,E
NEW QUESTION 37
Which four connection methods can MySQL clients specify with the --protocol option when connecting to a MySQL server? (Choose four.)
- A. IPv6
- B. FILE
- C. SOCKET
- D. MEMORY
- E. PIPE
- F. DIRECT
- G. TCP
- H. IPv4
Answer: C,D,E,G
NEW QUESTION 38
You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)
- A. The mysqlcheck --optimize --all-databases command reclaims free space from table files.
- B. The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.
- C. The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.
Section: (none)
Explanation - D. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.
- E. The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.
Answer: B,C
NEW QUESTION 39
Which three actions are effective in capacity planning? (Choose three.)
- A. consulting the application team about any future projects and use
- B. buying more disk
- C. adding circular replication nodes for increased DML capability
- D. basing expected growth on an average of the last 3 years
- E. buying more CPU
- F. upgrading to the latest application version
- G. buying more RAM
- H. monitoring OS resources for patterns
Answer: A,D,H
NEW QUESTION 40
Examine this query and output:
Which two statements are true? (Choose two.)
- A. The query returns exactly 125 rows.
- B. It takes more than 8 milliseconds to sort the rows.
- C. 35 rows from the city table are included in the result.
- D. The country table is accessed as the first table, and then joined to the city table.
- E. The optimizer estimates that 51 rows in the country table have Continent = 'Asia'.
Answer: C,E
NEW QUESTION 41
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 mysql_config_editor to create an encrypted file.
- B. Use a text editor to create a new defaults file and encrypt it from Linux prompt.
- C. Use mysql_secure_installation to encrypt stored login credentials.
- D. Use the AES_ENCRYPT() MySQL function on the option file.
Answer: A
NEW QUESTION 42
......
Updated Free Oracle 1Z0-908 Test Engine Questions with 86 Q&As: https://www.lead2passexam.com/Oracle/valid-1Z0-908-exam-dumps.html
The Best MySQL Database Administration 1Z0-908 Professional Exam Questions: https://drive.google.com/open?id=1Amo-5j6ABXFXk2bd_5L9JeyeTx4uTHln