Using MySQL Command Line Tool MCQ

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

• Which command is used for showing current date and time in Mysql command line tool?
  ক

  select now()

  খ

  SELECT now();

  গ

  SELECT now()

  ঘ

  None of the mentioned
• Mysql command line tool is used to show “how many rows are returned and how long SQL command took to execute”.
  ক

  True

  খ

  False

  গ

  Undetermined

  ঘ

  Depend
• Which authentications are required for login into Mysql command line tool?
  ক

  Username

  খ

  Password

  গ

  Only Username

  ঘ

  Both Username and Password
• Which command is used for taking “server side help” in Mysql command line tool?
  ক

  /h

  খ

  /c

  গ

  /e

  ঘ

  None of the mentioned
• Which command is used in Mysql command line tool to return to window command shell?
  ক

  exit;

  খ

  quit;

  গ

  both exit; and quit;

  ঘ

  only exit;
• Which command is used on Mysql command line tool to return to window command shell?
  ক

  exit

  খ

  exit;

  গ

  exit()

  ঘ

  exit();
• The “Mysql command line tool” formats are bounded by ______________
  ক

  +-|

  খ

  +-*

  গ

  +-/

  ঘ

  +-}
• The “Mysql command line tool” format the results in which of the following format?
  ক

  Rectangle

  খ

  Square

  গ

  Sphere

  ঘ

  None of the mentioned
• Which statement is used to access an existing Database?
  ক

  Use

  খ

  use database.name

  গ

  USE databasename;

  ঘ

  None of the mentioned