adplus-dvertising
frame-decoration

Question

Which of these has special automatic update behavior?

a.

DATE

b.

TIME

c.

TIMESTAMP

d.

YEAR

Posted under MySQL Database

Answer: (c).TIMESTAMP

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Which of these has special automatic update behavior?

Similar Questions

Discover Related MCQs

Q. To disallow zero month or day parts in dates, the option used is _____________

Q. The mode that does not remove trailing spaces when CHAR values are retrieved is _____________

Q. MySQL automatically converts a date or time value to a number if the value is used in a numeric context.

Q. The functions in Perl DBI called?

Q. The variable used as a handle to an open file is ______________

Q. Which variable is a handle to a database object?

Q. Which classes does spatial data types in MySQL correspond to?

Q. Which type can store a collection of objects of any type?

Q. SPATIAL indexes cannot be created on NOT NULL spatial columns.

Q. MySQL does not automatically convert a date or time value to a number if the value is used in a numeric context.

Q. What is the generic handle whose meaning depends on context?

Q. What is the non handle array representing a row of values?

Q. The mode of search is the search string parsed into words and the search looks for rows is ______________

Q. In which mode is the indicator of the presence/absence of a word in search used?

Q. Which operator is used to return value from JSON columns after evaluating the path and unquoting the result?

Q. The right shift operator is _____________

Q. Which operator compares sounds?

Q. What does RTF refer to?

Q. Which function returns an array of row values?

Q. Which function returns a reference to hash of row values?