- ocp考试
- ocp题库怎么背：11g-051-V9.02-第189题
ocp题库怎么背：11g-051-V9.02-第189题，完整题库请点击这里联系老师咨询了解189.Which two are true about aggregate functions? (Choose two.)A. You can use aggregate functions in any clause of a SELECT statement.B. You can use aggregate functions only in the column list of the select ...
- ocp题库怎么背：11g-051-V9.02-第188题
ocp题库怎么背：11g-051-V9.02-第188题，完整题库请点击这里联系老师咨询了解188.Which are /SQL*Plus commands? (Choose all that apply.)A. INSERTB. UPDATEC. SELECTD. DESCRIBEE. DELETEF. RENAMEAnswer: DExplanation:Describe is a valid iSQL*Plus/ SQL*Plus command.INSERT, UPDATE & DEL...
- ocp题库怎么背：11g-051-V9.02-第187题
ocp题库怎么背：11g-051-V9.02-第187题，完整题库请点击这里联系老师咨询了解187.Examine the statement:Create synonym emp for hr.employees;What happens when you issue the statement?A. An error is generated.B. You will have two identical tables in the HR schema with different names.C....
- ocp题库怎么背：11g-051-V9.02-第186题
ocp题库怎么背：11g-051-V9.02-第186题，完整题库请点击这里联系老师咨询了解186.Evaluate this SQL statement:SELECT e.emp_name, d.dept_name FROM employees e JOIN departments dUSING (department_id) WHERE d.department_id NOT IN (10,40) ORDER BY dept_name;The statement fails when execut...
- ocp题库怎么背：11g-051-V9.02-第185题
ocp题库怎么背：11g-051-V9.02-第185题，完整题库请点击这里联系老师咨询了解185.Examine the structure of the EMPLOYEES table:You want to create a SQL script file that contains an INSERT statement. When the script is run,the INSERT statement should insert a row with the specified val...
- ocp题库怎么背：11g-051-V9.02-第184题
ocp题库怎么背：11g-051-V9.02-第184题，完整题库请点击这里联系老师咨询了解184.Examine the structure of the STUDENTS table:You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.Which SQL s...
- ocp题库怎么背：11g-051-V9.02-第183题
ocp题库怎么背：11g-051-V9.02-第183题，完整题库请点击这里联系老师咨询了解183.The COMMISSION column shows the monthly commission earned by the employee.ExhibitWhich two tasks would require sub queries or joins in order to be performed in a single step? (Choose two.)A. listing the ...
- ocp题库怎么背：11g-051-V9.02-第182题
ocp题库怎么背：11g-051-V9.02-第182题，完整题库请点击这里联系老师咨询了解182.Which view should a user query to display the columns associated with the constraints on a tableowned by the user?A. USER_CONSTRAINTSB. USER_OBJECTSC. ALL_CONSTRAINTSD. USER_CONS_COLUMNSE. USER_COLUMNSAn...
- ocp题库怎么背：11g-051-V9.02-第181题
ocp题库怎么背：11g-051-V9.02-第181题，完整题库请点击这里联系老师咨询了解181.Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:Which MERGE statement is valid?A.MERGE INTO new_employees c USING employees e ON (c.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE S...
- ocp题库怎么背：11g-051-V9.02-第180题
ocp题库怎么背：11g-051-V9.02-第180题，完整题库请点击这里联系老师咨询了解180.Which four are types of functions available in SQL? (Choose 4)A. stringB. characterC. integerD. calendarE. numericF. translationG. dateH. conversionAnswer: B,E,G,H试题解析：Explanation: Explanation: SQL ...
- ocp题库怎么背：11g-051-V9.02-第179题
ocp题库怎么背：11g-051-V9.02-第179题，完整题库请点击这里联系老师咨询了解179.Which statement correctly describes SQL and /SQL*Plus?A. Both SQL and /SQL*plus allow manipulation of values in the database.B. /SQL*Plus recognizes SQL statements and sends them to the server; SQL is th...
- ocp题库怎么背：11g-051-V9.02-第178题
ocp题库怎么背：11g-051-V9.02-第178题，完整题库请点击这里联系老师咨询了解3.Evaluate these two SQL statements:SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC;SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC;What is true about them?A. The t...
- ocp题库怎么背：11g-051-V9.02-第177题
ocp题库怎么背：11g-051-V9.02-第177题，完整题库请点击这里联系老师咨询了解177.You need to design a student registration database that contains several tables storing academic information.The STUDENTS table stores information about a student. The STUDENT_GRADES table stores informa...
- ocp题库怎么背：11g-051-V9.02-第176题
ocp题库怎么背：11g-051-V9.02-第176题，完整题库请点击这里联系老师咨询了解176、Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? (Choose three.)A. It releases the storage space used by the table.B. It does not release the storage space us...
- ocp题库怎么背：11g-051-V9.02-第175题
ocp题库怎么背：11g-051-V9.02-第175题，完整题库请点击这里联系老师咨询了解175. Which two statements are true regarding savepoints? (Choose two.)A. Savepoints are effective only for COMMIT.B. Savepoints may be used to ROLLBACK.C. Savepoints can be used for only DML statements.D. Sa...
- ocp题库怎么背：11g-051-V9.02-第174题
ocp题库怎么背：11g-051-V9.02-第174题，完整题库请点击这里联系老师咨询了解174. Which statement is true regarding transactions? (Choose all that apply.)A. A transaction can consist only of a set of DML and DDL statements.B. A p art or an entire transaction can be undone by using RO...
- ocp题库怎么背：11g-051-V9.02-第173题
ocp题库怎么背：11g-051-V9.02-第173题，完整题库请点击这里联系老师咨询了解173. When does a transaction complete? (Choose all that apply.)A. when a DELETE statement is executedB. when a ROLLBACK command is executedC. when a PL/SQL anonymous block is executedD. when a data definitio...
- ocp题库怎么背：11g-051-V9.02-第172题
ocp题库怎么背：11g-051-V9.02-第172题，完整题库请点击这里联系老师咨询了解172. The SQL statements executed in a user session are as follows:SQL> CREATE TABLE product(pcode NUMBER(2),pname VARCHAR2(10));SQL> INSERT INTO product VALUES (1, 'pen');SQL> INSERT INTO product VA...
- ocp题库怎么背：11g-051-V9.02-第171题
ocp题库怎么背：11g-051-V9.02-第171题，完整题库请点击这里联系老师咨询了解171. Which three statements/commands would cause a transaction to end? (Choose three.)A. COMMITB. SELECTC. CREATED. ROLLBACKE. SAVEPOINTAnswer: ACD试题解析：事务处理在遇到第一条DML 语句时开始，在发生以下事件...
- ocp题库怎么背：11g-051-V9.02-第170题
ocp题库怎么背：11g-051-V9.02-第170题，完整题库请点击这里联系老师咨询了解170. Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)A. DELETE can be used to remove only rows from only one table at a time.B. DELETE can be used to remove only rows f...
- ocp题库怎么背：11g-051-V9.02-第169题
ocp题库怎么背：11g-051-V9.02-第169题，完整题库请点击这里联系老师咨询了解169. View the Exhibit and examine the description for the PRODUCTS and SALES table.PROD_ID is a primary key in the PRODUCTS table and foreign key in the SALES table. You want toremove all the rows from the P...
- ocp题库怎么背：11g-051-V9.02-第168题
ocp题库怎么背：11g-051-V9.02-第168题，完整题库请点击这里联系老师咨询了解168. View the Exhibit and examine the description of SALES and PROMOTIONS tables.You want to delete rows from the SALES table, where the PROMO_NAME column in the PROMOTIONStable has either blowout sale or ev...
- ocp题库怎么背：11g-051-V9.02-第167题
ocp题库怎么背：11g-051-V9.02-第167题，完整题库请点击这里联系老师咨询了解167. Evaluate the following DELETE statement:DELETE FROM sales;There are no other uncommitted transactions on the SALES table.Which statement is true about the DELETE statement?A. It would not remove the row...
- ocp题库怎么背：11g-051-V9.02-第166题
ocp题库怎么背：11g-051-V9.02-第166题，完整题库请点击这里联系老师咨询了解166. View the Exhibit and examine the structures of the EMPLOYEES and DEPARTMENTS tables.You want to update the EMPLOYEES table as follows:4 ? 4;-Update only those employees who work in Boston or Seattle (lo...
- ocp题库怎么背：11g-051-V9.02-第165题
ocp题库怎么背：11g-051-V9.02-第165题，完整题库请点击这里联系老师咨询了解165. View the Exhibit and examine the description for the CUSTOMERS table.You want to update the CUST_INCOME_LEVEL and CUST_CREDIT_LIMIT columns for the customerwith the CUST_ID 2360. You want the value for ...
- ocp题库怎么背：11g-051-V9.02-第164题
ocp题库怎么背：11g-051-V9.02-第164题，完整题库请点击这里联系老师咨询了解164. View the Exhibit and examine the structure of CUSTOMERS and SALES tables.Evaluate the following SQL statement:UPDATE (SELECT prod_id, cust_id, quantity_sold, time_idFROM sales)SET time_id = '22-MAR-2007...
- ocp题库怎么背：11g-051-V9.02-第163题
ocp题库怎么背：11g-051-V9.02-第163题，完整题库请点击这里联系老师咨询了解163. View the Exhibit and examine the description for the CUSTOMERS table.You want to update the CUST_CREDIT_LIMIT column to NULL for all the customers, whereCUST_INCOME_LEVEL has NULL in the CUSTOMERS table...
- ocp题库怎么背：11g-051-V9.02-第162题
ocp题库怎么背：11g-051-V9.02-第162题，完整题库请点击这里联系老师咨询了解162. View the Exhibit and examine the structure of the PRODUCTS, SALES, and SALE_SUMMARYtables.SALE_VW is a view created using the following command :SQL>CREATE VIEW sale_vw ASSELECT prod_id, SUM(quantity...
- ocp题库怎么背：11g-051-V9.02-第161题
ocp题库怎么背：11g-051-V9.02-第161题，完整题库请点击这里联系老师咨询了解161. View the exhibit and examine the description for the SALES and CHANNELS tables.You issued the following SQL statement to insert a row in the SALES table:INSERT INTO sales VALUES(23, 2300, SYSDATE, (SELE...
- ocp题库解析：1Z0-051-V9.02-第160题
ocp题库解析：1Z0-051-V9.02-第160题，完整题库请点击这里联系老师咨询了解160. View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables.There is only one customer with the cust_last_name column having value Roberts. Which INSERTstatement should be used to add a row ...
