MySQL

Welcome to your MySQL Quiz

Name
1.

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


2.

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


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


3.

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


output of the following command is?

4.

Data Organized in a MySQL DBMS into__________.


5.

What statement use for change the table name?


6.

___________ is the synonym of DATABASE.


7.

CREATE command used for?


8.

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


9.

SQL Stand for?


10.

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


11.

Attributes is also known as _________.


12.

MySQL is the type of ______________Database management system.


13.

__________clause is used to “Filters out unwanted data”


14.

DISTINCT command be used for more than one column?


15.

SELECT id, name, fee+100 FROM STUDENTS;


the syntax of the command is?

16.

__________ Key is used to link two tables in MySQL.


17.

what command used for view the structure of a table?


18.

Full form of RDBMS?


19.

Find the YEAR in "19201212202018" TIMESTAMP?


20.

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


21.

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?


22.

Drop command used for?


23.

Can you define multiple PRIMARY KEY in a table?


24.

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


25.

Which SQL statement is used to return only different values?


26.

DELETE command used for?


27.

What is Degree in relational database?


28.

SELECT RIGHT('JOIN ARMY' , 5);


output is?

29.

______ not a numeric datatype.


30.

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


31.

Correct way to get the current date?


32.

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


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.

What represents a ‘tuple’ in a relational database?


35.

SHOW TABLES command used for?


36.

__________ not an Integrity Constraints.


37.

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


Output is?

38.

What is Cardinality?


39.

SELECT LCASE('My Name is Pranjali');


Following Command output is?

40.

UPDATE COMMAND USED FOR?




All the Best...



You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

Skip to toolbar