MySql MCQ
Soopro Pathshala provides MySql MCQ(Multiple Choice Questions)
1. In which form MYSQL query results are displayed?
a) LIST
b) TUPLE
c) ROWS and COLUMNS
d) LIST and Tuples both
View Answer
Answer: (c) Rows and Columns
2. To see all the databases which command is used?
a) Show database
b) Show databases;
c) Show databaes();
d) Show_all database;
View Answer
Answer: (b) Show databases;
3. ALTER command is a type of which SQL command?
a) DML
b) DDL
c) DCL
d) DQL
View Answer
4. Which key is commonly known as a subset of a super key?
a) Candidate Key
b) Foregin key
c) Primary key
d) Unique key
View Answer
Answer: (a) candidate key
5. TCL is used for___?
a) Manage the changes made by DML statements
b) Defining database schema
c) Control access to data stored in a database
d) None of the above
View Answer
Answer: (a) Manage the changes made by DML statements
6. Storing same data in many places is called
a) Iteration
b) Concurrency
c) Redundancy
d) Enumeration
View Answer
7. Which of the following can add a row to a table?
a) Alter
b) Add
c) Insert
d) Create
View Answer
8. MySql runs on which operating systems?
a) Unix and Linux only
b) Linux and Mac OS-X only
c) Unix, Linux, Windows and others
d) Any operating system at all
View Answer
Answer: (c) Unix, Linux, Windows and others
9. Which of the following is NOT supported by MySql.
a) Temporary (Hash) Tables
b) Table joining
c) Stored Procedures
d) Regular Expression Matching
View Answer
Answer: (c) Stored Procedures
10. If you want to undo a GRANT, you should use
a) REVOKE
b) UNDO
c) UNGRANT
d) DELETE
View Answer