MySQL Setup MCQ

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

• SHOW DATABASES lists the databases in the server to which you are connected.
  ক

  True

  খ

  False
• To see the table structure, which of the following SQL commands is issued?
  ক

  DESCRIBE tbl_name

  খ

  VIEW tbl_name

  গ

  SELECT TABLE tbl_name

  ঘ

  SELECT tbl_name
• Suppose you want to select a database named ‘sampledb’ as the default database. Which of the following commands do you use?
  ক

  SELECT DATABASE()

  খ

  SELECT DATABASE sampledb

  গ

  USE DATABASE sampledb

  ঘ

  USE sampledb
• The query ‘SELECT NOW()’ shows the current _____________
  ক

  table

  খ

  time only

  গ

  date only

  ঘ

  date and time
• Which of the following options tells mysql to ask for entering the password?
  ক

  -e

  খ

  -p

  গ

  -u

  ঘ

  -h
• MySQL client runs on the machine containing the databases and servers connect to the client over a network.
  ক

  True

  খ

  False
• Which clause is used to sort query elements?
  ক

  GROUP

  খ

  GROUP BY

  গ

  ORDER

  ঘ

  ORDER BY
• What does comparing a known value with NULL result into?
  ক

  zero

  খ

  a positive value

  গ

  a negative value

  ঘ

  null
• The NULL value also means ___________
  ক

  value equal to zero

  খ

  unknown value

  গ

  negative values

  ঘ

  a large value
• Which operator is used to perform integer divisions in MySQL?
  ক

  /

  খ

  \

  গ

  DIV

  ঘ

  //
• The special database that always exists after setting up MySQL in a computer is __________
  ক

  sampdb

  খ

  mysql

  গ

  information_schema

  ঘ

  readme_db
• Which of the following clauses is used to display information that match a given pattern?
  ক

  LIKE

  খ

  WHERE

  গ

  IS

  ঘ

  SAME