•  
    Questions not Attemped
  •  
    Questions Attemped
  •  
    Questions Marked for review
  •  
    Current Question
00:00

Questions: 1/15

Question

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

options


Questions: 2/15

Question

Which of the following are some general capabilities of the mysql client program?

options


Questions: 3/15

Question

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?

options


Questions: 4/15

Question

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?

options


Questions: 5/15

Question

Which mysqld command line option disables incoming TCP/IP connections?

options


Questions: 6/15

Question

What are some advantages of using the SHOW command rather than using the
INFORMATION_SCHEMA?

options


Questions: 7/15

Question

Index analysis and optimization using ANALYZE and OPTIMIZE statements should…

options


Questions: 8/15

Question

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?

options


Questions: 9/15

Question

Which of the following APIs/connectors are included in a MySQL distribution?

options


Questions: 10/15

Question

Which of the following are some benefits of using MySQL built binaries over binaries built by
yourself?

options


Questions: 11/15

Question

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?

options


Questions: 12/15

Question

Which of the following are true for how BTREE and HASH index types should be used for
MEMORY tables?

options


Questions: 13/15

Question

Which of the following are some general properties of the mysqlimport client program?

options


Questions: 14/15

Question

Which of the following statements are true?

options


Questions: 15/15

Question

In a standard MySQL installation which of following files are stored below the data directory?

options


Questions: 1/15

Question

The command given to list recently installed RPMs is

options


Questions: 2/15

Question

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

options


Questions: 3/15

Question

Which command is to be used to kill a TCP connection

options


Questions: 4/15

Question

Usually the swap partition size should atleast be

options


Questions: 5/15

Question

The format of entry in samba user file for adding a user ram and having same Unix username and windows user name, is

options


Questions: 6/15

Question

Which term refers to the operating system that is being virtualized.

options


Questions: 7/15

Question

The following command is used for dd if=/dev/zero of=/adir/afile bs=1024 count=65536

options


Questions: 8/15

Question

The switch for displaying hashes during rpm installation, is

options


Questions: 9/15

Question

The switch option '-t' of mount command indicates

options


Questions: 10/15

Question

The command to increase priority of an running programme is

options


Questions: 11/15

Question

Network based Linux installation can not be done by

options


Questions: 12/15

Question

What entry in main squid configuration file will change the default http port that squid listen, to 4000?

options


Questions: 13/15

Question

Which file does contain the alternative mail services?

options


Questions: 14/15

Question

Usually the shortcut key combination to open command prompt in KDE, is

options


Questions: 15/15

Question

The at service jobs queue is viewed by which command

options


Previous Question

00:00