SQL/SQL MCQ SET 6 Sample Test,Sample questions

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


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!