Updated Free Oracle 1z1-908 Test Engine Questions with 142 Q&As [Q47-Q64]

4/5 - (1 vote)

Updated Free Oracle 1z1-908 Test Engine Questions with 142 Q&As

The Best MySQL Database Administration 1z1-908 Professional Exam Questions

Q47. Examine these commands and output:

Which connection ID is holding the metadata lock?

Q48. You have a MySQL system with 500 GB of data that needs frequent backups.
You use a mix of MyISAM and InnoDB storage engines for your data.
Examine your backup requirement:
* The MySQL system being backed up can never be unavailable or locked to the client applications.
* The recovery from the backup must work on any system.
* Only 1 hour of data can be lost on recovery of the backup.
Which option fulfills all backup requirements?

Take a physical backup of the MySQL system.

Use the Clone Plugin to copy the data to another MySQL system.

Take a logical backup of the MySQL system.

Take your backup from a slave of the MySQL system.

Q49. You have a MySQL client installed on your Linux workstation with a default installation. You have your admin login credentials to connect to a MySQL server running Microsoft Windows on remote host
192.0.2.1:3306. You wish to connect directly to the world database.
Which four options need to be specified to complete this task with a single command? (Choose four.)

–shared-memory-base-name=world

–protocol=UDP

–protocol=pipe

–password

–user=admin

–host=192.0.2.1

–socket=/tmp/mysql.sock

–port=3306

–database=world

Q50. Which three are requirements for a secure MySQL Server environment? (Choose three.)

Restrict the number of OS users that have access at the OS level.

Ensure appropriate file system privileges for OS users and groups.

Minimize the number of non-MySQL Server-related processes running on the server host.

Encrypt the file system to avoid needing exact file-system permissions.

Keep the entire software stack on one OS host.

Run MySQL server as the root user to prevent incorrect sudo settings.

Q51. Which command enables rule-based MySQL Auditing capabilities?

shell> mysql < audit_log_filter_linux_install.sql

shell> mysqld –initialize –log-raw=audit.log

mysql> INSTALL PLUGIN audit_log;

mysql> INSTALL COMPONENT audit_log;

Q52. Examine this MySQL Shell command:
dba.rebootClusterFromCompleteOutage()
Which two statements are true? (Choose two.)

It reconfigures InnoDB Cluster if the cluster was stopped.

It performs InnoDB Cluster instances rolling restart.

It only starts all InnoDB Cluster instances.

It is not mandatory that all instances are running and reachable before running the command.

It stops and restarts all InnoDB Cluster instances and initializes the metadata.

It only stops and restarts all InnoDB Cluster instances.

It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.

Q53. Examine these InnoDB Cluster parameter settings:

Now examine the partial status:

A permanent network failure isolates host3.
Which two statements are true? (Choose two.)

The instance deployed on host2 is elected as the new primary instance.

The instance deployed on host3 is expelled from the cluster and must be rejoined using cluster.addInstance (‘host3:3377’)

The instance deployed on host3 will automatically rejoin the cluster when connectivity is re-established.

Failure of the instance deployed on host1 provokes an outage.

The issuing command cluster.switchToMuitiPrimaryMode() will fail to enable multi-primary mode.

The primary instance can be specified by using the command
cluster.setPrimaryInstance(<host>:<port>).

Q54. Examine this command, which executes successfully:
mysqlpump -–user=root –password > full_backup.sql
Which two databases will be excluded from this dump? (Choose two.)

information_schema

world

employee

sys

mysql

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

ibbackup files

*.CSM files

*.sdi files

*.ibd files

ib_logfile* files

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

innodb_flush_log_at_trx_commit=1

buffer_pool_size=24G

innodb_log_file_size=1G

sync_binlog=0

innodb_doublewrite=0

max_connections=10000

innodb_undo_directory=/dev/shm

Q57. Examine this snippet from the binary log file named binlog.000036:

The rental table was accidentally dropped, and you must recover the table.
You have restored the last backup, which corresponds to the start of the binlog.000036 binary log.
Which command will complete the recovery?

mysqlbinlog –stop-position=500324 binlog.000036 | mysql

mysqlbinlog –stop-datetime=’2019-ll-20 14:55:18′ binlog.000036 | mysql

mysqlbinlog –stop-position=5004S3 binlog.000036 | mysql

mysqlbinlog –stop-datetime=’2019-ll-20 14:55:16′ binlog.000036 | mysql

Q58. Examine this command and output:

Which two options will improve the security of the MySQL instance? (Choose two.)

Remove group read/write privileges from the private_key.pem file.

Remove world read privileges from the server-cert.pem certificate file.

Change the group ownership of the mysql directory to the mysql user group.

Remove world read privileges from the public_key.pem file.

Change the parent directory owner and group to mysql.

Remove the world read/execute privilege from the accounting directory.

Q59. You plan to take daily full backups, which include the ndbinfo and sys (internal) databases.
Which command will back up the databases in parallel?

mysqldump –single-transaction > full-backup-$(date +%Y%m%d).sql

mysqlpump –include-databases=% > full-backup-$(date +%Y%m$d).sql

mysqlpump –all-databases > full-backup-$(date +%Y%m%d).sql

mysqldump –all-databases > full_backup-$(date +%Y%m%d).sql

Q60. You execute this command:
shell> mysqlpump –exclude-databases=% –users
Which statement is true?

It creates a logical backup of all MySQL user accounts.

It creates a logical backup of all metadata, but contains no table data.

It returns an error because the mysqldump command should have been used.

It creates a logical backup of only the users database.

Q61. Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.

Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.

Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.

TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.

Q62. Examine this command, which executes successfully:
cluster.addInstance(‘<user>@<host>:<port>’, {recoveryMethod: ‘clone’})
Which three statements are true? (Choose three.)

The account used to perform this recovery needs the BACKUP_ADMIN privilege.

A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.

InnoDB tablespaces outside the datadir are able to be cloned.

It is always slower than {recoveryMethod: ‘incremental’}.

A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.

InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.

Q63. Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?

/usr/mysql

/usr/bin

/etc/my.cnf

/var/lib/mysql

/usr