- 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...[详细]
- OCP试题解析：11g-1Z0-051-v9.02-030题OCP试题解析：11g-1Z0-051-v9.02-030题，完整题库请点击这里联系老师咨询了解。30. Evaluate the following CREATE TABLE commands:CREATE TABLE orders(ord_no NUMBER(2) CONSTRAINT ord_pk PRIMARY KEY,ord_d...[详细]
- OCP题库解析：11g-1Z0-051-v9.02-029题OCP题库解析：11g-1Z0-051-v9.02-029题，完整题库请点击这里联系老师咨询了解。29. Which two statements are true regarding constraints? (Choose two.)A. A foreign key cannot contain NULL values.B. The ...[详细]
- OCP题库解析：11g-1Z0-051-v9.02-028题OCP题库解析：11g-1Z0-051-v9.02-028题，完整题库请点击这里联系老师咨询了解。28. Which two statements are true regarding constraints? (Choose two.)A. A foreign key cannot contain NULL values.B. A co...[详细]
- OCP题库解析：11g-1Z0-051-v9.02-027题OCP题库解析：11g-1Z0-051-v9.02-027题，完整题库请点击这里联系老师咨询了解。27. Which two statements are true regarding tables? (Choose two.)A. A table name can be of any length.B. A table can have...[详细]
- OCP试题解析：11g-1Z0-051-v9.02-026题OCP试题解析：11g-1Z0-051-v9.02-026题，完整题库请点击这里联系老师咨询了解。26. Which is the valid CREATE TABLE statement?A. CREATE TABLE emp9$# (emp_no NUMBER (4));B. CREATE TABLE 9emp$# (emp_no N...[详细]
