MySQL Quiz

Welcome to your MySQL Quiz

Name
1.

what command used for view the structure of a table?


2.

SELECT LCASE(‘My Name is Pranjali’);


Following Command output is?

3.

Following command used in MySQL for ______________.


INSERT INTO STUDENT1

SELECT * FROM STUDENT2

WHERE ID>1006;

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

5.

Drop command used for?


6.

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


7.

SQL Stand for?


8.

DELETE command used for?


9.

How to modifying data of a table?


10.

SHOW TABLES command used for?


11.

DISTINCT command be used for more than one column?


12.

MySQL is freely available and is open source.


13.

SELECT id, name, fee+100 FROM STUDENTS;


the syntax of the command is?

14.

Can you define multiple PRIMARY KEY in a table?


15.

___________ is the synonym of DATABASE.


16.

CREATE command used for?


17.

______ not a numeric datatype.


18.

Which one is not a logical operator in MySQL?


19.

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


20.

What statement use for change the table name?


21.

Table ‘Students‘ have 20 records and Table ‘School‘ have 17 records.


SELECT * FROM STUDENTS, SCHOOL;


After the passing Query, how many record will show in the table?


22.

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


23.

Which is the MySQL instance responsible for data processing?


24.

What is Cardinality?


25.

__________ not an Integrity Constraints.


26.

What does ‘address’ represent in the following code snippet?


CREATE TABLE students
(
id integer,
name CHAR(20),
dob date,
address CHAR(30),
mobile bigint
);

27.

MySQL is the type of ______________Database management system.


28.

SELECT RIGHT(‘JOIN ARMY‘ , 5);


output is?

29.

Attributes is also known as _________.


30.

UPDATE COMMAND USED FOR?


31.

Find the YEAR in “19201212202018” TIMESTAMP?


32.

Output of the Following command –


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

33.

How do you select all the columns from a table named “Persons”?


34.

Which statement is used to select a default database?


35.

What represents a ‘tuple’ in a relational database?


36.

Fill the blanks with suitable options? BETWEEN ______ AND ______


37.

What is Degree in relational database?


38.

Correct way to get the current date?


39.

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


40.

What command used for add integrity constraints in existing table?




All the Best…