1. Placement Question
2. Mysql Interview Questions
3. Mysql Multiple Choice Questions

Mysql Multiple Choice Questions

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

---

---

26. Type data abstraction which allows conceptual representation of data in database management system is considered as
    1. Logical design model
    2. Data model
    3. Interface model
    4. User friendly model

---

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

---

---

28. The student marks should not be greater than 100. This is
    1. Integrity constraint
    2. Referential constraint
    3. Over-defined constraint
    4. Feasible constraint

---

29. BCNF Stands for _________.
    1. Binary Coded Normal Form
    2. Boyce - Codd Normal Form
    3. Bit Code Normal Form
    4. Boyce Codd Natural Form

---

30. In an RDBMS relationship between tables are created by using
    1. Alternate Keys
    2. Foreign Keys
    3. Candidate Keys
    4. Composite Keys

---

---

31. In order to add a new column to an existing table in SQL, we can use the command
    1. MODIFY TABLE
    2. EDIT TABLE
    3. ALTER TABLE
    4. ALTER COLUMNS

---

32. Which of the following statements is NOT true for views in SQL?
    1. Select statement used in the view definition cannot include ORDER BY clause.
    2. A view drives its data from the base tables(s)
    3. A view is updatable if it has been defined from a single relation
    4. A view contains a copy of the data

---