MySQL MCQ

Test your knowledge with important MySQL MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more MySQL MCQs at Bissoy

• The variable that returns code from operations that return true or false is . . . . . . . .
  ক

  $rc

  খ

  $rv

  গ

  $rows

  ঘ

  $ary
• The permitted value type for the variable 'character_set_client' is . . . . . . . .
  ক

  integer

  খ

  float

  গ

  double

  ঘ

  string
• The TLS protocol is . . . . . . . .
  ক

  transparent layer security

  খ

  transport layer security

  গ

  transparent level security

  ঘ

  transport level security
• What is the default format for "Datetime" data type?
  ক

  YYYY-MM-DD HH:MI:SS

  খ

  MM-YYYY-DD HH:MI:SS

  গ

  DD-YYYY-MM MI:HH:SS

  ঘ

  None of the mentioned
• '2341' is a . . . . . . . .
  ক

  integer

  খ

  floating point

  গ

  hexadecimal

  ঘ

  string
• In the following SQL query, what does "person" stands for?<br><pre><code class="sql">INSERT INTO person(person_id, fname, lname) VALUES (1,’S’,’P’);</code></pre>
  ক

  Composite attributes

  খ

  Multivalued attributes

  গ

  Table name

  ঘ

  None of the mentioned
• Hexadecimal values assigned to user variables are treated as . . . . . . . .
  ক

  strings

  খ

  non binary strings

  গ

  binary strings

  ঘ

  integers
• The operator that does not perform relative-value comparisons is . . . . . . . .
  ক

  =

  খ

  ==

  গ

  &gt;=
• The following MySQL statement belongs to which "Condition Types"?<br><pre><code class="sql">SELECT emp_id, fname, lnameFROM accountWHERE start_date</code></pre>
  ক

  Equality conditions

  খ

  Inequality condition

  গ

  Range condition

  ঘ

  None of the mentioned
• The datatype that stores the longest length of strings is . . . . . . . .
  ক

  CHAR

  খ

  VARCHAR

  গ

  TINYTEXT

  ঘ

  TEXT
• The privilege that must be given to the database to create a stored function or procedure is . . . . . . . .
  ক

  CREATE ROUTINE

  খ

  CREATE METHOD

  গ

  CREATE FUNCTION

  ঘ

  CREATE PROCEDURE
• The number of values returned from a stored procedure can be . . . . . . . .
  ক

  0

  খ

  1

  গ

  2

  ঘ

  3
• On failure, 'mysql_query()' returns . . . . . . . .
  ক

  0

  খ

  1

  গ

  -1

  ঘ

  a non-zero value
• How many among the following does not return a value?<br><pre><code class="sql">mysql_close(), mysql_init, mysql_real_connect</code></pre>
  ক

  0

  খ

  1

  গ

  2

  ঘ

  3
• Which of these is faster when accessing data?<br><pre><code class="sql">memory, disk</code></pre>
  ক

  memory

  খ

  disk

  গ

  same speed

  ঘ

  machine dependent
• The default index type for MEMORY tables is . . . . . . . .
  ক

  HASH

  খ

  SPATIAL

  গ

  FULLTEXT

  ঘ

  UNIQUE
• Which statement makes changes to the database's global attributes?
  ক

  CHANGE

  খ

  ALTER

  গ

  ALTERNATE

  ঘ

  UPDATE
• It is required to have an access privilege for a database before selecting it with 'USE'.
  ক

  True

  খ

  False
• Which of these is more restrictive?<br><pre><code class="sql">mysql_query(), mysql_real_query()</code></pre>
  ক

  mysql_query()

  খ

  mysql_real_query()

  গ

  same

  ঘ

  machine dependent
• The option that specifies the data directory location at server startup is . . . . . . . .
  ক

  -data

  খ

  -data_dir

  গ

  -data-dir

  ঘ

  -datadir
• The number of tables for which DELAYED works is . . . . . . . .<br><pre><code class="sql">MyISAM, MEMORY, ARCHIVE, BLACKHOLE</code></pre>
  ক

  1

  খ

  2

  গ

  3

  ঘ

  4
• The option used to specify the socket file pathname is . . . . . . . .
  ক

  -socket

  খ

  -pathtosocket

  গ

  -path_socket

  ঘ

  -socket_pathfile
• Which of these is not optional?<br><pre><code class="sql">SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns;</code></pre>
  ক

  select_list

  খ

  table_list

  গ

  row_constraint

  ঘ

  grouping_columns
• Which of the following belongs to an "aggregate function"?
  ক

  COUNT

  খ

  SUM/AVG

  গ

  MIN/MAX

  ঘ

  All of the mentioned
• The storage engine for which the runtime options are always enabled is . . . . . . . .
  ক

  Falcon

  খ

  FEDERATED

  গ

  InnoDB

  ঘ

  MEMORY
• The option that enables multiple-statement execution is . . . . . . . .
  ক

  CLIENT_MULTI_STATEMENTS

  খ

  CLIENT_STATEMENTS_MULTI

  গ

  MULTI_STATEMENTS_CLIENT

  ঘ

  MULTI_CLIENTS_STATEMENTS
• The DBI API for Perl is . . . . . . . .
  ক

  database interface

  খ

  database id

  গ

  database identity

  ঘ

  database integrity
• The superuser account of the grant tables in the mysql database is called . . . . . . . .
  ক

  super

  খ

  prime

  গ

  root

  ঘ

  leaf
• Suppose a stored function named PI() is written in the database 'sampdb'. How would it be called?
  ক

  PI()

  খ

  sampdb.PI()

  গ

  MySQL.PI()

  ঘ

  db.PI()
• In Perl DBI, functions are called . . . . . . . .
  ক

  functions

  খ

  procedures

  গ

  methods

  ঘ

  programs