R

Ritu Singhal • 4.36K Points
Extraordinary 

Q. Which among the following is the correct representation of "float(1,1)"?

  • (A) Total of 1 digit
  • (B) Total of 2 digit
  • (C) Total of 2 digit, one digit at right of the decimal, one digit at left of the decimal
  • (D) None of the mentioned
  • Correct Answer - Option(C)
  • Views: 8
  • Filed under category MySQL
Explanation by: Ritu Singhal 
In MySQL, the syntax "float(1,1)" represents a floating-point number with a total of 2 digits.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs on MySQL

Q. The argument to the function mysql_error() is . . . . . . . .

Q. Is the following statement is true/false? "An expression can be NULL, but can never equal to NULL"

Q. A view can be deleted using the command . . . . . . . .

Q. The default scheduling property of MySQL is implemented by how many of these? MyISAM, MERGE, MEMORY

Q. Which of the following is an illegal unquoted identifier name?

Q. The storage engine in MySQL that provides foreign key support is . . . . . . . .

Q. Find the error in the following SQL statement? CREATE TABLE person ( person_id SMALLINT, name VARCHAR, LAST VARCHAR CONSTRAINTS pk_person PRIMARY KEY (person_id)); INSERT INTO person VALUES( person_id, name, LAST) (1, ’s’, ’p’); INSERT INTO person ( person_id, name, LAST) VALUES(1,’s’,’p’);

Q. The number of options that can be used to control LOCAL capability at runtime is . . . . . . . .

Q. In order to add a new column to an existing table in SQL, we can use the command

Q. Which mode is a shorthand for ‘both strict modes plus a bunch of other restrictions’?

Learn All MySQL MCQs

Question analytics