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

Online Test for Mysql

1. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
   Candidate key
   Sub key
   Super key
   Foreign key

---

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

---

---

3. Function which causes retrieval of any kind of data from database is considered as
   Interface or Signature
   User friendly signature
   Conceptual signature
   Logical signature

---

4. To remove a relation from an SQL database, we use the ______ command.
   Delete
   Purge
   Remove
   Drop table

---

5. What will be the output of this query UPDATE tab_name SET col1 = col1 + 1, col2 = col1;
   col1 and col2 have different value
   col1 and col2 have same value
   col2 has original value of col1
   None of the above

---

6. The term attribute refers to a ___________ of a table.
   Record
   Column
   Tuple
   Key

---

---

7. Which statement is used to displays information about the columns in a table.
   SHOW COLUMNS FROM tbl_job;
   EXPLAIN tbl_job;
   DESCRIBE tbl_job;
   All the above

---

8. Which clause is used to sort the result of SELECT statement?
   SORT BY
   ORDER BY
   ARRENGE BY
   None of the above

---

9. DCL is used to _______?
   Manage the changes made by DML statements
   Inserting, Deleting and Updating data
   Control access to data stored in a database
   None of the above

---

10. The data type BLOB stands for:
    Binary Large Object
    Big List Object
    Binary List Object
    None of the above

---