单选题Which version of a view would you use if you just want a quick， easy view within your XPage？（）A Data Table ControlB View ControlC Repeat ControlD Filter by category View Control

题目
单选题
Which version of a view would you use if you just want a quick， easy view within your XPage？（）
A

Data Table Control

B

View Control

C

Repeat Control

D

Filter by category View Control

相似考题

1.You are granted the CREATE VIEW privilege. What does this allow you to do? ()A. Create a table view.B. Create a view in any schema.C. Create a view in your schema.D. Create a sequence view in any schema.E. Create a view that is accessible by everyone.F. Create a view only of it is based on tables that you created.

2.Which version of a view would you use if you just want a quick， easy view within your XPage？（）A、Data Table ControlB、View ControlC、Repeat ControlD、Filter by category View Control

3.You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）A、MERGEB、SELECT …CROSS JOINC、INSERT ALL …SELECTD、CREATE VIEW …CONSTRAINT

4. 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.

更多“单选题Which version of a view would you use if you just want a quick， easy view within your XPage？（）A Data Table ControlB View ControlC Repeat ControlD Filter by category View Control”相关问题

  • 第1题：

    In which scenario do you use the Flashback Database feature？（）

    • A、 when a table is dropped and you restore it from the Recycle Bin
    • B、 when a user’s schema is dropped and you recover the user’s schema
    • C、 when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
    • D、 when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration

    正确答案:B

  • 第2题：

    You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）

    • A、 To recover a dropped table.
    • B、 To recover a dropped schema.
    • C、 To recover data from a truncated table.
    • D、 To view changes made by all the transactions during a given period of time.
    • E、 To view changes made by a single transaction during a given period of time.

    正确答案:D,E

  • 第3题：

    You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）

    • A、 Query the V$FLASHBACK_DATABASE_LOG view.
    • B、 Query the V$FLASHBACK_DATABASE_STAT view.
    • C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
    • D、 Query the V$RECOVERY_FILE_DEST view.

    正确答案:B

  • 第4题：

    Your company uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce your companys security policy of abstracting data.  Some of these views perform slowly. You create indexes on those views to increase performance, while still maintaining the companys security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE（　） function. This view does not allow you to create an index. You need to create an index on the view.  Which two actions should you perform?（）

    • A、 Remove all deterministic function calls from within the view. 
    • B、 Remove all nondeterministic function calls from within the view. 
    • C、 Schema-bind all functions that are called from within the view. 
    • D、 Create the view and specify the WITH CHECK OPTION clause.

    正确答案:B,C

  • 第5题：

    You need to ensure the Order Control team is able to track the number of orders that reach the production department. What should you do?（）

    • A、Create a new Time dimension based on the Holiday table. Use derived columns for the month and the year.
    • B、Create a Server Time dimension. Within this dimension， enable the time periods year， month， and date. Select the Additional Manufacturing calendar option.
    • C、Create a new Time dimension based on the date values within the ProductOrderStatus table. Flag those days on which no orders were received as Holiday.
    • D、Create a new Time dimension based on a data source view named query. Derive the data for this data source view from unique dates within the ProductOrderStatus table. Use a subquery to identify the holidays and derived columns for the month and the year.

    正确答案: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题：

    单选题
    You have a login.ascx control and to display it in a view which method u would use（）
    A

    http.display

    B

    http.partial

    C

    http.load

    D

    http.get


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

  • 第8题：

    单选题
    You design a Business Intelligence （BI） solution by using SQL Server 2008. You design a SQL Server 2008 Analysis Services （SSAS） solution. Customer data is stored in the tables named CustomerDetails and CustomerContact. The solution uses the following two data sources from two different servers： ·Contoso that accesses the CustomerDetails table ·ContosoCRM that accesses the CustomerContact table You plan to create a dimension named DimCustomer to analyze customer data. You need to ensure that the DimCustomer dimension represents the tables as a snowflake schema to include attributes from the two tables. What should you do？（）
    A

     Create a data source view named DsvContoso that is associated with the two data sources and add the tables to the data source view.

    B

     Create a data source view named DsvContoso that is associated with the two data sources and create a named query in the data source view to merge the tables.

    C

     Create a data source view named DsvCustomer that is associated with the Contoso data source and add the CustomerDetails table to the data source view.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and add the CustomerContact table to the data source view.

    D

     Create a data source view named DsvCustomer that is associated with the Contoso data source and create a named query in the data source view to select data from the CustomerDetails table.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and create a named query in the data source view to select data from the CustomerContact table.


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

  • 第9题：

    单选题
    Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?（）
    A

    DROP emp_dept_uv;

    B

    DELETE emp_dept_uv;

    C

    REMOVE emp_dept_uv;

    D

    DROP VIEW emp_dept_uv;

    E

    DELETE VIEW emp_dept_uv;

    F

    REMOVE VIEW emp_dept_uv;


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

  • 第10题：

    单选题
    You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this？（）
    A

    enable index monitoring and query the DBA_OBJECTS view

    B

    enable index monitoring and query the DBA_INDEXES view

    C

    enable index monitoring and query the V$OBJECT_USAGE view

    D

    enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view


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

  • 第11题：

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

    Common


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

  • 第12题：

    单选题
    You are granted the CREATE VIEW privilege. What does this allow you to do?（）
    A

    Create a table view.

    B

    Create a view in any schema.

    C

    Create a view in your schema.

    D

    Create a sequence view in any schema.

    E

    Create a view that is accessible by everyone.

    F

    Create a view only of it is based on tables that you created.


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

  • 第13题：

    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

  • 第14题：

    You are granted the CREATE VIEW privilege. What does this allow you to do?（）

    • A、Create a table view.
    • B、Create a view in any schema.
    • C、Create a view in your schema.
    • D、Create a sequence view in any schema.
    • E、Create a view that is accessible by everyone.
    • F、Create a view only of it is based on tables that you created.

    正确答案:C

  • 第15题：

    Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?（）

    • A、DROP emp_dept_uv;
    • B、DELETE emp_dept_uv;
    • C、REMOVE emp_dept_uv;
    • D、DROP VIEW emp_dept_uv;
    • E、DELETE VIEW emp_dept_uv;
    • F、REMOVE VIEW emp_dept_uv;

    正确答案:D

  • 第16题：

    You have a login.ascx control and to display it in a view which method u would use（）

    • A、http.display
    • B、http.partial
    • C、http.load
    • D、http.get

    正确答案:B

  • 第17题：

    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、Common

    正确答案:C

  • 第18题：

    单选题
    In which scenario do you use the Flashback Database feature？（）
    A

     when a table is dropped and you restore it from the Recycle Bin

    B

     when a user’s schema is dropped and you recover the user’s schema

    C

     when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp

    D

     when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration


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

  • 第19题：

    单选题
    You need to ensure the Order Control team is able to track the number of orders that reach the production department. What should you do?（）
    A

    Create a new Time dimension based on the Holiday table. Use derived columns for the month and the year.

    B

    Create a Server Time dimension. Within this dimension， enable the time periods year， month， and date. Select the Additional Manufacturing calendar option.

    C

    Create a new Time dimension based on the date values within the ProductOrderStatus table. Flag those days on which no orders were received as Holiday.

    D

    Create a new Time dimension based on a data source view named query. Derive the data for this data source view from unique dates within the ProductOrderStatus table. Use a subquery to identify the holidays and derived columns for the month and the year.


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

  • 第20题：

    单选题
    You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）
    A

    MERGE

    B

    SELECT …CROSS JOIN

    C

    INSERT ALL …SELECT

    D

    CREATE VIEW …CONSTRAINT


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

  • 第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题：

    单选题
    Which version of a view would you use if you just want a quick， easy view within your XPage？（）
    A

    Data Table Control

    B

    View Control

    C

    Repeat Control

    D

    Filter by category View Control


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

  • 第23题：

    单选题
    You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）
    A

     Query the V$FLASHBACK_DATABASE_LOG view.

    B

     Query the V$FLASHBACK_DATABASE_STAT view.

    C

     Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.

    D

     Query the V$RECOVERY_FILE_DEST view.


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

  • 第24题：

    多选题
    You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）
    A

    To recover a dropped table.

    B

    To recover a dropped schema.

    C

    To recover data from a truncated table.

    D

    To view changes made by all the transactions during a given period of time.

    E

    To view changes made by a single transaction during a given period of time.


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

相关内容