1. PlacementQuestion
2. Mysql Interview Questions
3. Online Test for Mysql

Online Test for Mysql

1. Which statement is wrong to select particular columns from table?
   SELECT id, question FROM placement_question;
   SELECT id, question FROM placement_question WHERE id = '2';
   SELECT id, question FROM placement_question WHERE 1;
   All are right

---

2. "CREATE DATABASE db_name" statement is used to create database.
   True
   False

---

---

3. Which level of Abstraction describes what data are stored in the Database?
   Physical Level
   View Level
   Abstraction Level
   Logical Level

---

4. In SQL, __________ is an Aggregate function.
   SELECT
   CREATE
   AVG
   MODIFY

---

5. Which is right statement to insert multiple records?
   INSERT INTO job_question VALUES ('col1', 'col2'), ('col1', 'col2'), ...
   INSERT INTO job_question VALUES ('col1', 'col2'), VALUES ('col1', 'col2'), ...
   A and B Both
   None of the above

---

6. _____ is process of extracting previously non known valid and actionable information from large data to make crucial business and strategic decisions.
   Data Management
   Database
   Data Mining
   Meta Data

---

---

7. Data Warehouse provides
   Transaction Responsiveness
   Demand and Supply Responsiveness
   Storage, Functionality Responsiveness to queries
   None of the above

---

8. How to set value of "query_cache_size" MYSQL system variable
   SET GLOBAL query_cache_size = 41980;
   SET GLOBAL VARIABLE query_cache_size = 41980;
   SET VARIABLE GLOBAL query_cache_size = 41980;
   None of the above

---

9. DML is used for _______?
   Control access to data stored in a database
   Defining database schema
   Inserting, Deleting and Updating data
   None of the above

---