Oracle-MySQL 5 Developer Certified Professional Exam, Part I Set 1

Is the following statement true or false? "Defining a column as TIMESTAMP DEFAULT CURRENT_TIMESTAMP will ensure that when rows are inserted, the current time will always be used."

Is the following a valid CREATE statement?

A column defined as DECIMAL, with no parameters, is equivalent to which of the below?

Which of the following statements will add two columns of INT type to the `country` table?

The query below is attempting to CREATE a table based on the definition of the `world` table, including any column attributes and indexes. What is missing? CREATE TABLE t1 ______ world

Which of the following will CREATE a table with exactly one multi-column index?

You have issued the statement: CREATE TABLE numbers (number INT NOT NULL) ENGINE=MYISAM What is the result of issuing the following statement: INSERT INTO numbers VALUES (NULL)

What is the benefit of creating an index on a table?

On a clean installation of the MySQL server (which contains only the databases test and mysql), you select the test database as the default database. Which of the following CREATE TABLE statements will succeed?

The table exams was created using the following statement: You need to make certain that examinee_id is always defined and unique throughout the table. What changes (if any) should be made to the table?