多项选择题
Which three SELECT statements displays 2000 in the format “$2,000.00”?（）
A. SELECT TO CNAR(2000, ‘$#,###.##’) FROM dual;
B. SELECT TO CNAR(2000, ‘$0,000.00’) FROM dual;
C. SELECT TO CNAR(2000, ‘$9,999.00’) FROM dual;
D. SELECT TO CNAR(2000, ‘$9,999.99’) FROM dual;
E. SELECT TO CNAR(2000, ‘$2,000.00’) FROM dual;
F. SELECT TO CNAR(2000, ‘$N,NNN.NN’) FROM dual;
相关考题
-
多项选择题
For which two constraints does the Oracle Server implicitly create a unique index?（）
A. NOT NULL
B. PRIMARY KEY
C. FOREIGN KEY
D. CHECK
E. UNIQUE -
单项选择题
You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table. You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables. How can you accomplish this task?（）
A. ALTER VIEW emp_dept_vu (ADD manager_id NUMBER);
B. MODIFY VIEW emp_dept_vu (ADD manager_id NUMBER);
C. ALTER VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employee e, departments d WHERE e.department_id = d.department_id;
D. MODIFY VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department_id = d.department_id;
E. CREATE OR REPLACE VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department_id = d.department_id;
F. You must remove the existing view first, and then run the CREATE VIEW command with a new column list to modify a view. -
多项选择题
The ORDERS table has these columns: ORDER_ID NUMBER(4) NOT NULL CUSTOMER_ID NUMBER(12) NOT NULL ORDER_TOTAL NUMBER(10,2) The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars? （）
A. SELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;
B. SELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;
C. SELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;
D. SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and <= 2000;
E. SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and order_total <= 2000;
