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?（）

相似题目

• 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&e

  查看最佳答案

• A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3, col4 FROM t1 WHERE col4 > 1000 WITH CHECK OPTIONWhat is the effect of the CHECK OPTION clause?（）

  A . Any row inserted or updated through view V1 must meet the condition that col4 > 1000. B . From now on, any row inserted or updated in table T1 must meet the condition that col4 > 1000, but existing rows in the table are not checked. C . At view creation, DB2 will check the data in table T1, and if in any row doesn't meet the condition col4 > 1000, the view creation will be rejected. D . Any row inserted or updated through view V1 must meet the condition that col4 > 1000 and no row in table T1 can be updated such that col4 <= 1000, but new rows in the table can be inserted with col4 <= 1000.

  查看最佳答案

• ou are developing an ASP.NET MVC 2 application. You create a view that will be returned by action methods in multiple controllers. You need to place the view in the appropriate folder. To which subfolder within the Views folder should you add the view？（）

  A . Master B . Default C . Shared D . Commo

  查看最佳答案

• 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 created B . Each time the REFRESH VIEW v1 statement is executed C . Each time an SQL statement is executed against view V1 D . Only the first time an SQL statement is executed against view V1

  查看最佳答案

• A new LPAR has been created that needs SAN attached disk for a database. After AIX has been installed, the fibre cables are attached to the adapters. How should the administrator configure the disks?（）

  A . Run 'mkdev' to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run 'cfgmgr' to discover and configure the disks. B . Run 'mkpath' to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run 'cfgmgr' to discover and configure the disks. C . Run 'chpath' to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run 'cfgmgr' to discover and configure the disks. D . Run 'cfgmgr' to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run 'cfgmgr' to discover and configure the disks.

  查看最佳答案

• You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU? （）

  A . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department _ id IN (10,20); B . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY; C . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION; D . CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WITH department_id IN (10,20); E . CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE

  查看最佳答案

• You and a co-worker have established wireless communication directly between your wireless laptops. What type of wireless topology has been created?（）

  A . BSS B . ESS C . IBSS D . SSID

  查看最佳答案

• View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D： \oracle\product\10.2.0\oradata\oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）

  A . The tablespace has two data files. B . An error is reported and tablespace creation fails. C . Data files are created with names generated by the instance. D . The tablespace can be extended without specifying the data file. E . Data files belonging to the USERS tablespace cannot be renamed.

  查看最佳答案

• You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU?（）

  A . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20); B . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY; C . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION; D . CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20); E . CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE

  查看最佳答案

• You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application.  You need to ensure that users can view content in a book-reading format that displays two pages at a time.  Which control should you use?（）

  A . FlowDocument B . FlowDocumentReader C . FlowDocumentPageViewer D . FlowDocumentScrollViewer

  查看最佳答案

• In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? （）

  A . DBA_USERS  B . DBA_OBJECTS  C . DBA_TS_QUOTAS  D . DBA_TAB_PRIVS&e

  查看最佳答案

• You have an Exchange Server 2010 organization.You need to ensure that all users in the organization can view the availability of a company projector.What should you create for the projector？（）

  A . a distribution group B . a mailbox C . a mail-enabled contact D . a sharing policy

  查看最佳答案

• Krstin has created a page in the videos application .which one of the following statements about pages is not true ?（）

  A . pages are design elements B . Pages can be full-text indexed  C . pages  can be referenced by outlines or frames   D . pages  can include text,graphics ,applets,and link

  查看最佳答案

• 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 user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）

  A . REFERENCES B . SELECT C . UPDATE D . ALTER

  查看最佳答案

• A new LPAR has been created that needs SAN attached disk for a database. After AIX has been installed， the fibre cables are attached to the adapters. How should the administrator configure the disks？（）

  A . Run ’mkdev’ to force the FC adapter to log into the SAN， have the SAN LUNs zoned to the server， run ’cfgmgr’ to discover and configure the disks. B . Run ’mkpath’ to force the FC adapter to log into the SAN， have the SAN LUNs zoned to the server， run ’cfgmgr’ to discover and configure the disks. C . Run ’chpath’ to force the FC adapter to log into the SAN， have the SAN LUNs zoned to the server， run ’cfgmgr’ to discover and configure the disks. D . Run ’cfgmgr’ to force the FC adapter to log into the SAN， have the SAN LUNs zoned to the server， run ’cfgmgr’ to discover and configure the disks.

  查看最佳答案

• A System p administrator has created a customized security profile using AIX Security Expert.  Which of the following commands will apply this to a system（）

  A . aixpert -f mysec.xml B . aixpert -a mysec.xml C . chsec -f mysec.xml D . chsec -a mysec.xml

  查看最佳答案

• A library called contosobuisness.dll has been created and u need to accept it in a page.. all options had the 

  A . <%assembly TargetName="contosobuisness" %> B . <%assembly ID="contosobuisness" %>  C . <%@ Assembly Name="contosobuisness" %> D . <%assembly virtualpath="contosobuisness" %&gt

  查看最佳答案

• You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results? （）

  A . CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK; B . CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK; C . GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***

  查看最佳答案

• SQL中创建视图应使用CREATE VIEW语句。

  查看最佳答案

• 如果要创建视图，使用的命令是create view

  查看最佳答案

• __________ it or not，his discovery has created a stir in scientific circles．

  A.Believe B.To believe C.Believing D.Believed

  查看最佳答案

• Once your answer has been verified, you will be prompted to_____your account number and create a new PIN.

  A．place B．offer C．impose D．enter

  查看最佳答案

• A new LPAR has been created that needs SAN attached disk for a database. After AIX has been installed, the fibre cables are attached to the adapters.How should the administrator configure the disks？（）

  A.Run ‘mkdev‘ to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run ‘cfgmgr‘ to discover and configure the disks. B.Run ‘mkpath‘ to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run ‘cfgmgr‘ to discover and configure the disks. C.Run ‘chpath‘ to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run ‘cfgmgr‘ to discover and configure the disks. D.Run ‘cfgmgr‘ to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run ‘cfgmgr‘ to discover and configure the disks.

  查看最佳答案