- 最新OCP考试题库:11g-1Z0-051-第5题最新OCP考试题库:11g-1Z0-051-第5题,完整题库请点击这里联系老师咨询了解5、Which four are types of functions available in SQL? (Choose 4)A. stringB. characterC. integerD. calendarE. numericF. trans...[详细]
- 最新OCP考试题库:1Z0-051-第4题最新OCP考试题库:1Z0-051-第4题,完整题库请点击这里联系老师咨询了解11、Which statement correctly describes SQL and /SQL*Plus?A. Both SQL and /SQL*plus allow manipulation of values in the database....[详细]
- 最新OCP考试题库:1Z0-051-第3题最新OCP考试题库:1Z0-051-第3题,完整题库请点击这里联系老师咨询了解3、Evaluate these two SQL statements:SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC;SELECT last_name, sa...[详细]
- 最新OCP考试题库:1Z0-051-第2题最新OCP考试题库:1Z0-051-第2题,完整题库请点击这里联系老师咨询了解2、You need to design a student registration database that contains several tables storing academic information.The STUDENTS tab...[详细]
- 最新OCP考试题库:1Z0-051-第1题最新OCP考试题库:1Z0-051-第1题,完整题库请点击这里联系老师咨询了解1、Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? (Choose three.)A. It releases the...[详细]
- OCP认证051考试题库:11g-v9.02-第175题OCP认证051考试题库:11g-v9.02-第175题,完整题库请点击这里联系老师咨询了解175. Which two statements are true regarding savepoints? (Choose two.)A. Savepoints are effective only for COMMIT.B. Savep...[详细]
- OCP认证051考试题库:11g-v9.02-第174题OCP认证051考试题库:11g-v9.02-第174题,完整题库请点击这里联系老师咨询了解174. Which statement is true regarding transactions? (Choose all that apply.)A. A transaction can consist only of a set o...[详细]
- OCP认证051考试题库:11g-v9.02-第173题OCP认证051考试题库:11g-v9.02-第173题,完整题库请点击这里联系老师咨询了解173. When does a transaction complete? (Choose all that apply.)A. when a DELETE statement is executedB. when a ROLLBACK co...[详细]
- OCP认证051考试题库:11g-v9.02-第172题OCP认证051考试题库:11g-v9.02-第172题,完整题库请点击这里联系老师咨询了解172. The SQL statements executed in a user session are as follows:SQL> CREATE TABLE product(pcode NUMBER(2),pname VARCH...[详细]
- OCP认证051考试题库:11g-v9.02-第171题OCP认证051考试题库:11g-v9.02-第171题,完整题库请点击这里联系老师咨询了解171. Which three statements/commands would cause a transaction to end? (Choose three.)A. COMMITB. SELECTC. CREATED. ROLLB...[详细]
- OCP认证051考试题库:11g-v9.02-第170题OCP认证051考试题库:11g-v9.02-第170题,完整题库请点击这里联系老师咨询了解170. Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)A. DELETE can be used to remo...[详细]