单选题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?（）
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

相似考题

1.A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 > 1000 ; When will DB2 access the data from table T1 for view V1?()A.When view V1 is createdB.Each time the REFRESH VIEW v1 statement is executedC.Each time an SQL statement is executed against view V1D.Only the first time an SQL statement is executed against view V1

2.jayne has asked her domino server administrator to enable doc locking on the server. which one of the following must she do to enable it for her application?（）A、 enable the “allow doc locking “ db property B、 create a view column for the locked doc view icon C、 add a profile doc to the db to manage the locked doc D、 enable doc locking at the view level for each view in the db

3.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? （）A、 use the @currenty in thr column formula in the view  B、 Select currency on the numbers tab in the view properties box C、 Select currency on the numbers tab in the column properties box D、 Select currency on the numbers tab in the field properties box 

4. 请翻译下段英文。 Jay：How many machine tools are there in your factory？ Tommy：Ten. Jay：What kind of machine tools are they？ Tommy：There are four lathes，three milling machines，two shapers and one drilling machine. Jay：How many workers are there in your workshop？ Tommy：There are nine. Jay：Are they all turners？ Tommy：No，seven of them are turners and two locksmiths. Jay：So no one can operate the milling machine. Tommy：No. Six of them are turners can operate it. Jay：Is there any woman？ Tommy：There are eight women. Five are workers. Others are managers.

