摘要： 26、Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.) A. Co 阅读全文

摘要： 25、Which three instance situations are possible with the Oracle Database server without multi-tenant?(Choose three.) A. two or more instances on separ 阅读全文

摘要： 24、Evaluate these commands which execute successfully: CREATE SEQUENCE ord_seq INCREMENT BY 1 START WITH 1 MAXVALUE 100000 CYCLE CACHE 5000; CREATE TA 阅读全文

摘要： 23、Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choos 阅读全文

摘要： 22、Choose three Which three are true about dropping columns from a table? A) A column can be removed only if it contains no data. B) A column drop is 阅读全文

摘要： 21、Choose three Examine this description of the PRODUCTS table: Name NULL? TYPE PROD_ID NOT NULL VARCHAR2(6) QUANTITY NUMBER(8,2) PRICE NUMBER(10.2) E 阅读全文

摘要： 20、choose two: Examine the structure of the DEPARTMENTS table Name Null? Type DEPARTMENT NOT NULL NUMBER(4) DEPARTMENT_NAME NOT NULL VARCHAR2(30) MANA 阅读全文

摘要： 19、choose the best answer Evaluate the following SQL statement: ALTER TABLE hr.emp SET UNUSED (mgr_id); Which statement is true regarding the effect o 阅读全文

摘要： 18、Evaluate the following ALTER TABLEstatement: ALTER TABLE orders SET UNUSED (order_date); Which statement is true? A. After executing the ALTER TABL 阅读全文

摘要： 17. Examine the following command: CREATE TABLE ( prod_id number(4), Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3) INVI 阅读全文