Question :- Anonymous accounts have user name ______________

1.root

2.blank

3.super

4.prime

Question :- Encrypted connections can be established using ______________

1.exec_stmt_ssl

2.exec_ssl_stmt

3.exec_stmnt_ssl

4.exec_ssl_stmnt

Question :- For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by ______

1.multiple-transaction

2.single-transaction

3.double-transaction

4.no-transaction

Question :- For which of these is the startup option best suited?

1.entire data directory

2.individual database tables

3.server PID file

4.individual database directories

Question :- In the database directory of the database each view and trigger object is associated with how many files?

1.0

2.1

3.2

4.3

Question :- In which file are the statements entered in ‘mysql’ saved?

1..mysql_queries

2.queries

3.mysql_history

4.history

Question :- SBR replication is _____

1.Statement based

2.Row based

3.Column based

4.Table based

Question :- Server startup can also be done by the ______________

1.option file

2.log file

3.error file

4.system file

Question :- Symlink is an applicable relocation method for ______________

1.entire data directory

2.individual database tables

3.server PID file

4.log files

Question :- The case sensitive among these is ______________

1.Stored function name

2.Stored procedure name

3.Trigger name

4.Event name

Question :- The clause that can be used to sort string values according to a specific collation is ______________

1.SORT

2.GROUP

3.FILTER

4.COLLATE

Question :- The context in which the privilege ‘CREATE TABLESPACE’ applies is ________

1.Server administration

2.Tables

3.Stored routines

4.Views

Question :- The data directory subdirectory that corresponds to the nbdinfo database is ______________

1.mysql

2.performance_schema

3.sys

4.nbdinfo

Question :- The datadir variable value can be seen using ______________

1.SHOW VARIABLES

2.DISP VARIABLES

3.CONNECT VARIABLES

4.SHOW VARIABLE

Question :- The disk data that the FILES table in INFORMATION_SCHEMA stores is ______

1.NDB

2.NBD

3.NBK

4.NCD

Question :- The error log file has a suffix ______________

1..err

2..er

3..error

4..log

Question :- The header that should be included first is _____

1.my_global.h

2.my_sys.h

3.mysql.h

4.my_local.h

Question :- The keyword used to create a database is __________

1.CREATE

2.SET

3.SETUP

4.LINK

Question :- The language in which image processing is least simple is ______

1.PHP

2.Perl

3.Python

4.C

Question :- The language that is the core for APIs and communication in MySQL is ________

1.C

2.C++

3.Python

4.Ruby

Question :- The library file that contains various portability macros and definitions is ______

1.my_global.h

2.my_sys.h

3.mysql.h

4.my_local.h

Question :- The most general purpose language is _______

1.C

2.Perl

3.Python

4.PHP

Question :- The most restrictive among the following is ______

1.mysql_query()

2.mysql_real_query()

3.same

4.machine dependent

Question :- The name of the format file for a table named my_tbl is __________

1.my_tbl.fmt

2.my_tbl.frm

3.my_tbl.fmr

4.my_tbl.ftm

Question :- The option necessary to compile a C program havin math functions is ____

1. -lm

2.-ln

3.-lp

4.-lq

Question :- The option that executes all SQL statements in a SQL script irrespective of the number of errors is ______________

1.ensure

2.force

3.violent

4.run

Question :- The option that specifies the data directory location at server startup is _____

1.–data

2.–data_dir

3.–data-dir

4.–datadir

Question :- The option used to specify the socket file pathname is ______

1.–socket

2.–pathtosocket

3.–path_socket

4.–socket_pathfile

Question :- The option which finds the startup options supported by the server through mysqld is ______________

1.verbose

2.vertex

3.startup

4.shutdown

Question :- The server listens on a network port for TCP/IP connections unless started with the option _____

1.networking

2.skip-networking

3.skip-networks

4.quit-networking

Question :- The statement used to find out which character sets are available is ______________

1.SHOW CHARACTER SET

2.SHOW COLLATION

3.SHOW CHARACTER SETS

4.SHOW COLLATIONS

Question :- The superuser account of the grant tables in the mysql database is called ______________

1.super

2.prime

3.root

4.leaf

Question :- The variable used to set table alias names as non case sensitive is ______________

1.lower_case_table_names

2.lower_case_all

3.lower_case_alias

4.lower_case_aliases

Question :- To reload a delimited text data file use ______

1.mysqldump

2.mysqld

3.mysqlimport

4.mysqlnaive

Question :- What does the default case sensitivity of database and table names depend on?

1.SQL server

2.Server SQL mode

3.Operating system of machine

4.Does not depend on anything

Question :- What is exec_stmt_ssl written in?

1.C++

2.C

3.Python

4.Perl

Question :- What is the default storage engine?

1.EXAMPLE

2.ARCHIVE

3.MyISAM

4.NDB

Question :- What is the embedded server library containing the MySQL server linkable into applications?

1.libmysqla

2.libmysqlb

3.libmysqlc

4.libmysqld

Question :- What is the embedded server library when building from source enabled by?

1.with-embedded-server

2.with-server-embedded

3.with-embedded-library

4.with-library-embedded

Question :- What is the general statement-issuing routine?

1.mysql_real_query()

2.mysql_query_real()

3.mysql_image_query()

4.mysql_query_image()

Question :- What is the maximum number of characters allowed for a database name to have?

1.16

2.32

3.64

4.128

Question :- What is the special database that always exists after setting up MySQL on a computer?

1.sampdb

2.mysql

3.information_schema

4.readme_db

Question :- What is the statement used to select a default database?

1.USE

2.CREATE

3.DROP

4.SCHEMA

Question :- What is the synonym for CHARACTER SET?

1.CSET

2.CHSET

3.CHARSET

4.CHCSET

Question :- When relocating an individual table, the table to be relocated should be ______________

1.MyISAM

2.InnoDB

3.TRANSACTION

4.ENGINE

Question :- Which command is used to make a script file ‘run_me.sh’ executable?

1.chmod +e run_me.sh

2.chmod +a run_me.sh

3.chmod +y run_me.sh

4.chmod +x run_me.sh

Question :- Which data directory subdirectory provides the information used to inspect the internal execution of the server at runtime.

1.mysql

2.performance_schema

3.sys

4.nbdinfo

Question :- Which file is created by the server to store the database attributes?

1.db.otp

2.dp.zip

3.db.opt

4.db.cls

Question :- Which option is used to specify to the server the IP number of the server host on which the server should listen?

1.–verbose

2.–bind-address

3.–startup

4.–shutdown

Question :- Which script initializes the data directory during installation?

1.mysql_install_db

2.mysql_install_dbm

3.mysql_init_db

4.mysql_init_dbm