T

Tina Singh • 10.85K Points
Tutor II 

Q. What is the difference between nchar and nvarchar?

  • (A) nchar is fixed and nvarchar is variable.
  • (B) nchar is variable and nvarchar is fixed.
  • (C) nchar has the maximum size of 4000 characters and nvarchar has the maximum size of 8000 characters.
  • (D) nchar has the maximum size of 800 characters and nvarchar has the maximum size of 4000 characters.

Correct answer: Option(A)

MySQL Share
Explanation by: Tina Singh 
nchar is fixed and nvarchar is variable width Unicode string data type.

You must be Logged in to update hint/solution

Previous MCQ Next MCQ

Discusssion

Login to discuss.

Related MCQs on MySQL

Q. Which level of Abstraction describes what data are stored in the Database?

Q. MySQL comes with as standard with client libraries for

Q. Which Operator Returns TRUE if a subquery returns at least one row?

Q. The datatype that stores the longest length of strings is ______________.

Q. Which error occurs while the program is running and cannot be detected by the PL/SQL compiler?

Q. Regardless of whether a database or table name is case sensitive on the system, it must be referred to using the same lettercase throughout a given query.

Q. Which type of database management system is MySQL?

Q. In which language MYSQL is written?

Q. What is the maximum number of triggers that can apply to a single table?

Q. The server is told to accept spaces after function names by

Learn All MySQL MCQs