- OCP 11g试题解析:1Z0-051-047题OCP 11g试题解析:1Z0-051-047题,完整题库请点击这里联系老师咨询了解。47. View the Exhibit and examine the structure of ORD and ORD_ITEMS tables.The ORD_NO column is PRIMARY KEY in the ORD table a...[详细]
- OCP 11g试题解析:1Z0-051-046题OCP 11g试题解析:1Z0-051-046题,完整题库请点击这里联系老师咨询了解。46. Which statements are correct regarding indexes? (Choose all that apply.)A. When a table is dropped, the corresponding inde...[详细]
- OCP 11g试题解析:1Z0-051-045题OCP 11g试题解析:1Z0-051-045题,完整题库请点击这里联系老师咨询了解。45. Which two statements are true about sequences created in a single instance database? (Choosetwo.)A. The numbers generated ...[详细]
- OCP 11g试题解析:1Z0-051-044题OCP 11g试题解析:1Z0-051-044题,完整题库请点击这里联系老师咨询了解。44. View the Exhibit and examine the structure of the ORD table.Evaluate the following SQL statements that are executed in a us...[详细]
- OCP 11g试题解析:1Z0-051-043题OCP 11g试题解析:1Z0-051-043题,完整题库请点击这里联系老师咨询了解。43. Evaluate the following CREATE SEQUENCE statement:CREATE SEQUENCE seq1START WITH 100INCREMENT BY 10MAXVALUE 200CYCLENOCACHE;...[详细]
- OCP 11g试题解析:1Z0-051-042题OCP 11g试题解析:1Z0-051-042题,完整题库请点击这里联系老师咨询了解。42. Which three statements are true regarding views? (Choose three.)A. Views can be created only from tables.B. Views can be cr...[详细]
- 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...[详细]