MySQL

Welcome to your MySQL Quiz

Name
1.

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


2.

The name of Chief Inventor of MySQL?


3.

Drop command used for?


4.

Fill the blanks with suitable options? BETWEEN ______ AND ______


5.

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


6.

DELETE command used for?


7.

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


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


8.

SELECT RIGHT('JOIN ARMY' , 5);


output is?

9.

__________ Key is used to link two tables in MySQL.


10.

DISTINCT command be used for more than one column?


11.

Attributes is also known as _________.


12.

Can you define multiple PRIMARY KEY in a table?


13.

Which statement is used to select a default database?


14.

SELECT SUBSTR('VISHAL', 2, 3);


Output is?

15.

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


16.

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


output of the following command is?

17.

CREATE command used for?


18.

MySQL is freely available and is open source.


19.

Which one is not a logical operator in MySQL?


20.

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


21.

SELECT id, name, fee+100 FROM STUDENTS;


the syntax of the command is?

22.

Data Organized in a MySQL DBMS into__________.


23.

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


24.

___________ is the synonym of DATABASE.


25.

What is Degree in relational database?


26.

______ not a numeric datatype.


27.

__________ not an Integrity Constraints.


28.

What is Cardinality?


29.

What command used for add integrity constraints in existing table?


30.

SELECT LCASE('My Name is Pranjali');


Following Command output is?

31.

How do I find out all databases starting with ‘test‘?


32.

SHOW TABLES command used for?


33.

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?


34.

Which SQL statement is used to return only different values?


35.

UPDATE COMMAND USED FOR?


36.

MySQL is the type of ______________Database management system.


37.

Following command used in MySQL for ______________.


INSERT INTO STUDENT1

SELECT * FROM STUDENT2

WHERE ID>1006;

38.

What statement use for change the table name?


39.

Output of the Following command -


Select CONCAT ('Join' , 'Group');

40.

__________clause is used to “Filters out unwanted data”




All the Best...



You may also like...

Leave a Reply

Your email address will not be published.