cnblogs_5359

摘要： Choose two. Examine this partial command: CREATE TABLE cust ( cust_id NUMBER(2), credit_ limit NUMBER(10) ) ORGANIZATION EXTERNAL Which two clauses ar 阅读全文

摘要： Choone three Examine the description of the PRODUCTS table: Name Null? Type PRODUCT_ID NOT NULL NUMBER(2) PRODUCT_NANE VARCHAR2(10) UNIT_PRICE NUMBER( 阅读全文

摘要： Choose two. Examine this SQL statement: UPDATE orders o SET customer_name = (SELECT cust_last_name FROM customers WHERE customer_id=o.customer_id); Wh 阅读全文

摘要： Choose the best answer. Examine this query: SELECT TRUNC (ROUND(156.00,-2),-1) FROM DUAL; What is the result? A) 16 B) 160 C) 150 D) 200 E) 100 Answer 阅读全文

摘要： Choone two Which three statements are true about dropping and unused columns in an Oracle database? A) A primary key column referenced by another colu 阅读全文

摘要： Choose two. Which two statements are true about a self join? A) The join key column must have an index. B) It can be a left outer join. C) It must be 阅读全文

摘要： Choose two Which two statements are true about Oracle synonyms? A) A synonym can have a synonym. B) All private synonym names must be unique in the da 阅读全文

摘要： Choose three Which three statements are true about views in an Orade batabase? A) A SELECT statement cannot contain a where clause when querying a vie 阅读全文

摘要： Choose the best answer The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE You want to display the date of 阅读全文

摘要： Choose three Which three are true about granting object privileges on tables, views, and sequences? A) UPDATE can be granted only on tables and views. 阅读全文