参考答案和解析
正确答案： B
解析： 暂无解析
更多“单选题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题：

     Derek has created a view in the sales.nsf db. Derek wants the sales value column in the view to be punctuated to display two decimal places . which one of the following should he do?（）

    • A、 use the @function @decimal in the column formula in the view 
    • B、 select decimal on the numbers tab in the view properties box 
    • C、 select decimal on the numbers tab in the column properties box
    • D、 use the @function @decimal to format the value in the field on the form that will display in the view 

    正确答案:C

  • 第2题：

    请翻译下方英语段落。 Jay：Is this a bench？ Tommy：Yes，it is. Jay：What’s that？ Tommy：That is a vice. Tommy：This is a file and that is a workpiece？ Jay：Oh，I see. Jay：How many workers are there in your workshop？ Tommy：There are nine. Jay：Are they all turners？ Tommy：No，seven of them are turners and two locksmiths. Jay：So no one can operate the milling machine. Tommy：No. Six of the turners can operate it. Jay：Is there any woman？ Tommy：There are eight women. Five are workers. Others are managers.


    正确答案: Jay：这是个钳工台吗？
    Tommy：是的，这是个钳工台。
    Jay：那是什么呢？
    Tommy：那是个虎钳。
    Tommy：这是个锉刀，而那是个工件。
    Jay：哦，我明白了。
    Jay：你们车间有多少位工人？
    Tommy：有9位工人。
    Jay：他们都是车工吗？
    Tommy：不，他们之中有7位车工和2位钳工。
    Jay：那么，没有1位会开铣床吗？
    Tommy：不，车工中有6位会开铣床。
    Jay：有多少位女职工？
    Tommy：有8位女职工。5位是工人，其他的是管理人员。

  • 第3题：

    tony would like to make it easier for users of the video application to enter new doc using the “video form”, he’d like users to be able to create new “video” doc form within the view. Which one of the following should tony so to build this interface?（）

    • A、create a view action that has the following formula：@command（[create]；”video”）
    • B、create a form action that has the following formula：@command（[compose]；”video”）
    • C、create a view action that has the following formula：@command（[compose]；”video”）
    • D、create a database action that has the following formula：@command（[compose]；”video”）

    正确答案:C

  • 第4题：

    Which two statements are true regarding views?（）

    • A、A subquery that defines a view cannot include the GROUP BY clause 
    • B、A view that is created with the subquery having the DISTINCT keyword can be updated 
    • C、A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated 
    • D、A 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

    正确答案:C,D

  • 第5题：

    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.

    正确答案:D

  • 第6题：

    单选题
    You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）
    A

    Update the view to use an outer join between the Customers and Sales tables.

    B

    Create a clustered index on the v CustomerSales view.

    C

    Create two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.

    D

    Create a stored procedure for the business analysts that uses the v CustomerSales view.


    正确答案： B
    解析： 暂无解析

  • 第7题：

    多选题
    If 4 more than twice n is a negative number and 6 more than n is a positive number, which of the following numbers could be the value of n? (Select all such numbers.)
    A

    -5

    B

    4

    C

    -3


    正确答案： B,A
    解析：
    根据题目中的已知条件可得，4+2n<0，6+n>0，把各个选项分别代入两个不等式中检验，同时符合两个不等式可得到n可以等于-5，-4，-3，故正确答案为AC。

  • 第8题：

    单选题
    jayne has asked her domino server administrator to enable doc locking on the server. which one of the following must she do to enable it for her application?（）
    A

     enable the “allow doc locking “ db property 

    B

     create a view column for the locked doc view icon 

    C

     add a profile doc to the db to manage the locked doc 

    D

     enable doc locking at the view level for each view in the db


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    tony would like to make it easier for users of the video application to enter new doc using the “video form”, he’d like users to be able to create new “video” doc form within the view. Which one of the following should tony so to build this interface?（）
    A

    create a view action that has the following formula：@command（[create]；”video”）

    B

    create a form action that has the following formula：@command（[compose]；”video”）

    C

    create a view action that has the following formula：@command（[compose]；”video”）

    D

    create a database action that has the following formula：@command（[compose]；”video”）


    正确答案： A
    解析： 暂无解析

  • 第10题：

    多选题
    Which two statements about views are true?（）
    A

    A view can be created as read only.

    B

    A view can be created as a join on two or more tables.

    C

    A view cannot have an ORDER BY clause in the SELECT statement.

    D

    A view cannot be created with a GROUP BY clause in the SELECT statement.

    E

    A view must have aliases defined for the column names in the SELECT statement.


    正确答案： D,E
    解析： 暂无解析

  • 第11题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    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? （）
    A

     use the @currenty in thr column formula in the view  

    B

     Select currency on the numbers tab in the view properties box 

    C

     Select currency on the numbers tab in the column properties box 

    D

     Select currency on the numbers tab in the field properties box 


    正确答案： D
    解析： 暂无解析

  • 第13题：

    You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）

    • A、Update the view to use an outer join between the Customers and Sales tables.
    • B、Create a clustered index on the v CustomerSales view.
    • C、Create two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.
    • D、Create a stored procedure for the business analysts that uses the v CustomerSales view.

    正确答案:B

  • 第14题：

    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

    正确答案:B

  • 第15题：

    Which of the following abilities does a view NOT provide？（）

    • A、Change which columns show
    • B、Open a view from another database
    • C、Contain custom controls
    • D、Identify a column to act as a link

    正确答案:C

  • 第16题：

    Which two statements about views are true?（）

    • A、A view can be created as read only.
    • B、A view can be created as a join on two or more tables.
    • C、A view cannot have an ORDER BY clause in the SELECT statement.
    • D、A view cannot be created with a GROUP BY clause in the SELECT statement.
    • E、A view must have aliases defined for the column names in the SELECT statement.

    正确答案:A,B

  • 第17题：

    You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee. Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee. You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report. What should you do？（）

    • A、 Use a subreport.
    • B、 Use a bookmark link.
    • C、 Use the drilldown functionality.
    • D、 Use a drillthrough report link.

    正确答案:D

  • 第18题：

    单选题
    Derek has created a view in the sales.nsf db. Derek wants the sales value column in the view to be punctuated to display two decimal places . which one of the following should he do?（）
    A

     use the @function @decimal in the column formula in the view 

    B

     select decimal on the numbers tab in the view properties box 

    C

     select decimal on the numbers tab in the column properties box

    D

     use the @function @decimal to format the value in the field on the form that will display in the view 


    正确答案： C
    解析： 暂无解析

  • 第19题：

    单选题
    Which of the following abilities does a view NOT provide？（）
    A

    Change which columns show

    B

    Open a view from another database

    C

    Contain custom controls

    D

    Identify a column to act as a link


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    The ADMIN_EMP table has columns EMPNO， ENAME， DEPTNO， and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema.  What action is required for the dependent objects when you perform online redefinition on the table？（）
    A

     The materialized view should have a complete refresh performed after the online table redefinition is completed.

    B

     The materialized view should have a fast refresh performed after the online table redefinition is completed.

    C

     The materialized view，materialized log，and the index should be dropped and re-created after the online table redefinition is complete.

    D

     The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

  • 第23题：

    多选题
    Which two statements are true regarding views?（）
    A

    A subquery that defines a view cannot include the GROUP BY clause

    B

    A view that is created with the subquery having the DISTINCT keyword can be updated

    C

    A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated

    D

    A 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


    正确答案： D,B
    解析： 暂无解析

  • 第24题：

    单选题
    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;


    正确答案： A
    解析： 暂无解析

相关内容