MySQL

Welcome to your MySQL Quiz

Name
1.

Full form of RDBMS?


2.

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?


3.

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


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

4.

__________clause is used to “Filters out unwanted data”


5.

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


6.

CREATE command used for?


7.

___________ is the synonym of DATABASE.


8.

__________ Key is used to link two tables in MySQL.


9.

SELECT LCASE('My Name is Pranjali');


Following Command output is?

10.

DELETE command used for?


11.

SQL Stand for?


12.

Can you define multiple PRIMARY KEY in a table?


13.

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


Output is?

14.

What statement use for change the table name?


15.

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


output of the following command is?

16.

Attributes is also known as _________.


17.

Change the column name of a table using_________ command.


18.

What is Cardinality?


19.

Correct way to get the current date?


20.

Output of the Following command -


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

21.

SELECT LENGTH('I am with you');


Output is?

22.

The name of Chief Inventor of MySQL?


23.

MySQL is freely available and is open source.


24.

Which SQL statement is used to return only different values?


25.

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


26.

Which one is not a logical operator in MySQL?


27.

Fill the blanks with suitable options? BETWEEN ______ AND ______


28.

UPDATE COMMAND USED FOR?


29.

SHOW TABLES command used for?


30.

SELECT RIGHT('JOIN ARMY' , 5);


output is?

31.

What is Degree in relational database?


32.

Find the YEAR in "19201212202018" TIMESTAMP?


33.

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


34.

Drop command used for?


35.

Following command used in MySQL for ______________.


INSERT INTO STUDENT1

SELECT * FROM STUDENT2

WHERE ID>1006;

36.

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


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


37.

What command used for add integrity constraints in existing table?


38.

Data Organized in a MySQL DBMS into__________.


39.

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


40.

What represents a ‘tuple’ in a relational database?




All the Best...



You may also like...

Leave a Reply

Your email address will not be published.