R4RIN – MCQs, Mock Tests | SQL SQL MCQ SET 6

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

1. Server administration
2. Tables
3. Stored routines
4. Views

✅ Correct Answer: 1

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

1. C
2. C++
3. Python
4. Ruby

✅ Correct Answer: 1

The most general purpose language is _______

1. C
2. Perl
3. Python
4. PHP

✅ Correct Answer: 1

The language in which image processing is least simple is ______

1. PHP
2. Perl
3. Python
4. C

✅ Correct Answer: 4

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

1. -lm
2. -ln
3. -lp
4. -lq

✅ Correct Answer: 1

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

✅ Correct Answer: 2

To reload a delimited text data file use ______

1. mysqldump
2. mysqld
3. mysqlimport
4. mysqlnaive

✅ Correct Answer: 3

SBR replication is _____

1. Statement based
2. Row based
3. Column based
4. Table based

✅ Correct Answer: 1

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

✅ Correct Answer: 2

The header that should be included first is _____

1. my_global.h
2. my_sys.h
3. mysql.h
4. my_local.h

✅ Correct Answer: 1

What is the general statement-issuing routine?

1. mysql_real_query()
2. mysql_query_real()
3. mysql_image_query()
4. mysql_query_image()

✅ Correct Answer: 1

The most restrictive among the following is ______

1. mysql_query()
2. mysql_real_query()
3. same
4. machine dependent

✅ Correct Answer: 1

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

1. –data
2. –data_dir
3. –data-dir
4. –datadir

✅ Correct Answer: 4

The datadir variable value can be seen using ______________

1. SHOW VARIABLES
2. DISP VARIABLES
3. CONNECT VARIABLES
4. SHOW VARIABLE

✅ Correct Answer: 1

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

✅ Correct Answer: 2

Encrypted connections can be established using ______________

1. exec_stmt_ssl
2. exec_ssl_stmt
3. exec_stmnt_ssl
4. exec_ssl_stmnt

✅ Correct Answer: 1

What is exec_stmt_ssl written in?

1. C++
2. C
3. Python
4. Perl

✅ Correct Answer: 2

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

1. libmysqla
2. libmysqlb
3. libmysqlc
4. libmysqld

✅ Correct Answer: 4

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

✅ Correct Answer: 1

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

✅ Correct Answer: 2

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

1. 16
2. 32
3. 64
4. 128

✅ Correct Answer: 3

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

1. mysql
2. performance_schema
3. sys
4. nbdinfo

✅ Correct Answer: 2

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

✅ Correct Answer: 3

What is the synonym for CHARACTER SET?

1. CSET
2. CHSET
3. CHARSET
4. CHCSET

✅ Correct Answer: 3

What is the statement used to select a default database?

1. USE
2. CREATE
3. DROP
4. SCHEMA

✅ Correct Answer: 1

Symlink is an applicable relocation method for ______________

1. entire data directory
2. individual database tables
3. server PID file
4. log files

✅ Correct Answer: 2

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

✅ Correct Answer: 3

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

1. MyISAM
2. InnoDB
3. TRANSACTION
4. ENGINE

✅ Correct Answer: 1

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

✅ Correct Answer: 3

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

1. .mysql_queries
2. queries
3. mysql_history
4. history

✅ Correct Answer: 3

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

✅ Correct Answer: 4

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

1. super
2. prime
3. root
4. leaf

✅ Correct Answer: 3

Which script initializes the data directory during installation?

1. mysql_install_db
2. mysql_install_dbm
3. mysql_init_db
4. mysql_init_dbm

✅ Correct Answer: 1

Anonymous accounts have user name ______________

1. root
2. blank
3. super
4. prime

✅ Correct Answer: 2

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

✅ Correct Answer: 3

The case sensitive among these is ______________

1. Stored function name
2. Stored procedure name
3. Trigger name
4. Event name

✅ Correct Answer: 3

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

✅ Correct Answer: 1

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

1. SORT
2. GROUP
3. FILTER
4. COLLATE

✅ Correct Answer: 4

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

✅ Correct Answer: 1

The error log file has a suffix ______________

1. .err
2. .er
3. .error
4. .log

✅ Correct Answer: 1

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

1. verbose
2. vertex
3. startup
4. shutdown

✅ Correct Answer: 1

Server startup can also be done by the ______________

1. option file
2. log file
3. error file
4. system file

✅ Correct Answer: 1

The keyword used to create a database is __________

1. CREATE
2. SET
3. SETUP
4. LINK

✅ Correct Answer: 1

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

1. db.otp
2. dp.zip
3. db.opt
4. db.cls

✅ Correct Answer: 3

What is the default storage engine?

1. EXAMPLE
2. ARCHIVE
3. MyISAM
4. NDB

✅ Correct Answer: 3

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

✅ Correct Answer: 2

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

✅ Correct Answer: 2

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

✅ Correct Answer: 2

The option used to specify the socket file pathname is ______

1. –socket
2. –pathtosocket
3. –path_socket
4. –socket_pathfile

✅ Correct Answer: 1

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

1. NDB
2. NBD
3. NBK
4. NCD

✅ Correct Answer: 1