MySQL

Welcome to your MySQL Quiz

Name
1.

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


2.

Correct way to get the current date?


3.

Drop command used for?


4.

Which statement is used to select a default database?


5.

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


6.

Which SQL statement is used to return only different values?


7.

SELECT LENGTH('I am with you');


Output is?

8.

The name of Chief Inventor of MySQL?


9.

Full form of RDBMS?


10.

__________ Key is used to link two tables in MySQL.


11.

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?


12.

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


13.

What is Cardinality?


14.

Change the column name of a table using_________ command.


15.

__________ not an Integrity Constraints.


16.

SELECT id, name, fee+100 FROM STUDENTS;


the syntax of the command is?

17.

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


18.

UPDATE COMMAND USED FOR?


19.

Fill the blanks with suitable options? BETWEEN ______ AND ______


20.

Attributes is also known as _________.


21.

Which one is not a logical operator in MySQL?


22.

MySQL is the type of ______________Database management system.


23.

What command used for add integrity constraints in existing table?


24.

MySQL is freely available and is open source.


25.

Can you define multiple PRIMARY KEY in a table?


26.

DELETE command used for?


27.

What statement use for change the table name?


28.

DISTINCT command be used for more than one column?


29.

What represents a ‘tuple’ in a relational database?


30.

SELECT LCASE('My Name is Pranjali');


Following Command output is?

31.

SHOW TABLES command used for?


32.

SQL Stand for?


33.

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


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

34.

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


35.

CREATE command used for?


36.

___________ is the synonym of DATABASE.


37.

______ not a numeric datatype.


38.

Data Organized in a MySQL DBMS into__________.


39.

Output of the Following command -


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

40.

Which is the MySQL instance responsible for data processing?




All the Best...



You may also like...

Leave a Reply

Your email address will not be published.