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

Online Test for Mysql

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

---

2. Which statement is used to connect with mysql server?
   mysql -h host_name -u user_name -p password
   mysql -u user_name -p password -h host_name
   mysql -p password -u user_name -h host_name
   All the above

---

---

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

---

4. Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database ?
   DML(Data Manipulation Langauge)
   DDL(Data Definition Langauge)
   Query
   Relational Schema

---

5. Which is right statement to import data from text file in MySQL on shell editor?
   shell> mysql -host host_name -u user_name -p password db_name < text_file
   shell> mysql -host host_name -u user_name -p password db_name > text_file
   shell> mysql < text_file
   All the above

---

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

---

---

7. Which of the following statements creates a new table temp instructor that has the same schema as instructor.
   create table temp_instructor;
   Create table temp_instructor like instructor;
   Create Table as temp_instructor;
   Create table like temp_instructor;

---

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

---

9. Drop Table cannot be used to drop a table referenced by a ______________ constraint.
   Primary Key
   Sub Key
   Super Key
   Foreign Key

---

10. Which of the following is used to delete an entire MYSQL database?
    drop entiredb dbname
    drop database dbname
    drop db dbname
    drop dbase dbname

---