- ocp考试
- ocp 11g认证考试051题库解析：第39题
ocp 11g认证考试051题库解析：第39题，完整题库请点击这里联系老师咨询了解。39. Evaluate the following command:CREATE TABLE employees(employee_id NUMBER(2) PRIMARY KEY,last_name VARCHAR2(25) NOT NULL,department_id NUMBER(2)NOT NULL,job_id VARCHAR2(8),salary NUMBER(10,2));You issue t...
- ocp 11g认证考试051题库解析：第38题
ocp 11g认证考试051题库解析：第38题，完整题库请点击这里联系老师咨询了解。38. Which two statements are true regarding views? (Choose two.)A. A simple view in which column aliases have been used cannot be updated.B. Rows cannot be deleted through a view if the view definition conta...
- ocp 11g认证考试051题库解析：第37题
ocp 11g认证考试051题库解析：第37题，完整题库请点击这里联系老师咨询了解。37. You issued the following command to drop the PRODUCTS table:SQL> DROP TABLE products;What is the implication of this command? (Choose all that apply.)A. All data along with the table structure is dele...
- ocp 11g认证考试051题库解析：第36题
ocp 11g认证考试051题库解析：第36题，完整题库请点击这里联系老师咨询了解。36. Examine the following SQL commands:SQL>CREATE TABLE products (prod_id NUMBER(3) CONSTRAINT p_ck CHECK (prod_id > 0),prod_name CHAR(30),prod_qty NUMBER(6),CONSTRAINT p_name NOT NULL,CONSTRAINT prod_...
- ocp 11g认证考试051题库解析：第35题
ocp 11g认证考试051题库解析：第35题，完整题库请点击这里联系老师咨询了解。35. Which two statements are true regarding constraints? (Choose two.)A. A table can have only one primary key and one foreign key.B. A table can have only one primary key but multiple foreign keys.C. Only t...
- ocp 11g认证考试051题库解析：第34题
ocp 11g认证考试051题库解析：第34题，完整题库请点击这里联系老师咨询了解。34. You created an ORDERS table with the following description:name Null TypeORD_ID NOT NULL NUMBER(2)CUST_ID NOT NULL NUMBER(3)ORD_DATE NOT NULL DATEORD_AMOUNT NOT NULL NUMBER (10,2)You inserted some rows i...
- ocp 11g认证考试051题库解析：第33题
ocp 11g认证考试051题库解析：第33题,完整题库请点击这里联系老师咨询了解。33. You want to create an ORD_DETAIL table to store details for an order placed having the followingbusiness requirement:1) The order ID will be unique and cannot have null values.(唯一+非空约束=主键约束)2) T...
- ocp 11g认证考试051题库解析：第32题
ocp 11g认证考试051题库解析：第32题,完整题库请点击这里联系老师咨询了解。32. Which CREATE TABLE statement is valid?A. CREATE TABLE ord_details(ord_no NUMBER(2) PRIMARY KEY,item_no NUMBER(3) PRIMARY KEY,ord_date DATE NOT NULL);B. CREATE TABLE ord_details(ord_no NUMBER(2) UNIQUE, NO...
- ocp 11g认证考试051题库解析：第31题
ocp 11g认证考试051题库解析：第31题，完整题库请点击这里联系老师咨询了解。31. Evaluate the following SQL commands:SQL>CREATE SEQUENCE ord_seqINCREMENT BY 10START WITH 120MAXVALUE 9999NOCYCLE;SQL>CREATE TABLE ord_items(ord_no NUMBER(4)DEFAULT ord_seq.NEXTVAL NOT NULL,item_no ...
- ocp考试051题库解析：第30题
ocp考试051题库解析：第30题，完整题库请点击这里联系老师咨询了解。30. Evaluate the following CREATE TABLE commands:CREATE TABLE orders(ord_no NUMBER(2) CONSTRAINT ord_pk PRIMARY KEY,ord_date DATE,cust_id NUMBER(4));CREATE TABLE ord_items(ord_no NUMBER(2),item_no NUMBER(3),qty NUMB...
- ocp考试051题库解析：第29题
ocp考试051题库解析：第29题，完整题库请点击这里联系老师咨询了解。29. Which two statements are true regarding constraints? (Choose two.)A. A foreign key cannot contain NULL values.B. The column with a UNIQUE constraint can store NULLS .C. A constraint is enforced only for an INSER...
- ocp考试051题库解析：第28题
ocp考试051题库解析：第28题，完整题库请点击这里联系老师咨询了解。28. Which two statements are true regarding constraints? (Choose two.)A. A foreign key cannot contain NULL values.B. A column with the UNIQUE constraint can contain NULL values.C. A constraint is enforced only for t...
- ocp考试051题库解析：第27题
ocp考试051题库解析：第27题，完整题库请点击这里联系老师咨询了解。27. Which two statements are true regarding tables? (Choose two.)A. A table name can be of any length.B. A table can have any number of columns.C. A column that has a DEFAULT value cannot store null values.D. A tabl...
- ocp考试051题库解析：第26题
ocp考试051题库解析：第25题，完整题库请点击这里联系老师咨询了解。26. Which is the valid CREATE TABLE statement?A. CREATE TABLE emp9$# (emp_no NUMBER (4));B. CREATE TABLE 9emp$# (emp_no NUMBER(4));C. CREATE TABLE emp*123 (emp_no NUMBER(4));D. CREATE TABLE emp9$# (emp_no NUMBER(4),...
- ocp考试051题库解析：第25题
ocp考试051题库解析：第25题,完整题库请点击这里联系老师咨询了解。25. You need to create a table with the following column specifications:1. Employee ID (numeric data type) for each employee2. Employee Name (character data type) that stores the employee name3. Hire date, which stor...
- ocp考试051题库解析：第24题
ocp考试051题库解析：第24题，完整题库请点击这里联系老师咨询了解。24. Examine the structure proposed for the TRANSACTIONS table:name Null TypeTRANS_ID NOT NULL NUMBER(6)CUST_NAME NOT NULL VARCHAR2(20)CUST_STATUS NOT NULL VARCHAR2TRANS_DATE NOT NULL DATETRANS_VALIDITY INTERVAL DAY ...
- ocp考试051题库解析：第23题
ocp考试051题库解析：第23题，完整题库请点击这里联系老师咨询了解。23. Examine the structure proposed for the TRANSACTIONS table:name Null TypeTRANS_ID NOT NULL NUMBER(6)CUST_NAME NOT NULL VARCHAR2(20)CUST_STATUS NOT NULL CHARTRANS_DATE NOT NULL DATETRANS_VALIDITY VARCHAR2CUST_CRED...
- ocp考试051题库解析：第22题
ocp考试051题库解析：第22题，完整题库请点击这里联系老师咨询了解。22. You need to create a table for a banking application. One of the columns in the table has the followingrequirements:1) You want a column in the table to store the duration of the credit period.2) The data in the...
- ocp考试051题库解析：第21题
ocp考试051题库解析：第21题，完整题库请点击这里联系老师咨询了解。21. Examine the description of the EMP_DETAILS table given below:name NULL TYPEEMP_ID NOT NULL NUMBEREMP_NAME NOT NULL VARCHAR2 (40)EMP_IMAGE LONGWhich two statements are true regarding SQL statements that can be ex...
- ocp题库解析：11g-1Z0-051-第20题
ocp题库解析：11g-1Z0-051-第20题，完整题库请点击这里联系老师咨询了解。20. Which three statements are true regarding the data types in Oracle Database 10g/11g? (Choosethree.)A. Only one LONG column can be used per table.B. A TIMESTAMP data type column stores only time values with ...
- ocp题库解析：11g-1Z0-051-第19题
ocp题库解析：11g-1Z0-051-第19题，完整题库请点击这里联系老师咨询了解。19. Evaluate the following query:SELECT INTERVAL '300' MONTH,INTERVAL '54-2' YEAR TO MONTH,INTERVAL '11:12:10.1234567' HOUR TO SECONDFROM dual;What is the correct output of the above query?A. +25-00 , +54-02, +...
- ocp题库解析：11g-1Z0-051-第18题
ocp题库解析：11g-1Z0-051-第18题，完整题库请点击这里联系老师咨询了解。18. Examine the structure of the PROMOTIONS table:name Null TypePROMO_ID NOT NULL NUMBER(6)PROMO_NAME NOT NULL VARCHAR2(30)PROMO_CATEGORY NOT NULL VARCHAR2(30)PROMO_COST NOT NULL NUMBER(10,2)The management want...
- ocp题库解析：11g-1Z0-051-第17题
ocp题库解析：11g-1Z0-051-第17题，完整题库请点击这里联系老师咨询了解。17. View the E xhibit and examine the data in the EMPLOYEES table.You want to generate a report showing the total compensation paid to each employee to date.You issue the following query:SQL>SELECT ename ' j...
- ocp题库解析：11g-1Z0-051-第16题
ocp题库解析：11g-1Z0-051-第16题，完整题库请点击这里联系老师咨询了解。16. Evaluate the following query:SQL> SELECT promo_name q'{'s start date was }' promo_begin_dateAS "Promotion Launches"FROM promotions;What would be the outcome of the above query?A. It produces an error bec...
- ocp题库解析：11g-1Z0-051-第15题
ocp题库解析：11g-1Z0-051-第15题，完整题库请点击这里联系老师咨询了解。15. View the Exhibit and examine the data in the CUSTOMERS table.Evaluate the following query:SQL> SELECT cust_name AS "NAME", cust_credit_limit/2 AS MIDPOINT,MIDPOINT+100 AS "MAXLOWER LIMIT"FROM customers;T...
- ocp题库解析：11g-1Z0-051-第14题
ocp题库解析：11g-1Z0-051-第14题，完整题库请点击这里联系老师咨询了解。14. Using the CUSTOMERS table, you need to generate a report that shows 50% of each creditamount in each income level. The report should NOT show any repeated credit amounts in each incomelevel. --each income l...
- ocp题库解析：11g-1Z0-051-第13题
ocp题库解析：11g-1Z0-051-第13题，完整题库请点击这里联系老师咨询了解。13. View the Exhibit and examine the structure of the PRODUCTS table.You need to generate a report in the following format:CATEGORIES5MP Digital Photo Camera's category is PhotoY Box's category is ElectronicsEn...
- ocp题库解析：11g-1Z0-051-第12题
ocp题库解析：11g-1Z0-051-第12题，完整题库请点击这里联系老师咨询了解。12. You need to produce a report where each customer's credit limit has been incremented by $1000. In the output, t he customer's last name should have the heading Name and the incremented credit limit should b...
- ocp题库解析：11g-1Z0-051-第11题
ocp题库解析：11g-1Z0-051-第11题，完整题库请点击这里联系老师咨询了解。11. View the Exhibit and examine the structure of the PRODUCTS table.All products have a list price.You issue the following command to display the total price of each product after a discount of 25% and atax of...
- ocp题库解析：11g-1Z0-051-第10题
ocp题库解析：11g-1Z0-051-第10题，完整题库请点击这里联系老师咨询了解。10. View the Exhibit; e xamine the structure of the PROMOTIONS table.Each promotion has a duration of at least seven days .Your manager has asked you to generate a report, which provides the weekly cost for eac...
