多項(xiàng)選擇題

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;

你可能感興趣的試題

多項(xiàng)選擇題

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

單項(xiàng)選擇題

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.