MySQL Quiz

Welcome to your MySQL Quiz

Name
1.

SQL Stand for?


2.

Output of the Following command –


Select CONCAT (‘Join’ , ‘Group’);

3.

DISTINCT command be used for more than one column?


4.

SELECT RIGHT(‘JOIN ARMY‘ , 5);


output is?

5.

DELETE command used for?


6.

Can you define multiple PRIMARY KEY in a table?


7.

Which is the MySQL instance responsible for data processing?


8. <h4>What does ‘address’ represent in the following code snippet?</h4><br /> CREATE TABLE students<br /> (<br /> id integer,<br /> name CHAR(20),<br /> dob date,<br /> address CHAR(30),<br /> mobile bigint<br /> );

9. <h4><span id="lblQuestion" class="question">DISTINCT command be used for more than one column?</span></h4>

10.

Which is the default order of sort in ORDER BY clause?


11.

Which SQL statement is used to return only different values?


12.

SELECT LENGTH(‘I am with you‘);


Output is?

13.

__________clause is used to “Filters out unwanted data”


14.

___________ is the synonym of DATABASE.


15.

What is Cardinality?


16.

________ keyword is used to sort the result-set IN MySQL.


17.

Change the column name of a table using_________ command.


18. <h4><span id="lblQuestion" class="question">How do I find out all databases starting with ‘test‘?</span></h4>

19.

What command used for add new column in the table of Database?


20.

SELECT LCASE(‘My Name is Pranjali’);


Following Command output is?

21.

The name of Chief Inventor of MySQL?


22.

Following command used in MySQL for ______________.


INSERT INTO STUDENT1

SELECT * FROM STUDENT2

WHERE ID>1006;

23.

What is Degree in relational database?


24.

Which statement is used to select a default database?


25.

Full form of RDBMS?


26.

% (percent) or _ (underscore) sign used with ____________?


27.

SELECT id, name, fee+100 FROM STUDENTS;


the syntax of the command is?

28.

SELECT LEFT(‘NEW/12/MySQL/18‘ , 5);


output of the following command is?

29.

How to modifying data of a table?


30.

SHOW TABLES command used for?


31.

______ not a numeric datatype.


32.

MySQL is the type of ______________Database management system.


33.

Drop command used for?


34.

What command used for change the column property of the table?


35.

CREATE command used for?


36.

UPDATE COMMAND USED FOR?


37.

What command used for add integrity constraints in existing table?


38.

MySQL is freely available and is open source.


39.

What represents a ‘tuple’ in a relational database?


40.

Correct way to get the current date?




All the Best…