Oracle MySQL 5.0, 5.1 and 5.5 Certified Associate Set 1

Adam works as a Database Administrator for Pass4sure.com. 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?

You work as a Database Administrator for Pass4sure.com. 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?

Which of the following terms is described in the statement below?
"It is procedural code that is automatically executed in response to certain events on a particular table or view in a database."

You work as a Database Administrator for Pass4sure.com. The company uses MySQL as its database development platform. You have created a table named Employees in the database. You want to display the
names of the employees whose salary is more than $5000, but you do not want to display any duplicate content. Therefore, you have written the following query:
SELECT emp_id, DISTINCT emp_name WHERE salary > 5000
FROM Employees;
Which of the following statements is true about the above query?

You work as a Database Administrator for Pass4sure.com. The company uses MySQL as the database
platform. You have created a table named Students in the database. The structure of the table is as follows:
Stu_ID NUMBER (3) PRIMARY KEY
Stu_Name VARCHAR2 (25) NOT NULL
Fee NUMBER (8, 2)
Class NUMBER (5);
You have executed the following statement for the table "Students":
SELECT e.Stu_Name, m.Fee
FROM Students e, Students m
WHERE e.Stu_ID = m.stu_ID;
Which of the following join types have you used in the above statement?

You work as a Database Administrator for Pass4sure.com. The company uses MySQL as its database.
You have created a new table named Employees, which keeps all the information of the employees. You want to add a new row to the Employees table. Which of the following statements will you use to accomplish the task?

Which of the following are true about UPDATE statements? Each correct answer represents a complete solution. Choose all that apply.

Which of the following statements is correct for equijoin used to join two tables named Employees and Department?

Which of the following properties of concurrency control refers to the requirement that other operations cannot access or see the data in an intermediate state during the execution of a transaction?

Which of the following are the types of numeric literals that can be used in arithmetic expressions? Each correct answer represents a complete solution. Choose all that apply.