- 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...[详细]
- 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...[详细]
