单选题Which view should a user query to display the columns associated with the constraints on a table owned by the user? （）A USER_CONSTRAINTSB USER_OBJECTSC ALL_CONSTRAINTSD USER_CONS_COLUMNSE USER_COLUMNS

题目
单选题
Which view should a user query to display the columns associated with the constraints on a table owned by the user? （）
A

USER_CONSTRAINTS

B

USER_OBJECTS

C

ALL_CONSTRAINTS

D

USER_CONS_COLUMNS

E

USER_COLUMNS

相似考题

1.Which view should a user query to display the columns associated with the constraints on a table owned by the user? ()A. USER_CONSTRAINTSB. USER_OBJECTSC. ALL_CONSTRAINTSD. USER_CONS_COLUMNSE. USER_COLUMNS

2.The EMP table contains these columns:You need to display the employees who have not been assigned to any department.You write the SELECT statement:What is true about this SQL statement?()A. The SQL statement displays the desired results.B. The column in the WHERE clause should be changed to display the desired results.C. The operator in the WHERE clause should be changed to display the desired results.D. The WHERE clause should be changed to use an outer join to display the desired results.

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 data dictionary table should you query to view the object privileges granted to the user on specific columns? ()A. USER_TAB_PRIVS_MADEB. USER_TAB_PRIVSC. USER_COL_PRIVS_MADED. USER_COL_PRIVS

