MySQL

Welcome to your MySQL Quiz

Name
1.

what command used for view the structure of a table?


2.

__________ not an Integrity Constraints.


3.

MySQL is freely available and is open source.


4.

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


5.

SHOW TABLES command used for?


6.

DELETE command used for?


7.

What command used for add integrity constraints in existing table?


8.

Which SQL statement is used to return only different values?


9.

Which is the MySQL instance responsible for data processing?


10.

What represents a ‘tuple’ in a relational database?


11.

Which statement is used to select a default database?


12.

Following command used in MySQL for ______________.


INSERT INTO STUDENT1

SELECT * FROM STUDENT2

WHERE ID>1006;

13.

Data Organized in a MySQL DBMS into__________.


14.

CREATE command used for?


15.

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


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

16.

SELECT LENGTH('I am with you');


Output is?

17.

___________ is the synonym of DATABASE.


18.

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


19.

SELECT id, name, fee+100 FROM STUDENTS;


the syntax of the command is?

20.

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


21.

Correct way to get the current date?


22.

How to modifying data of a table?


23.

SELECT RIGHT('JOIN ARMY' , 5);


output is?

24.

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


25.

MySQL is the type of ______________Database management system.


26.

Which one is not a logical operator in MySQL?


27.

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


28.

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


29.

The name of Chief Inventor of MySQL?


30.

Full form of RDBMS?


31.

SELECT LCASE('My Name is Pranjali');


Following Command output is?

32.

__________clause is used to “Filters out unwanted data”


33.

Attributes is also known as _________.


34.

Fill the blanks with suitable options? BETWEEN ______ AND ______


35.

SQL Stand for?


36.

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?


37.

Output of the Following command -


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

38.

What is Cardinality?


39.

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


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


40.

Change the column name of a table using_________ command.




All the Best...



You may also like...

Leave a Reply

Your email address will not be published.