Similar Collections

    No collections found

MySQL is the most common open-source software, nowadays every other person relies on MYSQL for its database. As it is open source so anyone in this world can use this system. This system is developed by ORACLE cooperation.

MySQL MCQs: This section contains multiple-choice questions and answers on the various topics of MySQL. Practice these MCQs to test and enhance your skills on MySQL.

 

questions

Title
In which language MYSQL is written?

In which language MYSQL is written?

  1. PYTHON
  2. C/C++
  3. JAVA
  4. COBOL
discuss
To see the list of options provided by MYSQL which of the following command is used?

To see the list of options provided by MYSQL which of the following command is used?

  1. HELP
  2. –HELP
  3. -- HELP
  4. ELP-
discuss
What do you mean by HOST in MYSQL?

What do you mean by HOST in MYSQL?

  1. HOST is the user name.
  2. HOST is the representation of where the MYSQL server is running.
  3. HOST is the administration’s machine name.
discuss
Is a semicolon necessary after every query?

Is a semicolon necessary after every query?

  1. TRUE
  2. FALSE
discuss
To know your MYSQL version and current date which of the following command you should use?

To know your MYSQL version and current date which of the following command you should use?

  1. VERSION, CURRENT_DATE();
  2. SELECT VERSION, CURRENTDATE();
  3. SELECT VERSION(), CURRENT_DATE;
  4. SELECT VERSON(),CURRENT_DATE();
discuss
What is the work of UPDATE command?

What is the work of UPDATE command?

  1. A single or multiple rows can be accessed using this command from one or more tables of a database. Using the WHERE clause with this command is also possible.
  2. Using this command, you can remove or erase recorded information from a database table.
  3. Database data can be updated or changed using this command.
  4. It enables you to create new databases, tables, table views, and other objects using this command.
discuss
In which form MYSQL query results are displayed?

In which form MYSQL query results are displayed?

  1. LIST
  2. TUPLE
  3. ROWS AND COLUMNS
  4. LIST AND TUPLES BOTH
discuss
What does the marked time represent in the given picture?

What does the marked time represent in the given picture?

  1. CPU TIME
  2. MACHINE TIME
  3. WALL CLOCK TIME
discuss
In MYSQL, can we write keywords in any letter case?

In MYSQL, can we write keywords in any letter case?

  1. YES
  2. NO
discuss
In MYSQL, can you write multiple statements in a single line?

In MYSQL, can you write multiple statements in a single line?

  1. YES
  2. NO
discuss
If you want to stop the processing query then which of the following command you should use?

If you want to stop the processing query then which of the following command you should use?

  1. QUIT
  2. STOP
  3. /c
  4. C and D both
discuss
To see all the databases which command is used?

To see all the databases which command is used?

  1. Show database;
  2. Show databases;
  3. Show database();
  4. Show_all database;
discuss
Can we create a database named 01_test?

Can we create a database named 01_test?

  1. YES
  2. NO
discuss
In the following statement, what do you mean by the 'student'?

In the following statement, what do you mean by the 'student'?

USE student;
  1. Database name
  2. Row name
  3. Column name
  4. Table name
discuss
If our database name is 'schooldb' and we want to drop this database will the query work if we will write our database name in capital letters?

If our database name is 'schooldb' and we want to drop this database will the query work if we will write our database name in capital letters?

  1. YES
  2. NO
discuss
Which of the following command is used to delete a database?

Which of the following command is used to delete a database?

  1. DELETE DATABASE_NAME;
  2. DROP DATABASE_NAME;
  3. DROP DATABASE DATABASE_NAME;
  4. DELETE DATABASE DATABASE_NAME;
discuss
ALTER command is a type of which SQL command?

ALTER command is a type of which SQL command?

  1. DML
  2. DDL
  3. DCL
  4. DQL
discuss
Which of the following is the correct syntax to add a field using alter command?

Which of the following is the correct syntax to add a field using alter command?

  1. ALTER TABLE table_name ADD field_name data type;
  2. ALTER TABLE table_name, field_name data type;
  3. ALTER TABLE field_name data type;
discuss
Can you change the column name using alter command?

Can you change the column name using alter command?

  1. YES
  2. NO
discuss
Suppose you have a table named to test and inside this table you have a column named CGPA now if you are asked to change the column named CGPA to total percentage, using alter command then which of the following statement you will write?

Suppose you have a table named to test and inside this table you have a column named CGPA now if you are asked to change the column named CGPA to total percentage, using alter command then which of the following statement you will write?

  1. ALTER TABLE test CHANGE COLUMN 'cgpa’ 'total_percentage’ int;
  2. ALTER test table CHANGE 'cgpa’ ,'total_percentage’ int;
  3. ALTER TABLE test CHANGE 'cgpa 'total_percentage’ int;
discuss
total MCQs: 51

MCQs

51

Views

90

Best Answers

299

Points

5