 |
| OCA MySQL5 Certification |
The topics covered include: Theory, Terminology and Concepts Data Definition using SQL Basic Data Manipulation using SQL Advanced Data Manipulation using SQL Transactions Import/Export We give you knowledge information relevant to the exam specifications. To be able to succeed in the real exam, you’ll need to apply your earned knowledge to the question scenarios. This Exam focuses on the more difficult topics that will likely make a difference in exam results.
The 1Z0-870 Questions & Answers covers all the knowledge points of the real exam. We update our product frequently so our students and aspirants can always have the latest version of the questions and answers.
1} Adam works as a Database Administrator for Cashmyiq.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?
2} You work as a Database Administrator for Cashmyiq.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?
3} 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."
4} You work as a Database Administrator for cashmyiq.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?
5} You work as a Database Administrator for cashmyiq.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?
6} You work as a Database Administrator for cashmyiq.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?
7} Which of the following statements is correct for equijoin used to join two tables named Employees and Department?
8} 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?
9} Consider the exhibit given below: Which of the following queries will return the name of the customer who placed the highest amount of orders and the total order amount?
10} You work as a Database Administrator for cashmyiq.com. The company uses MySQL as its database. You have created a table named Employees in the database. You want to create a list of employees working in the organization, but you do not want to display any duplicate row in the report. Which of the following statements will help you to accomplish the task?
11} Adam works as a Database Administrator for cashmyiq.com. The company uses MySQL as its database. Adam has created a table named Employees in the database. He wants to retrieve the information of those employees who have at least one person reporting to them. Which of the following queries will Adam execute to accomplish the task?
12} You work as a Database Administrator for cashmyiq.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?
13} You work as a Database Administrator for Cashmyiq.com. The company uses the MySQL database. You have created a table named Employees. The table contains the following structurE. The company has three departments. A task has been assigned to you to calculate the sum of the average length of employees' last name per department. Which of the following queries will you execute to accomplish the task?
14} Which of the following are true about UPDATE statements? Each correct answer represents a complete solution. Choose all that apply.
15} 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.
16} You work as a Database Administrator for Cashmyiq.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_TYPEFROM 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.
17} Which of the following will be true about a table column if you plan to create an index on that column? Each correct answer represents a complete solution. Choose all that apply.
18} You work as a Database Administrator for Cashmyiq.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.
19} Which of the following statements will delete all the records from the table T1? Each correct answer represents a complete solution. Choose all that apply.
20} You work as a Database Administrator for Cashmyiq.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.
21} Adam works as a Database Administrator for Cashmyiq.com. Adam has created a table named Students. In this table, Adam wants to create a column to store the fees of students. Which of the following data types will Adam use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.
22} Fill in the blank with the appropriate word. The ________data type defines a date that is combined with a time of day along with fractional seconds that is based on a 24-hour clock.
23} Fill in the blank with the appropriate word. A ______specifies that the value of a column (or columns), upon which the index is based, must be unique.
24} A______ provides a concise and flexible means for matching strings of text, such as particular characters, words, or patterns of characters.
25} Drag and drop the correct constraint types to their corresponding specifications
0 comments:
Post a Comment