Top 10 Mysql Interview question with answer of sql for education

Basic question and answer sheet for interview question on basic sql queries.

The future work skills report identifies how to sruvive in a changing job market. What does it mean for graduates? The future work skills report predicts that six tends will dominate the job market over the next 10 years. To be successful, employees will need to acquire 10 key skills. Here are the list of some sql skills that are basic requirement of questions that are to be prepared for facing interview question Education.

1. Which of the following are not Numeric column types?

a. BIGINT b. LARGEINT c. SMALLINT d. DOUBLE e. DECIMAL
Answer: b

2. What Privilege do you need to create a function?

a. UPDATE b. CREATE ROUTINE c. SELECT d. CREATE FUNCTION e. No Specific privilege
Answer: b

3. You want to display the titles of book that meet the following criteria:

1. Purchased before November 11, 2002

2. Price is less than $500 or greater than $900

You want to sort the result by the date of purchase, starting with the most recently bought book.

Which of the following statements should you use?

a.       SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date<'2002-11-11' ORDER BY purchase_date;

b.      SELECT book_title FROM books WHERE price IN (500, 900) AND purchase_date<'2002-11-11'
ORDER BY purchase date ASC;

c.       SELECT book_title FROM books WHERE price<500 OR>900 AND purchase_date DESC;

d.      SELECT book_title FROM books WHERE (price<500 OR price>900) AND purchase_date<'2002-11-11' ORDER BY purchase_date DESC;
Answer: d

4. Which of the following are true in case of Indexes for MYISAM Tables?

Note: There may be more than one right answer.

a.       Indexes can have Null values

b.      BLOB and TEXT columns can be indexed

c.       Indexes per table cannot be more than 16

d.      Columns per index cannot be more than 16.

Answer: a,b,d

5. Consider the following table structure of students:

rollno int
name varchar(20)
course varchar(20)

What will be the query to display the courses in which the number of students enrolled is more than 5?

a.       Select course from students where count(course)>5;

b.      Select course from students where count(*)>5 group by course;

c.       Select course from students group by course;

d.      Select course from students group by course having count(*)>5;

e.       select course from students group by course
Answer: d

6. State whether true or false:

Transactions and commit/rollback are supported by MySQL using the MyISAM engine

a.       True

b.       False
Answer: a

7. What is NDB?

a.       An in-memory storage engine offering high-availability and data-persistence features

b.      A filesystem

c.       An SQL superset

d.      MySQL scripting language

e.      None of the above
Answer: a

8. Which of the following database engines uses table-level locking?

a.       MyISAM

b.      InnoDB

c.       Both

d.      None
Answer: a

9.  Which of the following statements are true?

Note: There may be more than one right answer.

a.       Names of databases, tables and columns can be up to 64 characters in length.

b.      Alias names can be up to 255 characters in length

c.       Names of databases, tables and columns can be up to 256 characters in length

d.      Alias names can be up to 64 characters in length

Answer: a,b

10. What is the name of the utility used to extract NDB configuration information?

a.       Ndb_config

b.      Cluster_config

c.       Ndb –config

d.      configNd

e.      None of the above.
Answer: a