Oracle MySQL 5.7 Database Administrator

Question - 17 Maximum mark : - 28

Home
All Exams
Oracle MySQL 5.7 Database Administrator Online Practice Exams
Oracle MySQL 5.7 Database Administrator

Is it true that binary backups always take less space than text backups?

Yes, because binary backups only contain data, and not statements required to insert data into the tables. ✘ No, because text backups can have optimizations, which make them smaller, such as updating many rows at once. ✘ No, because if InnoDB tables contain many empty pages, they could take more space than the INSERT statements. ✘ Yes, because even if InnoDB tables contain many empty pages, text backups have empty INSERT statements for them. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You have a consistent InnoDB backup created with mysqldump, the largest table is 50 GB in size. You start to restore your backup with this command; shell> mysql

The MySQL server has stopped inserting data to check index consistency. ✘ InnoDB is doing CRC32 checks over the tablespace data as it grows. ✘ The MySQL server is taking a periodical snapshot of data so it can resume the restore if it is interrupted mid-way. ✘ InnoDB has filled the redo log and now must flush the pages. ✔ Secondary indexes no longer fit into the buffer pool. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Suppose you are adding rows to a MyISAM table and the --datadir location runs out of disk space. What will happen when this occurs?

The server will crash. ✘ The server suspends that INSERT operation until space becomes available. ✘ An error message will be returned to the client .Server Error: ER_IO ✘ The server suspends operations for all storage engines until space becomes available. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?

Run the create_system_tables.sql file ✘ Run the mysql_unpack.sql file ✘ Invoke mysqld with the --initialize option. ✘ Invoke mysql with the --initialize option. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration: The MySQL Server is restarted without error. What effect will the new configuration have on existing account?

They are not affected by this configuration change. ✘ They all connect via the secure sha256_password algorithm without any configuration change. ✘ They will have their passwords updated on start-up to sha256_password format. ✘ They will have to change their password the next time they login to the server. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

These details are shown when logged in to an account: Which set of statements would match the accounts shown?

mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets'; mysql> CREATE USER ''@'' IDENTIFIED BY 'valid_password' WITH PROXY 'employee'@'localhost'; ✘ mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';mysql> GRANT PROXY ON 'employee'@'localhost' TO 'robert'@'localhost'; ✘ mysql> CREATE USER 'robert'@'localhost' IDENTIFIED BY 'secret_password';mysql>CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets'; ✘ mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT LOCK;mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets'; mysql> GRANT PROXY ON 'employee'@'localhost' TO ''@''; ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Host slave1 has ip address 192.0.2.10. Host slave2 has ip address 203.0.113.50 Examine these commands: Why did this error occur?

The host on the command line is not defined in the login path. ✘ The mysqld instance has not been restarted after creating the login path. ✘ There is no password defined in the login path. ✘ The DNS is not configured correctly for slave1 host. ✔ The .mylogin.cnf file is not readable. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You are setting up a new installation of MySQL Server 5.7 (a GA release.) You have used a ZIP or TAR package to ensure that the mysqld binary, along with its support files, such as plug-ins and error messages, now exist on the host. Assume that the default datadir exists on the host. You installed the binary in the default location (the default --basedir value) for your operating system. Which step should you perform before defining your own databases and database tables?

Execute a command with a minimal form of: mysql --initialize ✘ Register mysqld as a service that will start automatically on this host machine. ✘ Create a configuration file containing default-storage-engine=InnoDB. ✘ Set an exception in the host machine's firewall to allow external users to talk to mysqld. ✔ Create additional login accounts (so that everyone does not need to log in as root) and assign them appropriate privileges. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Consider that local disk files are accessible via MySQL with commands such as: mysql> LOAD DATA LOCAL INFILE '/etc/passwd' INTO TABLE mypasswords; What change could be made to stop any breach via this insecurity?

setting the --open-files-limit=0 option when starting mysqld ✘ setting the --local-service=0 option when starting mysqld ✘ executing REVOKE FILE FROM *_* ✘ executing REVOKE FILE ON *_* FROM ' '@'%' ✔ setting the --local-infile=0 option when starting mysqld ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUS output: You execute a 'SHOW CREATE TABLE mytable" on the slave: The table mytable on the slave contains: You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?

SET GTID_NEXT="CONSISTENCY"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"; ✘ SET GTID_NEXT="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8";BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"; ✘ SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1 ✘ SET GLOBAL enforce_gtid_consistency=ON ✔ SET GTID_EXECUTED="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8"; ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

Oracle MySQL 5.7 Database Administrator

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner