V

Vinay • 28.75K Points
Instructor II 

Q. Which data type is more suitable for storing "documents" in Mysql?

  • (A) Varchar
  • (B) mysqlcopydb
  • (C) Mediumtext
  • (D) Either Varchar or Longtext
  • Correct Answer - Option(B)
  • Views: 28
  • Filed under category MySQL
Explanation by: Vinay 
This question is about how to store big chunks of information, like entire documents, in a MySQL database. Let's look at the options:

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs on MySQL

Q. Which of the following is not a feature of MySQL?

Q. The number of binary string types among the following is . . . . . . . . BINARY, VARBINARY, BLOB, CHAR

Q. How is the output from PHP generated?

Q. A binary string is not associated with a character set.

Q. The library file that contains various portability macros and definitions is

Q. Usage of aggregates in WHERE clause is allowed.

Q. A stored procedure is invoked using the statement . . . . . . . .

Q. “NO_DATA_FOUND” and “TOO_MANY_ROWS” are the two most common errors found when executing a SELECT statement.

Q. The slave stores the CHANGE MASTER parameters in the file . . . . . . . .

Q. What is the durability property of transactions?

Learn All MySQL MCQs

Question analytics