MySQL Questions and Answers

Practice Mode
Showing 10 of 36 questions
Q11
To remove duplicate rows from the result set of a SELECT use the following keyword:
  • A NO DUPLICATE
  • B UNIQUE
  • C DISTINCT
  • D None of the above
Answer: Option C
Q12
 Which of the following can add a row to a table?
  • A Add
  • B Insert
  • C Update
  • D Alter
Answer: Option B
Q13
To use MySQL on your computer, you'll need?
  • A FTP and Telnet
  • B Some sort of client program to access the databases
  • C A Browser
  • D Perl, PHP or Java
Answer: Option B
Q14
Which SQL statement is used to insert a new data in a database?
  • A INSERT INTO
  • B UPDATE
  • C ADD
  • D INSERT NEW
Answer: Option A
Q15
In a LIKE clause, you can could ask for any value ending in "qpt" by writing
  • A LIKE %qpt
  • B LIKE *ton
  • C LIKE ton$
  • D LIKE ^.*ton$
Answer: Option A
Q16
A NULL value is treated as a blank or 0.
  • A True
  • B Fasle
  • C None of the above
Answer: Option B
Q17
MySQL is
  • A A Programming language
  • B A Programming language
  • C A technique for writing reliable programs
  • D A Relational Database Management System
Answer: Option D
Q18
In a LIKE clause, you can ask for any 6 letter value by writing?
  • A LIKE ??????
  • B LIKE .{6} Answer 5: LIKE ^.{6}$
  • C LIKE ...... (that's six dots)
  • D LIKE ______ (that's six underscore characters)
Answer: Option D
Q19
The result of a SELECT statement can contain duplicate rows.
  • A False
  • B True
  • C None of the above
Answer: Option B
Q20
Which function used to get the current time in mysql?
  • A getTime()
  • B Time()
  • C NOW()
Answer: Option C

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test