Anonymous accounts have user name ______________
1.root
2.blank
3.super
4.prime
Encrypted connections can be established using ______________
1.exec_stmt_ssl
2.exec_ssl_stmt
3.exec_stmnt_ssl
4.exec_ssl_stmnt
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
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
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
In which file are the statements entered in ‘mysql’ saved?
1..mysql_queries
2.queries
3.mysql_history
4.history
SBR replication is _____
1.Statement based
2.Row based
3.Column based
4.Table based
Server startup can also be done by the ______________
1.option file
2.log file
3.error file
4.system file
Symlink is an applicable relocation method for ______________
1.entire data directory
2.individual database tables
3.server PID file
4.log files
The case sensitive among these is ______________
1.Stored function name
2.Stored procedure name
3.Trigger name
4.Event name
The clause that can be used to sort string values according to a specific collation is ______________
1.SORT
2.GROUP
3.FILTER
4.COLLATE
The context in which the privilege ‘CREATE TABLESPACE’ applies is ________
1.Server administration
2.Tables
3.Stored routines
4.Views
The data directory subdirectory that corresponds to the nbdinfo database is ______________
1.mysql
2.performance_schema
3.sys
4.nbdinfo
The datadir variable value can be seen using ______________
1.SHOW VARIABLES
2.DISP VARIABLES
3.CONNECT VARIABLES
4.SHOW VARIABLE
The disk data that the FILES table in INFORMATION_SCHEMA stores is ______
1.NDB
2.NBD
3.NBK
4.NCD
The error log file has a suffix ______________
1..err
2..er
3..error
4..log
The header that should be included first is _____
1.my_global.h
2.my_sys.h
3.mysql.h
4.my_local.h
The keyword used to create a database is __________
1.CREATE
2.SET
3.SETUP
4.LINK
The language in which image processing is least simple is ______
1.PHP
2.Perl
3.Python
4.C
The language that is the core for APIs and communication in MySQL is ________
1.C
2.C++
3.Python
4.Ruby
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
The most general purpose language is _______
1.C
2.Perl
3.Python
4.PHP
The most restrictive among the following is ______
1.mysql_query()
2.mysql_real_query()
3.same
4.machine dependent
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
The option necessary to compile a C program havin math functions is ____
1. -lm
2.-ln
3.-lp
4.-lq
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
The option that specifies the data directory location at server startup is _____
1.–data
2.–data_dir
3.–data-dir
4.–datadir
The option used to specify the socket file pathname is ______
1.–socket
2.–pathtosocket
3.–path_socket
4.–socket_pathfile
The option which finds the startup options supported by the server through mysqld is ______________
1.verbose
2.vertex
3.startup
4.shutdown
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
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
The superuser account of the grant tables in the mysql database is called ______________
1.super
2.prime
3.root
4.leaf
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
To reload a delimited text data file use ______
1.mysqldump
2.mysqld
3.mysqlimport
4.mysqlnaive
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
What is exec_stmt_ssl written in?
1.C++
2.C
3.Python
4.Perl
What is the default storage engine?
1.EXAMPLE
2.ARCHIVE
3.MyISAM
4.NDB
What is the embedded server library containing the MySQL server linkable into applications?
1.libmysqla
2.libmysqlb
3.libmysqlc
4.libmysqld
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
What is the general statement-issuing routine?
1.mysql_real_query()
2.mysql_query_real()
3.mysql_image_query()
4.mysql_query_image()
What is the maximum number of characters allowed for a database name to have?
1.16
2.32
3.64
4.128
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
What is the statement used to select a default database?
1.USE
2.CREATE
3.DROP
4.SCHEMA
What is the synonym for CHARACTER SET?
1.CSET
2.CHSET
3.CHARSET
4.CHCSET
When relocating an individual table, the table to be relocated should be ______________
1.MyISAM
2.InnoDB
3.TRANSACTION
4.ENGINE
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
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
Which file is created by the server to store the database attributes?
1.db.otp
2.dp.zip
3.db.opt
4.db.cls
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
Which script initializes the data directory during installation?
1.mysql_install_db
2.mysql_install_dbm
3.mysql_init_db
4.mysql_init_dbm