10 2019 档案
摘要：Choose two The PRODUCT_INFORMATION table has a UNIT_PRICE column of data type NUMBER(8, 2). Evaluate this SQL statement: SELECT TO_CHAR(unit_price,'$9
阅读全文
posted @ 2019-10-30 13:05
cnblogs_5359
摘要：Choose two The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOTCE_DATE column of data type DATE NLS_DATE_FORMAT is set to DD-MON-R
阅读全文
posted @ 2019-10-30 11:22
cnblogs_5359
摘要：Choose two Which two statements are true about the WHERE and HAVING clouses in a SELECT statement? A) The WHERE clause can be used to exclude rows aft
阅读全文
posted @ 2019-10-28 16:57
cnblogs_5359
摘要：choose two Examine this business rule: Each studert can work on mutiple projects and eath project can have multiple students You must desion an Entity
阅读全文
posted @ 2019-10-28 16:20
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
阅读全文
posted @ 2019-10-25 15:00
cnblogs_5359
摘要：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(
阅读全文
posted @ 2019-10-25 14:14
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-10-23 15:35
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-10-23 14:48
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-10-21 11:40
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-10-21 10:25
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-10-18 14:51
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-10-18 09:36
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-10-17 11:49
cnblogs_5359
摘要：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.
阅读全文
posted @ 2019-10-17 09:52
cnblogs_5359
摘要：choose three Which three statements are true about indexes and their administration in an Orade database? A) An INVISIBLE index is not maintained when
阅读全文
posted @ 2019-10-16 10:03
cnblogs_5359
摘要：choose the best answer The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2. The table has two rows whose COST_LAST_MANE values are A
阅读全文
posted @ 2019-10-16 09:28
cnblogs_5359
摘要：choose two Exammine the desciption of the PRODUCT DETALS table: NAME NULL TYPE PRODUCT_ID NOT NULL NUMBER(2) PRODUCT_NAME NOT NULL VARCHAR2(25) PRODUC
阅读全文
posted @ 2019-10-15 10:03
cnblogs_5359
摘要：choose two The CUSTOMERS table has a CUST_CREDT_LIMIT column of date type number. Which two queries execute successtully? A) SELECT TO_CHAR(NVL(cust_c
阅读全文
posted @ 2019-10-15 09:33
cnblogs_5359
摘要：choose three Which three are true about the CREATE TABLE command? A) It can include the CREATE...INDEX statement for creating an index to enforce the
阅读全文
posted @ 2019-10-14 11:25
cnblogs_5359
摘要：Choose the best answer. Exanine the desciption of the EMPLOYEES table: Nane Null Type EMP_ID NOT NUL NUMBER EMP_NAME VARCHAR2 (40) DEPT_ID NUMBER(2) S
阅读全文
posted @ 2019-10-14 10:24
cnblogs_5359
