单选题tommy has created a sales view in his sales.nsf database. Tommy wants negative numbers in the sales number column in the view parenthesis. which one of the following should tommy do?（）A select the parenthesis when negative value in the view properties

题目内容(请给出正确答案)

单选题

tommy has created a sales view in his sales.nsf database. Tommy wants negative numbers in the sales number column in the view parenthesis. which one of the following should tommy do?（）

select the parenthesis when negative value in the view properties box

select the parenthesis when negative value in the column properties box

use the @function @negative to set this in the column formula in the view

use a formula to format the value in the field on the form that will be displaying in the view

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

单选题You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view? （）A Use the DESCRIBE command in the EMP_DEPT VU view.B Use the DEFINE VIEW command on the EMP_DEPT VU view.C Use the DESCRIBE VIEW command on the EMP_DEPT VU view.D Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.E Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.F Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

点击查看答案
第2题

多选题Which two statements about views are true?（）AA view can be created as read only.BA view can be created as a join on two or more tables.CA view cannot have an ORDER BY clause in the SELECT statement.DA view cannot be created with a GROUP BY clause in the SELECT statement.EA view must have aliases defined for the column names in the SELECT statement.

点击查看答案
第3题

单选题tommy has created a sales view in his sales.nsf database. Tommy wants negative numbers in the sales number column in the view parenthesis. which one of the following should tommy do?（）A select the parenthesis when negative value in the view properties box B select the parenthesis when negative value in the column properties box C use the @function @negative to set this in the column formula in the view D use a formula to format the value in the field on the form that will be displaying in the view

点击查看答案
第4题

单选题You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was created.) How do you obtain the definition of the view?（）A Use the DESCRIBE command on the EMP_DEPT_VU view.B Use the DEFINE VIEW command on the EMP_DEPT_VU view.C Use the DESCRIBE VIEW command on the EMP_DEPT_VU view.D Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.E Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.F Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

点击查看答案
第5题

多选题Which two statements are true regarding views?（）AA subquery that defines a view cannot include the GROUP BY clauseBA view that is created with the subquery having the DISTINCT keyword can be updatedCA view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updatedDA data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table

点击查看答案
第6题

单选题Derek has created a view in the products.nsf database. Derek wants the markup column in the view to display the selling price of the cost. He wants this value to display in currency. Which one of the following should derekl do? （）Ause the @currenty in thr column formula in the view BSelect currency on the numbers tab in the view properties box CSelect currency on the numbers tab in the column properties box DSelect currency on the numbers tab in the field properties box

点击查看答案
第7题

单选题Examine the structure if the EMPLOYEES table: Column name Data Type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) NOT NULL SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You need to create a view called EMP_VU that allows the user to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the user to insert rows?（）A CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, department_id FROM employees WHERE mgr_id IN (102, 120);B CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id department_id FROM employees WHERE mgr_id IN (102, 120);C CREATE VIEW emp_Vu AS SELECT department_id, SUM(sal) TOTALSAL FROM employees WHERE mgr_id IN (102, 120) GROUP BY department_ id;D CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id, DISTINCT department_id FROM employees;

点击查看答案

单选题tommy has created a sales view in his sales.nsf database. Tommy wants negative numbers in the sales number column in the view parenthesis. which one of the following should tommy do?（）A select the parenthesis when negative value in the view properties

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容