单选题Which view should a user query to display the columns associated with the constraints on a table owned by the user?（）AUSER_CONSTRAINTSBUSER_OBJECTSCALL_CONSTRAINTSDUSER_CONS_COLUMNSEUSER_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
参考解析
解析：
暂无解析
相关考题：
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 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
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.
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 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
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
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
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.
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
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、TableB、ColumnsC、Table and AliasD、Columns and Alias
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
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_CORRUPTIONB、 V$COPY_CORRUPTIONC、 V$DATABASE_BLOCK_CORRUPTIOND、 RC_BACKUP_CORRUPTION
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$SESSIONB、granting SELECT privilege to SMITH on V_$SESSIONC、asking the user SMITH to run the catalog.sql scriptD、granting SELECT privilege to SMITH on V$FIXED_TABLESE、setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUEF、creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
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.
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.
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
单选题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
单选题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?（）ASelect 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. BChoose Tools - Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. CChoose Tools - Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. DSelect 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. ESelect 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.
单选题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?（）AOne content canvas and multiple stacked canvases. BOne content and one stacked canvas.CTab canvas with several tab pages. DOne content canvas. EA horizontal and vertical toolbar.
单选题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
单选题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?（）AIn Event Viewer, create a new log view from the security log. Filter the log view to display only success audits.BIn Event Viewer, create a new log view from the security log. Filter the log view to display only failure audits.CIn Event Viewer, create a new log view from the system log. Filter the log view to display only success audits.DIn Event Viewer, create a new log view from the system log. Filter the log view to display only failure audits.
单选题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 data dictionary table should you query to view the object privileges granted to the user on specific columns?（）AUSER_TAB_PRIVS_MADEBUSER_TAB_PRIVSCUSER_COL_PRIVS_MADEDUSER_COL_PRIVS
单选题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？（）AA primary XML index should be created on the XML column.BStatistics should be created on the nvarchar columns.CA view should be created， and only the four columns that the query utilizes are contained by a view.DA composite index should be created on the three nvarchar columns， and INCLUDE should be specified for the XML column.
单选题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?（）Ause @texttorichtextBuse a richtext title fieldCuse the @text（fieldname） in the column formulaDnothing rich text display in the views
单选题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?（）AClick 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. BChoose Tools - Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure. CSelect 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. DSelect 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. ELaunch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure.
单选题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?（）ACreate a new Time dimension based on the Holiday table. Use derived columns for the month and the year.BCreate a Server Time dimension. Within this dimension， enable the time periods year， month， and date. Select the Additional Manufacturing calendar option.CCreate a new Time dimension based on the date values within the ProductOrderStatus table. Flag those days on which no orders were received as Holiday.DCreate 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.