单选题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?（）Aselect the parenthesis when negative value in the view properties box Bselect the parenthesis when negative value in the column properties box Cuse the @function @negative to set this in the column formula in the view Duse a formula to format the value in the field on the form that will be displaying in the view
单选题
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
参考解析
解析：
暂无解析
相关考题：
In "LoveActually", Harry is not happy with ()when he is doing Christmas shopping with his wife.A、MiaB、the sales clerkC、his employeeD、his child
User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a public synonym, and would like to create a synonym for this view that can be used by all users of the database. Which SQL statement can Mary use to accomplish that task?（）A. CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vuB. CREATE PUBLIC SYNONYM EDL:VU FOR mary (emp_dept_loc_vu);C. CREATE PUBLIC SYNONYM EDL_VU FOR emp _dept_loc_vu;D. CREATE SYNONYM EDL_VU ON emp_dept_loc_vu FOR EACH USER;E. CREATE SYNONYM EDL_VU FOR EACH USER ON emp_dept_loc_vuF. CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu FOR ALL USERS;
资料：HS ensures there is a clear career path for any employee, from any background. Three key levels in Harrods are the sales employee, department managers and senior managers. At each level, employees can benefit from the development programs in order to build a career.James is a sales Associate and one of HS first Sales Degree students. When an injure prevented him from following his previously chosen career in contemporary dance, he applied to HS. He has never looked back. HS training has given him transferable skills. He has been able to work within more than one department, providing the same high levels of experience.Why did James give up his previous career?A.because he wanted to make a change of his life.B.because ge got hurt and could't dance any more.C.because he wanted to take the courses.D.none above.
资料：HS ensures there is a clear career path for any employee, from any background. Three key levels in Harrods are the sales employee, department managers and senior managers. At each level, employees can benefit from the development programs in order to build a career.James is a sales Associate and one of HS first Sales Degree students. When an injure prevented him from following his previously chosen career in contemporary dance, he applied to HS. He has never looked back. HS training has given him transferable skills. He has been able to work within more than one department, providing the same high levels of experience.What are the three key levels in HS?A.the sales employees, department managers and senior managers.B.the sales employees,sales assistants and department managers.C.the senior managers,department managers and sales employees.D.not mentioned.
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
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.
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 boxD、 use the @function @decimal to format the value in the field on the form that will display in the view
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
A customer has reached the cooling limit in his datacenter， but still has room for additional IBM racks and servers. Which allow additinal future sales of the following？（）A、Rear Door HeateXchangerB、ActiveEnery Manager（AEM）C、Perforated doorsD、IBM Cool Blue
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
You are the network administrator for Testking.com. The network consists of a single Active Directory domain named testking.com. The sales department is hiring employees. An OU named TestKingSales is created to hold objects for the new sales department users. Each sales department user has a portable computer. Each portable computer runs Windows XP Professional. The sales department users are responsible for joining their portable computers to the domain. You need to ensure that the computer accounts for the Sales department user's portable computers are created in the TestKingSales OU. You need to achieve this goal without granting any unnecessary permissions. What should you do?（）A、Assign the sales department users the Allow - Read permissions for the Computer container.B、Configure the sales department users' user accounts to be trusted for delegationC、Prestage the computer accounts in the TestKingSales OU for the sales department users' portable computers.D、Assign the sales depertment users the Allow - Create all Child Objects permission for the TestKingSales OU.
You are the administrator of your company’s network. A user named Paul in the service department has a Windows 2000 Professional computer. Paul needs to access the files that are in a shared folder on his computer. A local group named Sales has permissions to access the data. Paul is a member of the Sales local group but he cannot access the file he needs. What should you do？ （）A、Grant Paul NTFS permission so that he can access any parent folder to files in the shared folder.B、Share the Sales folder and grant Paul shared folder permission to access the shared Sales folder.C、Remove Paul from any other group that has been explicitly denied access to the Sales folder. D、Delete the Sales local group and recreate it. Add individual user accounts from the Sales Department back into Sales local group.
单选题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
单选题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 boxD use the @function @decimal to format the value in the field on the form that will display in the view
单选题In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? （）ADBA_USERS BDBA_OBJECTS CDBA_TS_QUOTAS DDBA_TAB_PRIVS
多选题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
单选题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.
单选题You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）A One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.B One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.C One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.D One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.
单选题You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Service in the instance. There is a database user who is named ServiceGreatUser. A SQL Server login named ServiceGreatLogin maps to ServiceGreatUser in the Service database. According to the requirement of the company CIO, the database user can only perform the two tasks below: the database user executes all stored procedures that currently exist in the Sales database and executes all stored procedures that will be created in the Sales database. So what should you do to ensure this? （）AServiceGreatUser should be added to the appropriate fixed database roles. BYou should assign the appropriate object-level permissions to ServiceGreatUser CYou should assign the appropriate server-level permissions to ServiceGreatLogin DYou should assign the appropriate database-level permissions to ServiceGreatUser
多选题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.
单选题You are granted the CREATE VIEW privilege. What does this allow you to do?（）ACreate a table view.BCreate a view in any schema.CCreate a view in your schema.DCreate a sequence view in any schema.ECreate a view that is accessible by everyone.FCreate a view only of it is based on tables that you created.
单选题______ it or not , his discovery has created a stir in scientific circles.ABelieveBTo believeCBelievingDBelieved
多选题Which two statements about creating constraints are true?（）AConstraint names must start with SYS_CBAll constraints must be defines at the column level.CConstraints can be created after the table is created.DConstraints can be created at the same time the table is created.EInformation about constraints is found in the VIEW_CONSTRAINTS dictionary view.
单选题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?（）AUse the DESCRIBE command on the EMP_DEPT_VU view.BUse the DEFINE VIEW command on the EMP_DEPT_VU view.CUse the DESCRIBE VIEW command on the EMP_DEPT_VU view.DQuery the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.EQuery the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.FQuery the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
问答题Practice 13 ● Miss Peters has placed an order with Mr. Frederic. This is the first order his company has ever got from her company. Mr. Frederic decides to keep this new customer and is thinking of increasing his company’s sales to her. ● Suppose you are a secretary of Mr. Frederic, he asks you to write this letter. ● Please write the letter. ● Write 60-80 words.
单选题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？（）AUpdate the view to use an outer join between the Customers and Sales tables.BCreate a clustered index on the v CustomerSales view.CCreate 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.DCreate a stored procedure for the business analysts that uses the v CustomerSales view.