SQL/SQL MCQ SET 6 Sample Test,Sample questions

Question:
Anonymous accounts have user name ______________

1.root

2.blank

3.super

4.prime

Posted Date:-2021-07-18 21:14:04


Question:
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-18 21:14:04


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

Posted Date:-2021-07-18 21:14:04


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

Posted Date:-2021-07-18 21:14:04


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

Posted Date:-2021-07-18 21:14:04


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

1..mysql_queries

2.queries

3.mysql_history

4.history

Posted Date:-2021-07-18 21:14:04


Question:
SBR replication is _____

1.Statement based

2.Row based

3.Column based

4.Table based

Posted Date:-2021-07-18 21:14:04


Question:
Server startup can also be done by the ______________

1.option file

2.log file

3.error file

4.system file

Posted Date:-2021-07-18 21:14:04


Question:
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-18 21:14:04


Question:
The case sensitive among these is ______________

1.Stored function name

2.Stored procedure name

3.Trigger name

4.Event name

Posted Date:-2021-07-18 21:14:04


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

Posted Date:-2021-07-18 21:14:04


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

1.Server administration

2.Tables

3.Stored routines

4.Views

Posted Date:-2021-07-18 21:14:04


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

1.mysql

2.performance_schema

3.sys

4.nbdinfo

Posted Date:-2021-07-18 21:14:04


Question:
The datadir variable value can be seen using ______________

1.SHOW VARIABLES

2.DISP VARIABLES

3.CONNECT VARIABLES

4.SHOW VARIABLE

Posted Date:-2021-07-18 21:14:04


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

1.NDB

2.NBD

3.NBK

4.NCD

Posted Date:-2021-07-18 21:14:04


Question:
The error log file has a suffix ______________

1..err

2..er

3..error

4..log

Posted Date:-2021-07-18 21:14:04


Question:
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-18 21:14:04


Question:
The keyword used to create a database is __________

1.CREATE

2.SET

3.SETUP

4.LINK

Posted Date:-2021-07-18 21:14:04


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

1.PHP

2.Perl

3.Python

4.C

Posted Date:-2021-07-18 21:14:04


Question:
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-18 21:14:04


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

Posted Date:-2021-07-18 21:14:04


Question:
The most general purpose language is _______

1.C

2.Perl

3.Python

4.PHP

Posted Date:-2021-07-18 21:14:04


Question:
The most restrictive among the following is ______

1.mysql_query()

2.mysql_real_query()

3.same

4.machine dependent

Posted Date:-2021-07-18 21:14:04


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

Posted Date:-2021-07-18 21:14:04


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

1. -lm

2.-ln

3.-lp

4.-lq

Posted Date:-2021-07-18 21:14:04


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

Posted Date:-2021-07-18 21:14:04


Question:
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-18 21:14:04


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

1.–socket

2.–pathtosocket

3.–path_socket

4.–socket_pathfile

Posted Date:-2021-07-18 21:14:04


Question:
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-18 21:14:04


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

Posted Date:-2021-07-18 21:14:04


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

Posted Date:-2021-07-18 21:14:04


Question:
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-18 21:14:04


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

Posted Date:-2021-07-18 21:14:04


Question:
To reload a delimited text data file use ______

1.mysqldump

2.mysqld

3.mysqlimport

4.mysqlnaive

Posted Date:-2021-07-18 21:14:04


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

Posted Date:-2021-07-18 21:14:04


Question:
What is exec_stmt_ssl written in?

1.C++

2.C

3.Python

4.Perl

Posted Date:-2021-07-18 21:14:04


Question:
What is the default storage engine?

1.EXAMPLE

2.ARCHIVE

3.MyISAM

4.NDB

Posted Date:-2021-07-18 21:14:04


Question:
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-18 21:14:04


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

Posted Date:-2021-07-18 21:14:04


Question:
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-18 21:14:04


Question:
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-18 21:14:04


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

Posted Date:-2021-07-18 21:14:04


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

1.USE

2.CREATE

3.DROP

4.SCHEMA

Posted Date:-2021-07-18 21:14:04


Question:
What is the synonym for CHARACTER SET?

1.CSET

2.CHSET

3.CHARSET

4.CHCSET

Posted Date:-2021-07-18 21:14:04


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

1.MyISAM

2.InnoDB

3.TRANSACTION

4.ENGINE

Posted Date:-2021-07-18 21:14:04


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

Posted Date:-2021-07-18 21:14:04


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

Posted Date:-2021-07-18 21:14:04


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

Posted Date:-2021-07-18 21:14:04


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

Posted Date:-2021-07-18 21:14:04


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

Posted Date:-2021-07-18 21:14:04


More MCQS

  1. SQL MCQ SET 1
  2. SQL MCQ SET 2
  3. SQL MCQ SET 3
  4. SQL MCQ SET 4
  5. SQL MCQ SET 5
  6. SQL MCQ SET 6
  7. SQL MCQ SET 7
  8. SQL MCQ SET 8
  9. SQL MCQ SET 9
  10. SQL MCQ SET 10
  11. SQL MCQ SET 11
  12. SQL MCQ SET 12
  13. SQL MCQ SET 13
  14. SQL MCQ SET 14
  15. SQL MCQ SET 15
  16. SQL MCQ SET 16
  17. SQL MCQ SET 17
  18. SQL MCQ SET 18
  19. MCQ | SQL – Basics
  20. MCQ | SQL – Data Types
  21. SQL Server DBA Multiple Choice Questions
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!