参考答案和解析
正确答案： D
解析： 暂无解析
更多“Which view should a user query to display the columns associ”相关问题

  • 第1题：

    Which data dictionary table should you query to view the object privileges granted to the user on specific columns?（）

    • A、USER_TAB_PRIVS_MADE
    • B、USER_TAB_PRIVS
    • C、USER_COL_PRIVS_MADE
    • D、USER_COL_PRIVS

    正确答案:D

  • 第2题：

     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

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

    When a database administrator chooses the dimensions for an MDC table, which two characteristics should beconsidered?（）

    • A、the query transaction rate 
    • B、numeric data versus character data  
    • C、extent size  
    • D、the cardinality of the candidate columns  
    • E、prefetch size 

    正确答案:C,D

  • 第5题：

    A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL> connect smith/smith  Connected.  SQL> SELECT * FROM v$session；  SELECT * FROM v$session *  ERROR at line 1：  ORA-00942： table or view does not exist  Which are the two possible solutions to enable SMITH to query the data in V$SESSION（）

    • A、granting SELECT privilege to SMITH on V$SESSION
    • B、granting SELECT privilege to SMITH on V_$SESSION
    • C、asking the user SMITH to run the catalog.sql script
    • D、granting SELECT privilege to SMITH on V$FIXED_TABLES
    • E、setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE
    • F、creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created

    正确答案:B,F

  • 第6题：

    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A SQL Server 2005 application is utilized by the company. A query is executed by the application to return three columns of the nvarchar data type and one column of the XML data type. A WHERE clause is utilized by the query， and all three of the nvarchar columns are contained by the WHERE clause. 5 million rows are included by the table， and 50，000 rows are returned by the query. The performance of the query should be enhanced. Which action should be performed to achieve the goal？（）

    • A、A primary XML index should be created on the XML column.
    • B、Statistics should be created on the nvarchar columns.
    • C、A view should be created， and only the four columns that the query utilizes are contained by a view.
    • D、A composite index should be created on the three nvarchar columns， and INCLUDE should be specified for the XML column.

    正确答案:D

  • 第7题：

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


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

  • 第8题：

    单选题
    You need to create a form for Payroll application that will allow the user to view all information for any employee ID queried. This data should be displayed to the user in a grouped format. The user should be able to choose which information they want to see from a pull down list containing the values PERSONAL and PAYROLL. Which format should you use to create this form?（）
    A

    One content canvas and multiple stacked canvases. 

    B

    One content and one stacked canvas.

    C

    Tab canvas with several tab pages. 

    D

    One content canvas. 

    E

    A horizontal and vertical toolbar.


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

  • 第9题：

    单选题
    You are the network administrator for The network consists of a single Active Directory domain named The TestKing Staff department has a Windows 2003 computer that functions as a file server. The computer contains a folder named TestKingData. Auditing is enabled on the TestKingData folder. The TestKing Staff department reports that confidential files were deleted from the folder. You need to identify the user who deleted the confidential files. What should you do?（）
    A

    In Event Viewer, create a new log view from the security log. Filter the log view to display only success audits.

    B

    In Event Viewer, create a new log view from the security log. Filter the log view to display only failure audits.

    C

    In Event Viewer, create a new log view from the system log. Filter the log view to display only success audits.

    D

    In Event Viewer, create a new log view from the system log. Filter the log view to display only failure audits.


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

  • 第10题：

    单选题
    Which data dictionary table should you query to view the object privileges granted to the user on specific columns?（）
    A

    USER_TAB_PRIVS_MADE

    B

    USER_TAB_PRIVS

    C

    USER_COL_PRIVS_MADE

    D

    USER_COL_PRIVS


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

  • 第11题：

    单选题
    nancy used a rich text field on a form to capture data. she would like to display the data in a view. which of the following should she do?（）
    A

    use @texttorichtext

    B

    use a richtext title field

    C

    use the @text（fieldname） in the  column formula

    D

    nothing rich text display in the views


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

  • 第12题：

    单选题
    Which view should a user query to display the columns associated with the constraints on a table owned by the user?（）
    A

    USER_CONSTRAINTS

    B

    USER_OBJECTS

    C

    ALL_CONSTRAINTS

    D

    USER_CONS_COLUMNS

    E

    USER_COLUMNS


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

  • 第13题：

    Which view should a user query to display the columns associated with the constraints on a table owned by the user?（）

    • A、USER_CONSTRAINTS
    • B、USER_OBJECTS
    • C、ALL_CONSTRAINTS
    • D、USER_CONS_COLUMNS
    • E、USER_COLUMNS

    正确答案:D

  • 第14题：

    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.

    正确答案:D

  • 第15题：

    A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?（）

    • A、Table
    • B、Columns
    • C、Table and Alias
    • D、Columns and Alias

    正确答案:A

  • 第16题：

    You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）

    • A、 V$BACKUP_CORRUPTION
    • B、 V$COPY_CORRUPTION
    • C、 V$DATABASE_BLOCK_CORRUPTION
    • D、 RC_BACKUP_CORRUPTION

    正确答案:C

  • 第17题：

    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005.You work as a database administrator for your company. You find a problem that when the following query is executed， a SQL Server 2005 application will perform slowly. SELECT * FROM Orders WHERE OrderStatus = ’InProgress’ This query is executed by the application as an ad hoc query. In most occasions， this query performs much more quickly. The company has the OrderStatus column indexed. The value InProgress is included by only a small number of the rows. Nevertheless， the OrderStatus column index which is the most ideal for this query is not being utilized. The performance of this query should be enhanced. However， the application that executes the query should not be changed. In addition， the effect on end users should be cut to the least.  Which action should be performed to finish the task？（）

    • A、To finish the task， the index should be built by utilizing a FILLFACTOR of 10 percent.
    • B、To finish the task， the index should be recreated to have all of the columns in the table included.
    • C、To finish the task， an indexed view of the Orders table should be viewed.
    • D、To finish the task， the statistics should be updated on the index.

    正确答案:D

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

    单选题
    You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?（）
    A

    Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. 

    B

    Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 

    C

    Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. 

    D

    Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. 

    E

    Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.


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

  • 第20题：

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


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

  • 第21题：

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


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

  • 第22题：

    单选题
    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A SQL Server 2005 application is utilized by the company. A query is executed by the application to return three columns of the nvarchar data type and one column of the XML data type. A WHERE clause is utilized by the query， and all three of the nvarchar columns are contained by the WHERE clause. 5 million rows are included by the table， and 50，000 rows are returned by the query. The performance of the query should be enhanced. Which action should be performed to achieve the goal？（）
    A

    A primary XML index should be created on the XML column.

    B

    Statistics should be created on the nvarchar columns.

    C

    A view should be created， and only the four columns that the query utilizes are contained by a view.

    D

    A composite index should be created on the three nvarchar columns， and INCLUDE should be specified for the XML column.


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

  • 第23题：

    单选题
    You are creating the SAL_INFO data block on the EMP_QUERY form. The SALARY field should only be populated if the logged-on user is a manager. Since this query could potentially return a large amount of records, you have created a stored procedure which uses a ref cursor on which to base the data block. How would you create the data block?（）
    A

    Click the Data Blocks node in the Object Navigator and click the create button. Choose to build the data block manually. Enter the procedure name in the Query Data Source Columns property and the procedure code in the Query Data Source Arguments property. 

    B

    Choose Tools -> Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure. 

    C

    Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Ref cursor', and enter the name of the procedure in the Query Data Source Name property. 

    D

    Select the Data Blocks node in the Object Navigator and click the Create button. Alter the Query Data Source Name, Query Data Source Columns, and Query Data Source Arguments properties to create a stored procedure that uses a ref cursor. 

    E

    Launch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure.


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

  • 第24题：

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

相关内容