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