Sun Certified MySQL Associate

1.Adam works as a Database Administrator for a company. He creates a table named Students. He wants
to create a new table named Class with the help of the Students table. Which of the
following syntaxes will Adam use to accomplish the task?
A. CREATE TABLE Class
INSERT INTO SELECT * FROM Students;
B. CREATE TABLE Class
FROM SELECT * FROM Students;
C. CREATE TABLE Class
(SELECT * FROM Students);
D. CREATE TABLE Class
AS SELECT * FROM Students;
Answer: D

2.You work as a Database Administrator for a company. The company uses MySQL as its database.
You have created two tables named Employees and Departments in the database. Now, you want
to display data from both tables. Which of the following actions will you perform to accomplish the task?
A. Join
B. Table Merge operator
C. HAVING
D. GROUP BY
Answer: A

I suggested her to take the SUN 310-814 exam with the words my student said to me. After a long time talking, she agreed, do you know how happy I was! About 2 days later, my student decided to attend a training class, so I made up my mind to prepare all the things for my daughter. But when I came to tell her that she should to attend the class at night to study the materials, she argued with me! A surprise turned out to be a suffering for me! 310-814 Sun Certified MySQL Associate