itgle.com

单选题Which of the following abilities does a view NOT provide？（）A Change which columns showB Open a view from another databaseC Contain custom controlsD Identify a column to act as a link

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

相似考题

1.Which of the following is not among the basic features of a relational database?A．It does not matter what order the rows are in.B．It does not matter what order the columns are in.C．Different columns should have different column names.D．Different columns should have different data types.

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.Which best describes an inline view? ()A. a schema objectB. a subquery that can contain an ORDER BY clauseC. another name for a view that contains group functionsD. a subquery that is part of the FROM clause of another query

更多“单选题Which of the following abilities does a view NOT provide？（）A Change which columns showB Open a view from another databaseC Contain custom controlsD Identify a column to act as a link”相关问题

  • 第1题：

    Which of the following commands should be used to view and change the network filesystem tuning parameters available on the system？（）

    • A、 no
    • B、 nfso
    • C、 vmtune
    • D、 exportfs

    正确答案:B

  • 第2题：

    A technician needs to check which ports are open in the Windows Firewall. Which of the following willallow the technician to view these settings?（）

    • A、netsh firewall show logging
    • B、ipconfig /all
    • C、netsh firewall show state
    • D、arp -a

    正确答案:C

  • 第3题：

    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

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

    When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）  

    • A、 The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET
    • B、 The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET
    • C、 The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management
    • D、 The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management

    正确答案:A

  • 第6题：

    TestKing.com uses SQL Server 2005. A user reports that an order processing application stopped responding in the middle of an order transaction. The users SQL Server session ID is 54. You need to find out if session 54 is blocked by another connection. If it is,you need to identify the blocking session ID. What are two possible ways to achieve this goal？（）

    • A、In SQL Server Management Studio， open the Activity Monitor. Open the Process Info page. View the blockedBy column for session 54.
    • B、In SQL Server Management Studio，open the Activity Monitor. Open the Locks by Process page. View the Request Mode column for session 54.
    • C、In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec requests WHERE session id = 54View the blocking session id column.
    • D、In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec sessionsWHERE session id = 54View the status column.

    正确答案:A,C

  • 第7题：

    Which of the following options is not available from the Store menu in WebSphere Commerce Accelerator？（）

    • A、Open/Close
    • B、Change Profile
    • C、Change Flow
    • D、Change Name
    • E、Change Tax

    正确答案:D

  • 第8题：

    单选题
    Which best describes an inline view?（）
    A

    a schema object

    B

    a subquery that can contain an ORDER BY clause

    C

    another name for a view that contains group functions

    D

    a subquery that is part of the FROM clause of another query


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

  • 第9题：

    多选题
    TestKing.com uses SQL Server 2005. A user reports that an order processing application stopped responding in the middle of an order transaction. The users SQL Server session ID is 54. You need to find out if session 54 is blocked by another connection. If it is,you need to identify the blocking session ID. What are two possible ways to achieve this goal？（）
    A

    In SQL Server Management Studio， open the Activity Monitor. Open the Process Info page. View the blockedBy column for session 54.

    B

    In SQL Server Management Studio，open the Activity Monitor. Open the Locks by Process page. View the Request Mode column for session 54.

    C

    In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec requests WHERE session id = 54View the blocking session id column.

    D

    In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec sessionsWHERE session id = 54View the status column.


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

  • 第10题：

    单选题
    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
    解析： 暂无解析

  • 第11题：

    多选题
    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
    解析： 暂无解析

  • 第12题：

    单选题
    Which of the following dynamic view would you query to identify the online CURRENT redo log group？（）
    A

    V$LOG

    B

    V$LOFHIST

    C

    V$LOGFILE

    D

    V$LOG_HISTORY


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

  • 第13题：

     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

  • 第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 Designer view would a coder first check for an XPage that will not save？（）

    • A、Applications
    • B、Problems
    • C、Controls
    • D、Event

    正确答案:B

  • 第16题：

    Which best describes an inline view?（）

    • A、a schema object
    • B、a subquery that can contain an ORDER BY clause
    • C、another name for a view that contains group functions
    • D、a subquery that is part of the FROM clause of another query

    正确答案:D

  • 第17题：

    Which of the following dynamic view would you query to identify the online CURRENT redo log group？（）

    • A、V$LOG
    • B、V$LOFHIST
    • C、V$LOGFILE
    • D、V$LOG_HISTORY

    正确答案:A

  • 第18题：

    which one of the following best describes the use of hidden column formula?（）

    • A、views can be hidden based on a formula 
    • B、hidden columns are not a supported feature 
    • C、table columns can be hidden based on a formula  
    • D、view columns can be displayed or hidden based on a formula 

    正确答案:D

  • 第19题：

    单选题
    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
    解析： 暂无解析

  • 第20题：

    单选题
    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
    解析： 暂无解析

  • 第21题：

    单选题
    A technician needs to check which ports are open in the Windows Firewall. Which of the following willallow the technician to view these settings?（）
    A

    netsh firewall show logging

    B

    ipconfig /all

    C

    netsh firewall show state

    D

    arp -a


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

  • 第22题：

    单选题
    When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）
    A

     The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET

    B

     The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET

    C

     The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management

    D

     The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management


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

  • 第23题：

    单选题
    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
    解析： 暂无解析

  • 第24题：

    单选题
    Which of the following commands should be used to view and change the network filesystem tuning parameters available on the system？（）
    A

     no

    B

     nfso

    C

     vmtune

    D

     exportfs


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

相关内容