Oracle MySQL 5.0, 5.1 and 5.5 Certified Associate Set 3

If you want to create a simple database view on which other privileged users should not be able to perform DML operations, then which of the following options will you choose? Each correct answer represents a complete solution. Choose all that apply.

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

Which of the following functions may require the use of the GROUP BY clause? Each correct answer represents a complete solution. Choose all that apply.

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 are assigned the task
to create a report that will contain the first name of employees who are working as Marketing Managers for the organization.
The structure of the table is as follows:
Which of the following statements will you use to accomplish the task?

You work as a Database Administrator for Pass4sure.com. You have created a table named Employees and an index named emp_index. You find that the index is not working properly and thus you want to remove it. Which
of the following statements will you use to accomplish the task?

You work as a Database Administrator for Pass4sure.com. You have created a new table named Students. You want to create a foreign key constraint on the student_id in the Students table. Which of the following
statements will you follow to accomplish the task?

Samuel designs a database for a production company. He creates a table as follows:
CREATE TABLE Product
(Product_No number(10)
CONSTRAINT Prod_Product_No_pk PRIMARY KEY,
Product_ID number(10)
CONSTRAINT prod_Product_ID_nk NOT NULL);
For which column of the table will an index be created?

Which of the following conditions is true if you are using the DROP TABLE command to delete a table?

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

You work as a Database Administrator for Pass4sure.com. You have written the following statement:
SELECT 'Student Name:' || Stud_Name
FROM Students
WHERE Stud_ID = 50;
Which of the following will be treated as a number literal in the SELECT statement?