DBMS-MySQL Question and Answer
DBMS-MySQL Question and Answer
11. To remove duplicate rows from the result set of a SELECT use the following keyword:
- NO DUPLICATE
- UNIQUE
- DISTINCT
- None of the above
13. To use MySQL on your computer, you'll need?
- FTP and Telnet
- Some sort of client program to access the databases
- A Browser
- Perl, PHP or Java
14. Which SQL statement is used to insert a new data in a database?
- INSERT INTO
- UPDATE
- ADD
- INSERT NEW
15. In a LIKE clause, you can could ask for any value ending in "qpt" by writing
- LIKE %qpt
- LIKE *ton
- LIKE ton$
- LIKE ^.*ton$
17. MySQL is
- A Programming language
- A Programming language
- A technique for writing reliable programs
- A Relational Database Management System
18. In a LIKE clause, you can ask for any 6 letter value by writing?
- LIKE ??????
- LIKE .{6} Answer 5: LIKE ^.{6}$
- LIKE ...... (that's six dots)
- LIKE ______ (that's six underscore characters)
19. The result of a SELECT statement can contain duplicate rows.
- False
- True
- None of the above