Will the following SELECT query list all of the tables in the INFORMATION_SCHEMA database?
If not, why? SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'INFORMATION_SCHEMA' ORDER BY TABLE_NAME
Which of the following are some general capabilities of the mysql client program?
Suppose you have a server that has been started with the --myisam-recover option. When does
the server perform the check on the MyISAM tables?
Consider the following query: DELETE FROM INFORMATION_SCHEMA.TABLES
WHERE table_schema = 'world' AND table_name = 'Country' What would be the result of
executing this query?
Which mysqld command line option disables incoming TCP/IP connections?
What are some advantages of using the SHOW command rather than using the
Index analysis and optimization using ANALYZE and OPTIMIZE statements should…
Suppose you have a column in which most records are going to be between 30 and 32 characters.
Which of the following column types would be most efficient?
Which of the following APIs/connectors are included in a MySQL distribution?
Which of the following are some benefits of using MySQL built binaries over binaries built by
Assume you compile MySQL from source and invoke configure with the following options. --
withcharset= latin1 --with-extra-charsets=utf8,ucs2 Compared to a standard binary installation that
contains many more character sets, which of the following statements is/are true?
Which of the following are true for how BTREE and HASH index types should be used for
Which of the following are some general properties of the mysqlimport client program?
Which of the following statements are true?
In a standard MySQL installation which of following files are stored below the data directory?
The command given to list recently installed RPMs is
A Linux system has a swap partition on /dev/hda3 and another swap partition on /dev/hda5. How to decide which swap partition is active
Which command is to be used to kill a TCP connection
Usually the swap partition size should atleast be
The format of entry in samba user file for adding a user ram and having same Unix username and windows user name, is
Which term refers to the operating system that is being virtualized.
The following command is used for dd if=/dev/zero of=/adir/afile bs=1024 count=65536
The switch for displaying hashes during rpm installation, is
The switch option '-t' of mount command indicates
The command to increase priority of an running programme is
Network based Linux installation can not be done by
What entry in main squid configuration file will change the default http port that squid listen, to 4000?
Which file does contain the alternative mail services?
Usually the shortcut key combination to open command prompt in KDE, is
The at service jobs queue is viewed by which command