MySQL

Welcome to your MySQL Quiz

Name
1.

Data Organized in a MySQL DBMS into__________.


2.

______ not a numeric datatype.


3.

Following command used in MySQL for ______________.


INSERT INTO STUDENT1

SELECT * FROM STUDENT2

WHERE ID>1006;

4.

MySQL is freely available and is open source.


5.

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


6.

___________ is the synonym of DATABASE.


7.

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


output of the following command is?

8.

Which statement is used to select a default database?


9.

SELECT LCASE('My Name is Pranjali');


Following Command output is?

10.

Find the YEAR in "19201212202018" TIMESTAMP?


11.

SHOW TABLES command used for?


12.

What statement use for change the table name?


13.

Fill the blanks with suitable options? BETWEEN ______ AND ______


14.

Which SQL statement is used to return only different values?


15.

Change the column name of a table using_________ command.


16.

DISTINCT command be used for more than one column?


17.

Can you define multiple PRIMARY KEY in a table?


18.

What is Degree in relational database?


19.

How to modifying data of a table?


20.

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


21.

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


22.

__________ Key is used to link two tables in MySQL.


23.

What represents a ‘tuple’ in a relational database?


24.

Attributes is also known as _________.


25.

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?


26.

SELECT RIGHT('JOIN ARMY' , 5);


output is?

27.

SQL Stand for?


28.

what command used for view the structure of a table?


29.

The name of Chief Inventor of MySQL?


30.

__________ not an Integrity Constraints.


31.

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


32.

UPDATE COMMAND USED FOR?


33.

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


34.

Full form of RDBMS?


35.

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


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


36.

__________clause is used to “Filters out unwanted data”


37.

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


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

38.

CREATE command used for?


39.

What command used for add integrity constraints in existing table?


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.