MySQL

Welcome to your MySQL Quiz

Name
1.

Correct way to get the current date?


2.

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


3.

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


output of the following command is?

4.

Following command used in MySQL for ______________.


INSERT INTO STUDENT1

SELECT * FROM STUDENT2

WHERE ID>1006;

5.

Fill the blanks with suitable options? BETWEEN ______ AND ______


6.

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


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

7.

what command used for view the structure of a table?


8.

SELECT id, name, fee+100 FROM STUDENTS;


the syntax of the command is?

9.

______ not a numeric datatype.


10.

SELECT LCASE('My Name is Pranjali');


Following Command output is?

11.

Which one is not a logical operator in MySQL?


12.

Drop command used for?


13.

___________ is the synonym of DATABASE.


14.

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?


15.

What is Cardinality?


16.

Full form of RDBMS?


17.

CREATE command used for?


18.

Output of the Following command -


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

19.

Data Organized in a MySQL DBMS into__________.


20.

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


21.

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


22.

SQL Stand for?


23.

MySQL is the type of ______________Database management system.


24.

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


25.

__________clause is used to “Filters out unwanted data”


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.

What represents a ‘tuple’ in a relational database?


28.

How to modifying data of a table?


29.

Attributes is also known as _________.


30.

Which SQL statement is used to return only different values?


31.

Which statement is used to select a default database?


32.

DELETE command used for?


33.

UPDATE COMMAND USED FOR?


34.

What command used for add integrity constraints in existing table?


35.

DISTINCT command be used for more than one column?


36.

The name of Chief Inventor of MySQL?


37.

What is Degree in relational database?


38.

__________ Key is used to link two tables in MySQL.


39.

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


Output is?

40.

Can you define multiple PRIMARY KEY in a table?




All the Best...



You may also like...

Leave a Reply

Your email address will not be published.