Mysql Database Administrator

1.

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.

2.

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.

3.

to allow the remaining events to be processed on the slave while not receiving new events from the master to allow a backup to be created under reduced load to allow for point-in-time recovery on the slave to prevent schema changes from propagating to the slave before they are validated

4.

There are three indexes on the table. There is a redundant index on the dept_no column. The secondary indexes are optimized for unique key look-ups. There is a redundant index on the emp_no column.

5.

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.

6.

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.

7.

binlog_cache_size=1024 is too small and transactions are lost. binlog_format=STATEMENT and a non-deterministic query was executed. enforce_gtid_consistency=ON and consistency is broken between the master and the slave. The sync_relay_log=1000 setting on the slave is too small.

8.

The applications have the SUPER privilege, which allows them to update rows. The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite. For tables with UNIQUE keys, statement-based replication must be used to maintain integrity. The slave was created with mysqldump

9.

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.

10.

mysql> CREATE USER

mysql> CREATE_USER

Mysql 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

Mysql 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

Detail Form

COMPANY

Products

OTHERS

Partner