Oracle MySQL 5.0, 5.1 and 5.5 Certified Associate Set 2

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 insert a row in
the table. To accomplish the task, you have written an INSERT statement. Which of the following options will be followed by the input data in the INSERT statement?

Which type of join contains a join condition that uses an equality operator to process the join condition?

You work as a Database Administrator for Pass4sure.com. The company uses MySQL as the database development platform. You have created a database named Employee. Which of the following statements will
prevent you from getting error messages if a database with the given name already exists on the database server?

You work as a Database Administrator for Pass4sure.com. You have created a table named Students in the database. Following are the data contained in this table:
You have written the following query to retrieve records from the Students table:
SELECT Stu_ID, Last_Name, SUM(Fees)
FROM Students
WHERE Fees < 3000
GROUP BY Class
ORDER BY Last_Name;
You get an error on executing the query. Which of the following is the cause of the error?

You work as a Database Designer for RealTech Inc. You have to design the database of a bank.
The database has two tables: Employee and Department.
The Employee table has the following attributes:
l EmpID (PK)
l DeptID (FK)
l Name
l DateOfBirth
l Designation
The Department table has the following attributes:
l DeptID (PK)
l DepartmentName
DeptID is the primary key (PK) of the Department table, whereas, after migration, in the above Employee table, it is the foreign key (FK). What does migration of the DeptID attribute to the child table Employee ensure?

Which of the following properties of the database transaction has been defined in the given statement: "Either all the changes or no changes have been made in the database."

You work as a Database Administrator for Pass4sure.com. You have created a table named Student. You want to create a view named student_view for this table. Which of the following syntaxes will you use to accomplish
the task?

Which of the following are the attributes of a simple view? Each correct answer represents a complete solution. Choose all that apply.

Which of the following statements is true about the UNION operator?

You work as a Database Administrator for Pass4sure.com. The company uses MySQL as its database.
You have created a table named Employee in the Sales database. Under unavoidable circumstances, you have to change the structure of the Employee table. Before changing the structure, you want to copy the data to a
new table. For this, you have created a table named NewEmp with the same structure. Which of the following statements will you use to copy all the data from Employee to NewEmp?