当前位置: 网站首页 >
OCP认证
- OCP 11g试题解析：1Z0-051-041题OCP 11g试题解析：1Z0-051-041题，完整题库请点击这里联系老师咨询了解。41. Which two statements are true regarding views? (Choose two.)A. A subquery that defines a view cannot include the GROUP BY c...[详细]
- OCP 11g试题解析：1Z0-051-040题OCP 11g试题解析：1Z0-051-040题，完整题库请点击这里联系老师咨询了解。40. View the Exhibit to examine the description for the SALES and PRODUCTS tables.You want to create a SALE_PROD view by execu...[详细]
- OCP 11g试题解析：1Z0-051-039题OCP 11g试题解析：1Z0-051-039题，完整题库请点击这里联系老师咨询了解。39. Evaluate the following command:CREATE TABLE employees(employee_id NUMBER(2) PRIMARY KEY,last_name VARCHAR2(25) NOT NULL,dep...[详细]
- OCP试题解析：11g-1Z0-051-v9.02-038题OCP试题解析：11g-1Z0-051-v9.02-038题，完整题库请点击这里联系老师咨询了解。38. Which two statements are true regarding views? (Choose two.)A. A simple view in which column aliases have been used c...[详细]
- OCP试题解析：11g-1Z0-051-v9.02-037题OCP试题解析：11g-1Z0-051-v9.02-036题，完整题库请点击这里联系老师咨询了解。37. You issued the following command to drop the PRODUCTS table:SQL> DROP TABLE products;What is the implication of th...[详细]
- OCP试题解析：11g-1Z0-051-v9.02-036题OCP试题解析：11g-1Z0-051-v9.02-036题，完整题库请点击这里联系老师咨询了解。36. Examine the following SQL commands:SQL>CREATE TABLE products (prod_id NUMBER(3) CONSTRAINT p_ck CHECK (prod_id >...[详细]
- OCP试题解析：11g-1Z0-051-v9.02-035题OCP试题解析：11g-1Z0-051-v9.02-035题，完整题库请点击这里联系老师咨询了解。35. Which two statements are true regarding constraints? (Choose two.)A. A table can have only one primary key and one fo...[详细]
- OCP试题解析：11g-1Z0-051-v9.02-034题OCP试题解析：11g-1Z0-051-v9.02-034题，完整题库请点击这里联系老师咨询了解。34. You created an ORDERS table with the following description:name Null TypeORD_ID NOT NULL NUMBER(2)CUST_ID NOT NULL NU...[详细]
- OCP试题解析：11g-1Z0-051-v9.02-033题OCP试题解析：11g-1Z0-051-v9.02-033题,完整题库请点击这里联系老师咨询了解。33. You want to create an ORD_DETAIL table to store details for an order placed having the followingbusiness requirement:...[详细]
- OCP试题解析：11g-1Z0-051-v9.02-032题OCP试题解析：11g-1Z0-051-v9.02-032题,完整题库请点击这里联系老师咨询了解。32. Which CREATE TABLE statement is valid?A. CREATE TABLE ord_details(ord_no NUMBER(2) PRIMARY KEY,item_no NUMBER(3) PRIMA...[详细]
- OCP试题解析：11g-1Z0-051-v9.02-031题OCP试题解析：11g-1Z0-051-v9.02-031题，完整题库请点击这里联系老师咨询了解。31. Evaluate the following SQL commands:SQL>CREATE SEQUENCE ord_seqINCREMENT BY 10START WITH 120MAXVALUE 9999NOCYCLE;S...[详细]
