1Z0-870 - MySQL 5.0, 5.1 and 5.5 Certified Associate Exam

Go back to Oracle

Example Questions

Which of the following functions is used to determine whether a value is odd or even? Which of the following functions allows a user to convert values to a specific data type or to assign a character set to a value? 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 and you perform the UPDATE operation to update the rows of all employees whose salary is greater than$5,000. Due to some unavoidable circumstances, you have to undo the last transaction. Which of the following commands should you use to accomplish the task? Which of the following is the correct syntax for the DESCRIBE command? You work as a Database Administrator for Pass4sure.com. You have created a table named Students in a database. You want to add a PRIMARY KEY constraint to the Student_ID column of the Students table. Which of the following statements will you use to accomplish the task? All of the following statements are true about a unique index except for which one? You work as a Database Administrator for Pass4sure.com. The company uses MySQL as its database. You have written two statements, which are as follows: 1. SELECT DISTINCT OBJECT_TYPE FROM USER_OBJECTS; 2. SELECT OBJECT_TYPE FROM ALL_OBJECTS; Which of the following options explains the difference between the results of these two statements? Each correct answer represents a complete solution. Choose all that apply. Which group functions can be used for any data type? You work as a Database Administrator for Pass4sure.com. The company uses MySQL as its database. You want to use group functions, so you have decided to put an alias of group functions as 'GP'. Which of the following are the correct ways to use group functions? Each correct answer represents a complete solution. Choose all that apply. Identify whether the given statement is true or false. "A self join is performed by using different table aliases for the same table." Which of the following SQL functions may require the use of a GROUP BY clause in a SELECT statement? Each correct answer represents a complete solution. Choose all that apply. Which of the following statements are true about a table name? Each correct answer represents a complete solution. Choose all that apply. Which of the following comprises a unit of work performed within a database management system? For which of the following database objects can you create a synonym? Each correct answer represents a complete solution. Choose all that apply. Inner join is also known as ________ join. Fill in the blank with the appropriate word. An ______________________ is a data structure that improves the performance of queries issued against a table. For which of the following data types must a column be indexed if the AUTO_INCREMENT attribute is specified? 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. Which of the following are the attributes of a simple view? 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 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? Which of the following constraints is also known as the referential integrity constraint? Identify whether the given statement is true or false. "The number and datatypes of values specified in the VALUES clause of an INSERT statement must match the number and datatypes of corresponding columns specified in the INTO clause." Which of the following is referred to as a logical unit of work where related DML statements are grouped together? Which of the following conditions is true if you are using the DROP TABLE command to delete a table? You work as a Database Administrator for Pass4sure.com. The company uses the MySQL database. You have created a new table named Employees in the database and performed update operation but you got an error because of the last transaction. Now, you want to terminate the last transaction. Which of the following commands can you use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply. What is the default precision for fractional seconds in a TIMESTAMP datatype column? Which of the following options executes when BEGIN TRANS operator is called? Identify whether the given statement is true or false. "Database applications provide certain integrity constraints that must hold for the data." Which of the following SQL statements can be used on a view that is created with the WITH READ ONLY option? Identify whether the given statement is true or false. "When adding a new column to a table, the position of the column cannot be specified. It is automatically added after the last column of the table." You work as a Database Administrator for Pass4sure.com. The company uses MySQL as its database. The database contains a table named Employees. You want to remove an index named Emp_name_idx from the Employees table. Which of the following statements should you use to accomplish the task? You work as a Database Administrator for Pass4sure.com. You have created a new table named Employee. Now, you want to create a view employee_view for this table. The view will contain the emp_id, emp_name, emp_desig, salary, and emp_dept of those employees whose salary is greater than $25000. You do not want to make changes to the column values through the view. Which of the following syntaxes will you use to accomplish the task? Which of the following group functions CANNOT be used to store numeric data? Which of the following expressions is used in conjunction with various values and is replaced with a derived result value? 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? Mark works as a Database Administrator for Neon Inc. He issues the following query to insert rows in a table named Emp: SELECT * FROM Emp SET AUTOCOMMIT=0 INSERT INTO Emp VALUES('XXX','John',04/02/1977) INSERT INTO Emp VALUES('YYY','Richard',03/01/1977) ROLLBACK How many rows will be inserted in the Emp table after the ROLLBACK statement has been issued? Which of the following clauses is used to limit the rows that will be updated by specifying a condition the row must meet? Which of the following statements is used to delete a specific row of data? What kind of join automatically joins two or more tables based on common column names? You work as a Database Administrator for Realtech Inc. A database has a table named Product. The auto commit mode of the database is turned off. You want to perform an update on the Product table. Which of the following queries will permanently save the changed value of ProductID in the table? 1. UPDATE Product SET COST=49.90 WHERE ProductID='121' 2. UPDATE Product SET COST=49.90 WHERE ProductID='121' COMMIT 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. Which of the following data types can be used in MySQL? 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 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 of the following statements can be used to select a database to make it the default database for a given connection to a server? Identify whether the given statement is true or false. "The GROUP BY clause must use column names, as column aliases cannot be used in it." Aggregate functions are also known as _________ functions. Fill in the blank with the appropriate word. _________are important for database integrity, because they mean that the database can be restored to a clean copy even after erroneous operations are performed. Which of the following operators is used to check if field values are included in a specified commadelimited list? Which of the following statements returns the result that has values matching with the specified values? Which of the following constraints is used to ensure that all values in a column satisfy certain criteria?

Study Guides