×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
Which two are correct steps in taking a binary backup of MyISAM tables?
2.
You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases.
Some details are as follows:
The Mysql instance has 400 databases.
Each database on an average consists of 25-50 tables.
You use the query:
SELECT TABLE_SCHEMA,
'ENGINE',
COUNT (*),
SUM (data_length) total_size
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
GROUP BY TABLE_SCHEMA, 'ENGINE'
;
Why is this query slow to execute?
Some details are as follows:
The Mysql instance has 400 databases.
Each database on an average consists of 25-50 tables.
You use the query:
SELECT TABLE_SCHEMA,
'ENGINE',
COUNT (*),
SUM (data_length) total_size
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
GROUP BY TABLE_SCHEMA, 'ENGINE'
;
Why is this query slow to execute?
3.
Which two events will cause a slave server to create a new relay log file?
4.
The InnoDB engine has a feature known as clustered indexes.
Which three statements are true about clustered indexes as used in InnoDB?
5.
A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application
that is running on a separate server in a DMZ.
Which two will optimize the security of this setup?
6.
Which hardware storage option, when set up with redundant disks, offers the least stability, availability, and reliability for Mysql data?
7.
Which two statements are true regarding partitioning in Mysql?
8.
What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?
9.
Consider the following table:
CREATE TABLE 'game' (
'id' int (10) unsigned NOT NULL AUTO_INCREMENT,
'keyword' varchar (45) DEFAULT NULL,
'date' datetime NOT NULL,
PRIMARY KEY ('id' , 'date'),
UNIQUE KEY 'keyword_idx' ('keyword' , 'date')
) ENGINE=InnoDB DEFAULT CHARSET=latin1
PARTITION BY RANGE (TO_DAYS (date) ) (
PARTITION g201301 VALUES LESS THAN (TO_DAYS ('2013-01-01 00:00:00') ),
PARTITION g201302 VALUES LESS THAN (TO_DAYS ('2013-02-01 00:00:00') ),
PARTITION g201303 VALUES LESS THAN (TO_DAYS ('2013-03-01 00:00:00') ),
PARTITION g201304 VALUES LESS THAN (TO_DAYS ('2013-04-01 00:00:00') ),
PARTITION gMORES VALUES LESS THAN (MAXVALUE) );
Which method should used to add a new g201305 partition to the table?
CREATE TABLE 'game' (
'id' int (10) unsigned NOT NULL AUTO_INCREMENT,
'keyword' varchar (45) DEFAULT NULL,
'date' datetime NOT NULL,
PRIMARY KEY ('id' , 'date'),
UNIQUE KEY 'keyword_idx' ('keyword' , 'date')
) ENGINE=InnoDB DEFAULT CHARSET=latin1
PARTITION BY RANGE (TO_DAYS (date) ) (
PARTITION g201301 VALUES LESS THAN (TO_DAYS ('2013-01-01 00:00:00') ),
PARTITION g201302 VALUES LESS THAN (TO_DAYS ('2013-02-01 00:00:00') ),
PARTITION g201303 VALUES LESS THAN (TO_DAYS ('2013-03-01 00:00:00') ),
PARTITION g201304 VALUES LESS THAN (TO_DAYS ('2013-04-01 00:00:00') ),
PARTITION gMORES VALUES LESS THAN (MAXVALUE) );
Which method should used to add a new g201305 partition to the table?
10.
Full Atomicity, Consistency, Isolation, Durability (ACID) compliance is a necessity for a new application, which heavily reads and writes data.
This requires the following config file options:
Sync_binlog=1
Innodb_flush_log_at_trx_commit=1
Innodb_doublewrite=1
However, this configuration is expected to introduce disk I/O overhead.
What three changes will reduce disk I/O overheads?