Advance MySQL MCQ Interview Question’s & Answer’s -

Advance MySQL

1 / 10

Can we have more than 1 primary key in a table?

TRUE

FALSE

2 / 10

State whether the statement is true or false? 'PRIMARY KEY and UNIQUE KEY both are the same'

TRUE

FALSE

3 / 10

If you are asked to find out the names which only have 5 characters then what query pattern you will use?

%%%%%

_%_%_

_____

--%%-

4 / 10

Suppose you are asked to display all the names which have 'a' as their second character then which query pattern you will use?

_ _ a%;

_a_;

_a%;

_%a;

5 / 10

Suppose you have 1000 records and you only want 100 records which of the following clause you will use?

SET LIMIT

LIMIT

HAVING

GROUP BY

6 / 10

From all the clauses in MYSQL what task is performed by the DISTINT clause?

It returns us the duplicate values

It returns us the unique values

It returns us the NULL values;

It returns us the ALL values;

7 / 10

Which of the following is the correct syntax for using the TRUNCATE statement?

TUNCATE TABLE-NAME;

TRUNCATE TABLE-NAME DATABASE-NAME;

TRUNCATE TABLE TABLE-NAME;

TRUNCATE DATABASE-NAME TABLE-NAME;

8 / 10

If you are asked to delete the entire data of a table without disturbing the table definition then in such case which statement you will use?

DELETE

TRUNCATE

DROP

CLEAR

9 / 10

What is the function of DESCRIBE statement?

This statement helps us to get the details of the entire row.

This statement helps us to get the definition of a particular table at a time.

This statement helps us to get the definition of all the tables.

This statement helps us to get the definition of all the values..

10 / 10

Suppose you have two columns named student_name and student_department inside table student_details and you are asked to update the value of these two columns where ID=4 then what statement you will write?

UPDATE student_details SET Student_name="ram", Student_department='Chemical' WHERE ID='4';

UPDATE table student_details SET column_name Student_name="ram", Student_department='Chemical' WHERE ID='4';

UPDATE student_details SET Student_name="ram" and Student_department='Chemical' WHERE ID='4';

UPDATE student_details SET Student_name="ram" and Student_department='Chemical' WHERE ID='3';

Your score is

The average score is 0%

0%

Breadcrumb navxt shortcode

How to Apply jQuery UI Datepicker in WordPress?

wordpress featured image size – 1200 x 628 pixels(Best WordPress Featured Image Size & Best Practices)

wordpress base url – how to get the base url in PHP?

custom search form wordpress – How to Create Custom Search Form in WordPress?

get featured image url by post id – How to get WordPress post featured image URL?.

How to send mail in WordPress without plugin?

Advance MySQL MCQ Interview Question’s & Answer’s