adplus-dvertising
frame-decoration

Question

Which operator is used to perform integer divisions in MySQL?

a.

/

b.

\

c.

DIV

d.

//

Posted under MySQL Database

Answer: (c).DIV

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Which operator is used to perform integer divisions in MySQL?

Similar Questions

Discover Related MCQs

Q. The NULL value also means ___________

Q. What does comparing a known value with NULL result into?

Q. Which clause is used to sort query elements?

Q. MySQL client runs on the machine containing the databases and servers connect to the client over a network.

Q. Which of the following options tells mysql to ask for entering the password?

Q. The query ‘SELECT NOW()’ shows the current _____________

Q. Suppose you want to select a database named ‘sampledb’ as the default database. Which of the following commands do you use?

Q. To see the table structure, which of the following SQL commands is issued?

Q. SHOW DATABASES lists the databases in the server to which you are connected.

Q. The command to move the cursor to the beginning of line in MySQL input editor is?

Q. What does Control-_ do in MySQL input editor?

Q. On UNIX, statements entered in ‘MySQL’ are saved in which file?

Q. MySQL can be used to execute script files.

Q. Suppose run_me.sh is a script file. Which command is used to make it executable?

Q. To execute the contents of a query file ‘exec.sql’ by feeding it to mysql, which command is used?

Q. Which option prints output in table-format when MySQL is run interactively?

Q. The clause that enables mapping a short command to a long command is __________

Q. The connection parameters for setting up MySQL can be stored in an option file to save typing the names every time a connection is established.

Q. In UNIX, the name of the option file is __________

Q. Which statement upgrades the database directory name encoding?