Quiz 1z0-870

Quiz 1z0-870, MySQL 5 Certified Associate

Which of the following constraints of an existing table is automatically copied to the new table that is created by using the existing table?

"The NUMBER datatype is used to store both fixed-point and floating-point numbers."

Which of the following data types is a binary-string type?

"Database applications provide certain integrity constraints that must hold for the data."

Which of the following options is an approximate-value data type?

It is automatically added after the last column of the table."

What is the maximum number of columns that can be defined in a table?

Which of the following datatypes is not a character datatype?

What is the datatype of the variable when you use the DEFINE variable command?

They cannot be created after the table has been created."