MySQL

Welcome to your MySQL Quiz

Name
1.

___________ is the synonym of DATABASE.


2.

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


output of the following command is?

3.

CREATE command used for?


4.

The name of Chief Inventor of MySQL?


5.

Output of the Following command -


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

6.

Attributes is also known as _________.


7.

DELETE command used for?


8.

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?


9.

Change the column name of a table using_________ command.


10.

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


11.

SELECT RIGHT('JOIN ARMY' , 5);


output is?

12.

What statement use for change the table name?


13.

what command used for view the structure of a table?


14.

Find the YEAR in "19201212202018" TIMESTAMP?


15.

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


16.

Correct way to get the current date?


17.

DISTINCT command be used for more than one column?


18.

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


19.

Which statement is used to select a default database?


20.

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


21.

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


Output is?

22.

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


23.

__________clause is used to “Filters out unwanted data”


24.

Drop command used for?


25.

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


26.

UPDATE COMMAND USED FOR?


27.

SELECT LENGTH('I am with you');


Output is?

28.

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


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


29.

Following command used in MySQL for ______________.


INSERT INTO STUDENT1

SELECT * FROM STUDENT2

WHERE ID>1006;

30.

Which one is not a logical operator in MySQL?


31.

SELECT LCASE('My Name is Pranjali');


Following Command output is?

32.

Fill the blanks with suitable options? BETWEEN ______ AND ______


33.

SHOW TABLES command used for?


34.

Data Organized in a MySQL DBMS into__________.


35.

Which SQL statement is used to return only different values?


36.

Full form of RDBMS?


37.

What represents a ‘tuple’ in a relational database?


38.

__________ not an Integrity Constraints.


39.

What command used for add integrity constraints in existing table?


40.

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




All the Best...



You may also like...

Leave a Reply

Your email address will not be published.